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
