ODBC Provider errors "Data source name not found"

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
MikeMyhre
Posts: 4
Joined: Thu 16 Aug 2012 00:46

ODBC Provider errors "Data source name not found"

Post by MikeMyhre » 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?

MikeMyhre
Posts: 4
Joined: Thu 16 Aug 2012 00:46

Re: ODBC Provider errors "Data source name not found"

Post by MikeMyhre » Wed 11 Sep 2019 14:26

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.

Stellar
Devart Team
Posts: 334
Joined: Tue 03 Oct 2017 11:00

Re: ODBC Provider errors "Data source name not found"

Post by Stellar » Thu 12 Sep 2019 11:47

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

Post Reply