Connect using PostgreSQL ODBC without driver installed

Asked Dec 13 '19 at 03:52

Active Dec 13 '19 at 03:52

Viewed 1,082 times

I tried to connect using PostgreSQL ODBC(psqlODBC 12.0) without the driver installed on Windows x64.

I placed all the files below in a directory. They were extracted from a MSI file.

libcrypto-1_1-x64.dll
libpq.dll
libssl-1_1-x64.dll
msvcp140.dll
pgenlist.dll
pgenlist.pdb
pgenlista.dll
pgenlista.pdb
pgxalib.dll
psqlodbc30a.dll
psqlodbc30a.pdb
psqlodbc35w.dll
psqlodbc35w.pdb
vcruntime140.dll

The connection string is as follows.

"DRIVER=C:\\tmp\\psqlodbc35w.dll;SERVER=localhost;Port=5432;Database=dbname;Uid=user;Pwd=password;"

But that didn't work. The error message is

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

According to this question(Connect ODBC without driver installed), it seems possible to specify a driver DLL path instead of a driver name. Do I overlook anything?

asked Dec 13 '19 at 03:52

Wakusei

Have you tried specifying the path without the double backslashes, i.e., `DRIVER=C:\tmp\psqlodbc35w.dll` ...? – Gord Thompson Dec 13 '19 at 11:53
I forgot to write the language. It's C++, so double backslahes are needed. The ODBC system DLL in the OS receives with single backslash. DRIVER=C:\tmp\psqlodbc35w.dll – Wakusei Dec 16 '19 at 04:39
Try adding the folder containing the DLLs to your Windows PATH environment variable. – Gord Thompson Dec 16 '19 at 04:47
Actually I put all the DLLs in the System32, but the same error occuurred. I also tried LoadLibrary("psqlodbc35w.dll") and it suceeded. DLL dependece was correctly resolved. – Wakusei Dec 17 '19 at 09:28
Are you running 64-bit Python? – Gord Thompson Dec 17 '19 at 11:59
No. I'm using Visual C++ x64. – Wakusei Dec 18 '19 at 23:25

Connect using PostgreSQL ODBC without driver installed

0 Answers0