ODBC Provider errors "Data source name not found"
Posted: Wed 11 Sep 2019 02:58
I am trying to use the UniDac TUniConnection component to connect via ODBC.
It seems like all you need to do is change the provider to the ODBC provider and set the database/username/password info.
I get an error when trying to open the database:
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
This is a 32 bit app and I have verified the 32 bit version odbcad32.exe (from SysWow64).
Other SQL Client editors (32 bit also) are able to connect to the same ODBC name without an error.
All of my other providers (MySQL, SQLite, PostgreSQL) work when going direct (with the addition of the Server property and changing the provider from ODBC to MySQL, etc.).
Any idea what the solution to my problem could be?
It seems like all you need to do is change the provider to the ODBC provider and set the database/username/password info.
I get an error when trying to open the database:
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
This is a 32 bit app and I have verified the 32 bit version odbcad32.exe (from SysWow64).
Other SQL Client editors (32 bit also) are able to connect to the same ODBC name without an error.
All of my other providers (MySQL, SQLite, PostgreSQL) work when going direct (with the addition of the Server property and changing the provider from ODBC to MySQL, etc.).
Any idea what the solution to my problem could be?