[ psqlodbc-Bugs-1000417 ] odbc_lib_connect() returns "Specified driver could not be loaded due to system error 182 (PostgreSQL ANSI)"

Bugs item #1000417, was opened at 2005-11-08 09:08
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000417&group_id=1000125

Category: None
Group: None
Status: Closed
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: odbc_lib_connect() returns "Specified driver could not be loaded due to system error 182 (PostgreSQL ANSI)"

Initial Comment:
Hi,

WinXP Pro
PostgreSQL 8.1
psqlodbc 8.01.01 5/11/2005

This is fresh installation. Psql works fine. PgAdmin works fine. Just ODBC returns the error mentioned in the summary,

Jano1122(at)hotmail(dot)com

----------------------------------------------------------------------

Comment By: Henrik Nordberg (hnordberg)
Date: 2006-08-24 12:16

Message:
Problem solved.

The cause was an older version of libeay32.dll in the path.

----------------------------------------------------------------------

Comment By: Henrik Nordberg (hnordberg)
Date: 2006-01-27 11:34

Message:
I have the same problem.
WinXP Pro
PostgreSQL 8.1.2-1

I used to have PostgreSQL 8 installed, but I uninstalled it before installing 8.1.2-1.

I run this in an installer. The installer logs in twice. First to verify that it has permissions to create databases, then to actually create them. The first time it works, the second time I get this error.

----------------------------------------------------------------------

Comment By: Dave Page (dpage)
Date: 2005-11-24 06:25

Message:
No response from original poster. Tracker closed.

----------------------------------------------------------------------

Comment By: Nobody (None)
Date: 2005-11-17 06:28

Message:
I had the same problem, due to a parallel installation of PgOleDb. When I removed PgOleDb, I was able to connect again.

Regards,
Christian

----------------------------------------------------------------------

Comment By: Dave Page (dpage)
Date: 2005-11-14 00:30

Message:
Can you confirm that the following files can be found alongside psqlodbca.dll in the installation directory:

libpq.dll
krb5_32.dll
comerr32.dll
libintl-2.dll
libiconv-2.dll
libeay32.dll
ssleay32.dll

Also, please check the path to the driver is correct in the registry key: HKEY_LOCAL_MACHINE\Software\ODBC\odbcinst.ini\PostgreSQL ANSI\driver

----------------------------------------------------------------------

Comment By: Dave Page (dpage)
Date: 2005-11-14 00:26

Message:
>From 1000418:

Hi,
t
he psqlodbc 07.03.0200 works just fine. I have it up and running :-) but 8.01.01 fails :-(

Regards,
Jano1122(at)hotmail(dot)com

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000417&group_id=1000125