Re: Module not found on connection

:1) Does C:\Windows\System32\psqlodbc.dll exist on your
:system? It should
:be around 200kb iirc.

That file seems OK

:2) Can you try logging in whilst logged into XP as
:an Administrator?

Yes .. problam is the same

:3) Also, there used to be an MDAC checker at www.microsoft.com/data

OK, this shows MSDADC.dll as not being found in a program directory
(SAP business warehouse frontend). Probably the result of a brute
force installation process on their part.

I've edited the class-id's associated with this file in the registry
(after backing up the keys of course). The DAC check now runs
without errors but I now get 'Error in the DLL' in frmConnect.cmdConnect_Click
with PGAdmin. Funnily enough your connection debugging tool connects
OK(?). DBTools still connects too.

An ODBC trace shows the following:
pgAdmin2 a2c-7f8 ENTER SQLAllocEnv
HENV * 1F6CCDBC

pgAdmin2 a2c-7f8 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x1F6CCDBC ( 0x02601540)

pgAdmin2 a2c-7f8 ENTER SQLGetEnvAttr
SQLHENV 02601540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0012D110

pgAdmin2 a2c-7f8 EXIT SQLGetEnvAttr with return code
0 (SQL_SUCCESS)
SQLHENV 02601540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0012D110 (1390040)

pgAdmin2 a2c-7f8 ENTER SQLAllocEnv
HENV * 1F6CCDC0

pgAdmin2 a2c-7f8 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x1F6CCDC0 ( 0x026015e8)

pgAdmin2 a2c-7f8 ENTER SQLSetEnvAttr
SQLHENV 026015E8
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6

pgAdmin2 a2c-7f8 EXIT SQLSetEnvAttr with return code
0 (SQL_SUCCESS)
SQLHENV 026015E8
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6
Regards,
Paul Conway

_____________________________________________
A t l a s W e b m a i l . c o m