Devart Forums

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?

Just found the issue (after way too long and no help from documentation).
For ODBC, the ODBC name is entered in the Server property not the Database property as one would guess.
Leave Database property blank.

Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.