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.
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.
Selected Articles