Thread: Module not found on connection

Module not found on connection

From
"pct"
Date:
When I try to connect to my database I am getting the following
error from pgAdmin:

An error has occurred in pgAdmin II:frmConnect.cmdConnect_Click

Number=-2157024770
Description: The specified module could not be found.

I am using postgresql 7.2.1 and pgAdmin II 1.2.0

The Full Debug log output for the connection is:
8/2/2002 4:42:19 PM - Connecting to localhost...
8/2/2002 4:42:19 PM - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
8/2/2002 4:42:19 PM - Entering pgSchema:pgServer.Property Let
MasterDB("template1")
8/2/2002 4:42:19 PM - Entering pgSchema:pgServer.Connect("localhost",
5432, "administrator", "********")
8/2/2002 4:42:19 PM - Opening cnPostgreSQL:
SERVER=localhost;PORT=5432;UID=administrator;PWD=********;DATABASE=template1;DRIVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=1;
8/2/2002 4:42:19 PM - Done - 0.04 Secs.
8/2/2002 4:42:19 PM - Error in pgAdmin II:frmConnect.cmdConnect_Click:
-2147024770 - The specified module could not be found.

Any help is greatfully appreciated.

Regards,
Paul Conway


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



Re: Module not found on connection

From
"Dave Page"
Date:

> -----Original Message-----
> From: pct [mailto:pct@AtlasWebmail.com]
> Sent: 02 August 2002 16:44
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Module not found on connection
>
>
> When I try to connect to my database I am getting the
> following error from pgAdmin:
>
> An error has occurred in pgAdmin II:frmConnect.cmdConnect_Click
>
> Number=-2157024770
> Description: The specified module could not be found.
>
> I am using postgresql 7.2.1 and pgAdmin II 1.2.0

What OS are you running on? Can you try (re)installing MDAC 2.6 or
higher?

Regards, Dave.

Re: Module not found on connection

From
"pct"
Date:
I initally installed the new PostgresSQL ODBC drivers. I then
uninstalled the drivers and re-installeed 1.2.0. It still did
not work so I uninstalled 1.2.0 and installed 1.3.6. That didn't
help. So I'm back at 1.2.0 using the ODBC driver from the PGAdmin
install.

I've uncommented tcpip_socket = true and port=5432 in my postgresql.ini
and netstat shows the port listening.

I did manage to get DBTools to connect to my database via ODBC
but that tool is less than ideal.

Regards,
Paul Conway

----Original Message-----
On Fri, 2 Aug 2002 23:11:55 +0100,
"Dave Page" <dpage@vale-housing.co.uk> wrote:
:
:
:
:
:> -----Original Message-----
:> From: pct [mailto:pct@AtlasWebmail.com]
:> Sent: 02 August 2002 16:44
:> To: pgadmin-support@postgresql.org
:> Subject: [pgadmin-support] Module not found on connection
:>
:>
:> When I try to connect to my database I am getting
:> the
:> following error from pgAdmin:
:>
:> An error has occurred in pgAdmin II:frmConnect.cmdConnect_Click
:>
:> Number=-2157024770
:> Description: The specified module could not be found.
:>
:> I am using postgresql 7.2.1 and pgAdmin II 1.2.0
:
:
:What OS are you running on? Can you try (re)installing
:MDAC 2.6 or
:higher?
:
:
:Regards, Dave.
:
:
:---------------------------(end of broadcast)---------------------------
:TIP 4: Don't 'kill -9' the postmaster
:
:



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



Re: Module not found on connection

From
"Dave Page"
Date:

> -----Original Message-----
> From: pct [mailto:pct@AtlasWebmail.com]
> Sent: 02 August 2002 18:20
> To: Dave Page
> Subject: Re: RE: [pgadmin-support] Module not found on connection
>
>
> I'm running Windows XP Pro edition. I believe that DAC is
> built in on XP (?)

Yes it is. The error you're getting appears to generally occur if a DLL
cannot be accessed. As it happens when you try to log on, we can fairly
safely assume that it is something to do with MDAC or the ODBC driver
(all the other bits of pgAdmin should either be loaded, or not installed
by then).

There are a number of things that can be checked:

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

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

3) Also, there used to be an MDAC checker at www.microsoft.com/data -
can you download that and check your system?

Regards, Dave.

Re: Module not found on connection

From
"pct"
Date:

: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



Re: Module not found on connection

From
"Dave Page"
Date:

> -----Original Message-----
> From: pct [mailto:pct@AtlasWebmail.com]
> Sent: 02 August 2002 19:54
> To: pgadmin-support@postgresql.org
> Cc: Dave Page
> Subject: RE: [pgadmin-support] 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.

Ugh. If you've got to the stage where you're editting classids then
something is definately screwy on your machine. Can you fix your MDAC
properly by re-running the XP setup from the install CD?

Regards, Dave.