[pgadmin-support] frmConnect.cmd Connect_Click: 429 - Class not registered
When attempting to connect to the database I receive this error message:
==
|An error has occurred in pgAdmin II:frmConnect.cmdConnect_Click: |
|
|
|Number: 429
|
|Description: Class not registered
|
==
The database is PostgreSQL version 7.1.3 running on RH 7.2.
The is the relevant output from the windows debug.log
=
2003-01-03 09:13:26 - Entering pgAdmin II:frmConnect.Load_Defaults(0)
2003-01-03 09:13:26 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 1")
2003-01-03 09:13:39 - Entering pgAdmin II:frmConnect.cmd Connect_Click()
2003-01-03 09:13:39 - Connecting to pbz50.pbzinc.loc...
2003-01-03 09:13:39 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
2003-01-03 09:13:39 - Entering pgSchema:pgServer.Property Let
MasterDB("template1")
2003-01-03 09:13:40 - Entering pgSchema:pgServer.Connect("pbz50.pbzinc.loc",
5432, "postgres", "")
2003-01-03 09:13:40 - Opening cnPostgreSQL:
SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres;PWD=;DATABASE=templat
e1;DRIVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=
0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNK
NOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;U
SEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;P
ARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=1;
2003-01-03 09:13:41 - Entering pgSchema:pgServer.ExecSQL("SELECT version()",
"Connection: Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL};DAT
ABASE=template1;SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres;PWD=;ReadOnly
=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTab
les=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;
MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetc
h=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;Cancel
AsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;Dis
allowPremature=0;TrueIsMinus1=0;BI=0"", 0, -1, 1)
2003-01-03 09:13:41 - SQL (template1): SELECT version()
2003-01-03 09:13:42 - Done - 2.18 Secs.
2003-01-03 09:13:42 -
***
2003-01-03 09:13:42 - Error(s)
2003-01-03 09:13:42 -
***
2003-01-03 09:13:42 - Error in pgAdmin II:frmConnect.cmd Connect_Click:
429 - Class not registered
2003-01-03 09:13:42 - The following error(s) have been logged:
-2147221164 - Class not registered
2003-01-03 09:13:42 - Windows Version: Windows ME v4.90 build 3000
2003-01-03 09:13:42 - pgSchema Version: 1.4.12
2003-01-03 09:13:42 - MDAC Version: 2.6
2003-01-03 09:13:42 - DBMS Version: 07.02.0005 PostgreSQL 7.1.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2003-01-03 09:13:42 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=pbz50.pbzinc.loc;P
ORT=5432;UID=postgres;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;Sh
owOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Soc
ket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;
CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsA
sLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixe
s=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;B
I=0"
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] frmConnect.cmd Connect_Click: 429 - Class not registered
When attempting to connect to the database I receive this error message:
==
|An error has occurred in pgAdmin II:frmConnect.cmdConnect_Click: |
|
|
|Number: 429
|
|Description: Class not registered
|
==
The database is PostgreSQL version 7.1.3 running on RH 7.2.
The is the relevant output from the windows debug.log
=
2003-01-03 09:13:26 - Entering pgAdmin II:frmConnect.Load_Defaults(0)
2003-01-03 09:13:26 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 1")
2003-01-03 09:13:39 - Entering pgAdmin II:frmConnect.cmd Connect_Click()
2003-01-03 09:13:39 - Connecting to pbz50.pbzinc.loc...
2003-01-03 09:13:39 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
2003-01-03 09:13:39 - Entering pgSchema:pgServer.Property Let
MasterDB("template1")
2003-01-03 09:13:40 - Entering pgSchema:pgServer.Connect("pbz50.pbzinc.loc",
5432, "postgres", "")
2003-01-03 09:13:40 - Opening cnPostgreSQL:
SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres;PWD=;DATABASE=templat
e1;DRIVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=
0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNK
NOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;U
SEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;P
ARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=1;
2003-01-03 09:13:41 - Entering pgSchema:pgServer.ExecSQL("SELECT version()",
"Connection: Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL};DAT
ABASE=template1;SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres;PWD=;ReadOnly
=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTab
les=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;
MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetc
h=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;Cancel
AsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;Dis
allowPremature=0;TrueIsMinus1=0;BI=0"", 0, -1, 1)
2003-01-03 09:13:41 - SQL (template1): SELECT version()
2003-01-03 09:13:42 - Done - 2.18 Secs.
2003-01-03 09:13:42 -
***
2003-01-03 09:13:42 - Error(s)
2003-01-03 09:13:42 -
***
2003-01-03 09:13:42 - Error in pgAdmin II:frmConnect.cmd Connect_Click:
429 - Class not registered
2003-01-03 09:13:42 - The following error(s) have been logged:
-2147221164 - Class not registered
2003-01-03 09:13:42 - Windows Version: Windows ME v4.90 build 3000
2003-01-03 09:13:42 - pgSchema Version: 1.4.12
2003-01-03 09:13:42 - MDAC Version: 2.6
2003-01-03 09:13:42 - DBMS Version: 07.02.0005 PostgreSQL 7.1.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2003-01-03 09:13:42 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=pbz50.pbzinc.loc;P
ORT=5432;UID=postgres;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;Sh
owOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Soc
ket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;
CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsA
sLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixe
s=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;B
I=0"
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Re: [pgadmin-support] frmConnect.cmd Connect_Click: 429 - Class not registered
Please try (re)installing MDAC 2.7 from http://www.microsoft.com/data
Regards, Dave.
> -Original Message-
> From: Marvin Horst [mailto:[EMAIL PROTECTED]]
> Sent: 03 January 2003 14:28
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] frmConnect.cmd Connect_Click: 429
> - Class not registered
>
>
> When attempting to connect to the database I receive this
> error message:
>
> ==
> |An error has occurred in pgAdmin
> II:frmConnect.cmdConnect_Click: |
> |
> |
> |Number: 429
> |
> |Description: Class not registered
> |
> ==
>
> The database is PostgreSQL version 7.1.3 running on RH 7.2.
>
> The is the relevant output from the windows debug.log
>
> =
> 2003-01-03 09:13:26 - Entering pgAdmin
> II:frmConnect.Load_Defaults(0) 2003-01-03 09:13:26 - Entering
> pgAdmin II:basRegistry.RegRead(-2147483647,
> "Software\pgAdmin II\Connections", "Connection 1")
> 2003-01-03 09:13:39 - Entering pgAdmin II:frmConnect.cmd
> Connect_Click() 2003-01-03 09:13:39 - Connecting to
> pbz50.pbzinc.loc... 2003-01-03 09:13:39 - Entering pgAdmin
> II:basRegistry.RegRead(-2147483647,
> "Software\pgAdmin II", "Master DB")
> 2003-01-03 09:13:39 - Entering pgSchema:pgServer.Property Let
> MasterDB("template1")
> 2003-01-03 09:13:40 - Entering
> pgSchema:pgServer.Connect("pbz50.pbzinc.loc",
> 5432, "postgres", "")
> 2003-01-03 09:13:40 - Opening cnPostgreSQL:
> SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres;PWD=;DA
> TABASE=templat
> e1;DRIVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;
> SHOWOIDCOLUMN=
> 0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;S
> OCKET=4096;UNK
> NOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMI
> ZER=1;KSQO=1;U
> SEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;B
> OOLSASCHAR=1;P
> ARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=1;
> 2003-01-03 09:13:41 - Entering
> pgSchema:pgServer.ExecSQL("SELECT version()",
> "Connection: Provider=MSDASQL.1;Extended
> Properties="DRIVER={PostgreSQL};DAT
> ABASE=template1;SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres
> ;PWD=;ReadOnly
> =0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0
> ;ShowSystemTab
> les=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVa
> rcharSize=254;
> MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;
> UseDeclareFetc
> h=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;
> Parse=0;Cancel
> AsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;Updatabl
> eCursors=1;Dis
> allowPremature=0;TrueIsMinus1=0;BI=0"", 0, -1, 1)
> 2003-01-03 09:13:41 - SQL (template1): SELECT version()
> 2003-01-03 09:13:42 - Done - 2.18 Secs.
>
> 2003-01-03 09:13:42 -
> ***
> 2003-01-03 09:13:42 - Error(s)
> 2003-01-03 09:13:42 -
> ***
> 2003-01-03 09:13:42 - Error in pgAdmin II:frmConnect.cmd
> Connect_Click: 429 - Class not registered 2003-01-03 09:13:42
> - The following error(s) have been logged:
>
> -2147221164 - Class not registered
>
> 2003-01-03 09:13:42 - Windows Version: Windows ME v4.90 build
> 3000 2003-01-03 09:13:42 - pgSchema Version: 1.4.12
> 2003-01-03 09:13:42 - MDAC Version: 2.6 2003-01-03 09:13:42 -
> DBMS Version: 07.02.0005 PostgreSQL 7.1.3 on
> i686-pc-linux-gnu, compiled by GCC 2.96 2003-01-03 09:13:42 -
> Connection String (Master Connection):
> Provider=MSDASQL.1;Extended
> Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=pbz5
> 0.pbzinc.loc;P
> ORT=5432;UID=postgres;PWD=;ReadOnly=0;Protocol=6.4;Fak
> eOidIndex=0;Sh
> owOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=
> ;Fetch=100;Soc
> ket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=
> 65536;Debug=1;
> CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarch
> ar=1;UnknownsA
> sLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraS
> ysTablePrefixe
> s=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;Tr
> ueIsMinus1=0;B
> I=0"
>
>
>
> ---(end of
> broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> [EMAIL PROTECTED])
>
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
