Help ! Another learner... I am trying to connect to mySQL through MyODBC using ODBC.NET and have the following setup on a W2K machine.... 1. mySQL 4.0.15 database up and running (visible in Services). The DB is definitely there (I can see its contents through
MySQL CC) 2. I have installed MySQL ODBC 3.51 Driver and created a User DSN called myDSN. I can connect to the database via the 'Test Data Source' (at least its telling me that I've connected...) 3. Using WebMatrix, I have the following declarations in place
: 4. Doing very little, I am trying to execute the following lines of code : Dim MyConnection As New OdbcConnection("DSN=myDSN") MyConnection.Open() And get the following error : ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost'
(10061) failing on the MyConnection.Open() command. Do I need to have MSDE installed to be able to access MySQL ? Do firewalls cause issues ?Would it be easier to have everything stored as XML ? I have trawled through loads of great instructions and sound
advice on this forum and other places - but it escapes me why I am getting this error... TIA, FP
Flatpass
Member
10 Points
2 Posts
Problems connecting to MySQL through MyODBC using ODBC.NET
Oct 28, 2003 08:30 PM|LINK