Please try (re)installing MDAC 2.7 from http://www.microsoft.com/data
Regards, Dave.
> -----Original Message-----
> From: Marvin Horst [mailto:marvinh@pbzinc.com]
> Sent: 03 January 2003 14:28
> To: pgadmin-support@postgresql.org
> 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
> majordomo@postgresql.org)
>
