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

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

Previous Fields

Dream Kudos:
0
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};SERVER=test.server.com;DATABASE=dbname;USER=username; PASSWORD=password;OPTION=3;";
    OdbcConnection myConnection = new OdbcConnection(myConnString);
    myConnection.Open();
    
  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=\\ns1.sky.uk.net\mydomain.com\public_html\data\db.mdb;
    Driver={Microsoft Access Driver (*.mdb)};Dbq=\\ns1.sky.uk.net\mydomain.com\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 www.mydomain.com/data/db.mdb however when I access this through ftp I go through mydomain.com/public_html/data/db.mdb

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

    \\01.234.56.78\home\mydomain.com\data\db.mdb
    
    


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

My Information

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

Contact Information

E-mail:
Private

Friends

mdavies1983 hasn't added any friends yet.

Comments

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