Machine Data Source

I've set up a Machine DSN to MySQL via 3.51, and now am trying to create a connection string, but having an issue where the ODBC Window appears as the code is running, and I don't want the users to have to select the DSN manually.

My connection string is: myConnect = "ODBC; DSN = sqlDatabase"

I previously tried "ODBC; DRIVER = {mysql odbc 3.51 driver}; DATA SOURCE = blablabla;" string, but was getting failures there, which led me to believe that since I had pre-setup the DSN, the direct method made more sense.

However, I can't get the ODBCAD32 window to stop popping up.

This is my first attempt at using an SQL pass-through query. Any help would be appreciated.

0
edit delete
are you sure?
asked Greg Floes

1 answer

Popping up window may be the result of driver bits incompatibility with your OS. I don't know what bits your OS is but I recommend you to download mysql ODBC driver which supports both 32 and 64 bits systems and try it.

Here is an example of working connection string with this driver:

Login Prompt=False;User ID=root;Password=root;Data Source=localhost;Database=test

0
edit delete
are you sure?
answered Dan Wake

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions