mdavies1983's Profile User Rating: -----

Reputation: 0 Apprentice
New Members
Active Posts:
9 (0.01 per day)
27-June 12
Profile Views:
Last Active:
User is offline Oct 02 2012 08:08 AM

Previous Fields

Dream Kudos:
Icon   mdavies1983 has not set their status

Posts I've Made

  1. In Topic: Intermittent OleDb Problem

    Posted 2 Oct 2012

    Thanks for the quick reply, I was simply missing dr.Close() from a couple of the calling methods...

    Slightly embarrassed yet relieved at the simplicity of the solution! :stupid:
  2. In Topic: Can't Connect to SQL Database

    Posted 7 Aug 2012

    I opted for the ODBC approach and have it working now. Thank you!

    string myConnString = "DRIVER={MySQL ODBC 5.1 Driver};;DATABASE=dbname;USER=username; PASSWORD=password;OPTION=3;";
    OdbcConnection myConnection = new OdbcConnection(myConnString);
  3. In Topic: Connecting to a remote Access Database

    Posted 28 Jun 2012

    Thanks, I had a feeling it'd end up with sql so I will give that a try. I'm more of a beginner when it comes to sql but I should have enough knowledge to replicate the access database.

    The web hosting company that I use provides me with a free MySql database. Could I utilize this so that both my website and winforms app can access it or will I need to go down another route? Any pointers would be greatly appreciated.
  4. In Topic: Connecting to a remote Access Database

    Posted 27 Jun 2012

    Have tried both and get the same error which is around 30 lines long stating that the [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Invalid connection string attribute provider. Invalid connection string attribute provider data source.

    Having looked through the documentation I received from Sky.UK.Net I have found the domain name server so I'm assuming I should be using this instead of the IP address.

    So I currently have the domain name server, the database filepath and the database password but I'm unsure how to put these together.

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\public_html\data\db.mdb;
    Driver={Microsoft Access Driver (*.mdb)};Dbq=\\\\public_html\data\db.mdb;
  5. In Topic: Connecting to a remote Access Database

    Posted 27 Jun 2012

    Thanks for the quick response.

    Would UNC be the IP address?

    The database is saved in the subfolder however when I access this through ftp I go through

    If I use the IP address, I assume it would look similar to this


    Though I'm unsure what the 'home' part of the string would relate to.

My Information

Member Title:
New D.I.C Head
Age Unknown
Birthday Unknown

Contact Information



mdavies1983 hasn't added any friends yet.


mdavies1983 has no profile comments yet. Why not say hello?