Re: Run-time error '430'

Can you try updating MDAC to the latest version from http://www.microsoft.com/data please?

Regards, Dave.

> -----Original Message-----
> From: Albin Blaschka [mailto:Albin(dot)blaschka(at)gumpenstein(dot)at]
> Sent: 18 June 2003 11:04
> To: 'pgadmin-support(at)postgresql(dot)org'
> Subject: [pgadmin-support] Run-time error '430'
>
>
>
> Hello!
>
> On Windows 98 (Postgres 7.3.2 on Linux Debian 3.0) pgAdmin
> 1.4.12 was running fine, then I updated to 1.5.60-dev
> (staying on Win98)
> and now when pgAdmin starts, I get the Error 430:
> "Class does not support Automation or does not support
> expected interface"
>
> What could be wrong? pgAdmin 1.4.12 was running smoothly -
> What have I done wrong?
>
> Thanks in advance, Albin
>
> P.S.: Here is the output of the "full debug" - log:
> (As I am Austrian, it is in parts german)
>
> 2003-06-18 10:38:33 - Entering pgAdmin
> II:basRegistry.RegWrite(-2147483647,
> "Software\pgAdmin II", "Log Level", 1, "4")
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basRegistry.RegWrite(-2147483647,
> "Software\pgAdmin II\Log Window", "Always On Top", 1, "Y")
> 2003-06-18 10:38:34 - Entering pgSchema:pgServer.Property Let
> ShowPassword(Falsch)
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basRegistry.RegWrite(-2147483647,
> "Software\pgAdmin II", "Mask Password", 1, "Y")
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basPatch.PatchForm(frmMain) 2003-06-18 10:38:34 - Entering pgAdmin
> II:basPatch.PatchFormScrollObj(frmMain)
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basPatch.PatchFormFont(frmMain)
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basPatch.PatchFormToolTip(frmMain)
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basRegistry.RegWrite(-2147483647,
> "Software\pgAdmin II", "Font", 1, "MS Sans
> Serif|8|False|False") 2003-06-18 10:38:34 - Entering pgAdmin
> II:basRegistry.RegWrite(-2147483647,
> "Software\pgAdmin II", "AutoHighlight", 1,
> "ALTER|0|0|16711680;COMMENT|0|0|16711680;CREATE|0|0|16711680;D
> ELETE|0|0|1671
> 1680;DROP|0|0|16711680;EXPLAIN|0|0|16711680;GRANT|0|0|16711680
> ;INSERT|0|0|16
> 711680;REVOKE|0|0|16711680;SELECT|0|0|16711680;UPDATE|0|0|1671
> 1680;VACUUM|0|
> 0|16711680;AGGREGATE|0|0|255;CONSTRAINT|0|0|255;DATABASE|0|0|2
> 55;FUNCTIO
> 0|N|0|
> 0|255;GROUP|0|0|255;INDEX|0|0|255;LANGUAGE|0|0|255;OPERATOR|0|
> 0|255;RULE|0|0
> |255;SEQUENCE|0|0|255;TABLE|0|0|255;TRIGGER|0|0|255;ABORT|0|0|
> 11998061;B
> |EGIN
> |0|0|11998061;CHECKPOINT|0|0|11998061;CLOSE|0|0|11998061;CLUST
> ER|0|0|119
> |0|0|9806
> 1;COMMIT|0|0|11998061;COPY|0|0|11998061;DECLARE|0|0|11998061;F
> ETCH|0|0|11998
> 061;LISTEN|0|0|11998061;LOAD|0|0|11998061;LOCK|0|0|11998061;MO
> VE|0|0|1199806
> 1;NOTIFY|0|0|11998061;REINDEX|0|0|11998061;RESET|0|0|11998061;
> ROLLBACK|0|0|1
> 1998061;SET|0|0|11998061;SHOW|0|0|11998061;TRUNCATE|0|0|119980
> 61;UNLISTEN|0|
> 0|11998061;AND|0|0|32768;AS|0|0|32768;ASC|0|0|32768;ASCENDING|
> 0|0|32768;
> 0|BY|0
> |0|32768;CASE|0|0|32768;DESC|0|0|32768;DESCENDING|0|0|32768;EL
> SE|0|0|327
> |0|68;F
> ROM|0|0|32768;END|0|0|32768;HAVING|0|0|32768;INTO|0|0|32768;ON
> |0|0|32768
> ROM|0|0|;OR|
> 0|0|32768;ORDER|0|0|32768;THEN|0|0|32768;USING|0|0|32768;WHEN|
> 0|0|32768;
> 0|0|WHER
> E|0|0|32768;")
> 2003-06-18 10:38:34 - Entering pgSchema:pgServer.Property Get
> ConnectionString()
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basRegistry.RegRead(-2147483647,
> "Software\pgAdmin II", "Master DB")
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basRegistry.RegWrite(-2147483647,
> "Software\pgAdmin II", "Master DB", 1, "template1")
> 2003-06-18 10:38:34 - Entering pgSchema:pgServer.Property Let
> EncryptPasswords(Wahr)
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basRegistry.RegWrite(-2147483647,
> "Software\pgAdmin II", "Encrypt Passwords", 1, "Y")
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basRegistry.RegWrite(-2147483647,
> "Software\pgAdmin II", "Auto Row Count", 1, "Y")
> 2003-06-18 10:38:34 - Entering pgSchema:pgServer.Property Let
> DeferConnection("Wahr")
> 2003-06-18 10:38:34 - Entering pgAdmin
> II:basRegistry.RegWrite(-2147483647,
> "Software\pgAdmin II", "Defer Connection", 1, "Y")
> 2003-06-18 10:38:36 - Entering pgAdmin
> II:frmMain.tb_ButtonClick() 2003-06-18 10:38:36 - Entering
> pgAdmin II:frmMain.mnuPopupConnect_Click()
> 2003-06-18 10:38:36 - Entering pgAdmin
> II:frmConnect.Load_Defaults(0) 2003-06-18 10:38:36 - Entering
> pgAdmin II:basPatch.PatchForm(frmConnect) 2003-06-18 10:38:36
> - Entering pgAdmin
> II:basPatch.PatchFormScrollObj(frmConnect)
> 2003-06-18 10:38:36 - Entering pgAdmin
> II:basPatch.PatchFormFont(frmConnect)
> 2003-06-18 10:38:36 - Entering pgAdmin
> II:basPatch.PatchFormToolTip(frmConnect)
> 2003-06-18 10:38:36 - Entering pgAdmin
> II:basRegistry.RegRead(-2147483647,
> "Software\pgAdmin II\Connections", "Connection 1")
> 2003-06-18 10:38:52 - Entering pgAdmin
> II:frmConnect.cmdConnect_Click() 2003-06-18 10:38:52 -
> Connecting to baldbserver... 2003-06-18 10:38:52 - Entering
> pgAdmin II:basRegistry.RegRead(-2147483647,
> "Software\pgAdmin II", "Master DB")
> 2003-06-18 10:38:52 - Entering pgSchema:pgServer.Property Let
> MasterDB("template1")
> 2003-06-18 10:38:52 - Entering
> pgSchema:pgServer.Connect("baldbserver",
> 5432, "postgres", "********")
> 2003-06-18 10:38:52 - Opening cnPostgreSQL:
> SERVER=baldbserver;PORT=5432;UID=postgres;PWD=********;DATABAS
> E=template1;DR
> IVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWO
> IDCOLUMN=0;ROW
> VERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET
> =4096;UNKNOWNS
> IZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1
> ;KSQO=1;USEDEC
> LAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=0;BOOLSA
> SCHAR=1;PARSE=
> 0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=1;
> 2003-06-18 10:39:29 - Entering
> pgSchema:pgServer.ExecSQL("SELECT version()",
> "Connection: Provider=MSDASQL.1;Connect Timeout=15;Extended
> Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=bald
> bserver;PORT=5
> 432;UID=postgres;PWD=lisanto;ReadOnly=0;Protocol=6.4;FakeOidIn
> dex=0;ShowOidC
> olumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch
> =100;Socket=40
> 96;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;
> Debug=1;CommLo
> g=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;U
> nknownsAsLongV
> archar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTabl
> ePrefixes=dd_;
> LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMi
> nus1=0;BI=0;By
> teaAsLongVarBinary=0;UseServerSidePrepare=0";Locale
> Identifier=1031", 0, -1,
> 1)
> 2003-06-18 10:39:29 - SQL (template1): SELECT version()
> 2003-06-18 10:39:29 - Done - 37,23 Secs.
>
> 2003-06-18 10:39:29 -
> *******************************************************************
> 2003-06-18 10:39:29 - Error(s)
> 2003-06-18 10:39:29 -
> *******************************************************************
> 2003-06-18 10:39:29 - Error in pgAdmin
> II:frmConnect.cmdConnect_Click: 430 - Klasse unterstützt
> keine Automatisierung oder unterstützt die erwartete
> Schnittstelle nicht
>
> 2003-06-18 10:39:29 - Windows Version: Windows 98 v4.10 build 2222 A
> 2003-06-18 10:39:29 - pgSchema Version: 1.5.60
> 2003-06-18 10:39:29 - MDAC Version: 2.1
> 2003-06-18 10:39:29 - DBMS Version: 07.03.0100 PostgreSQL
> 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.95.4 2003-06-18
> 10:39:29 - Connection String (Master Connection):
> Provider=MSDASQL.1;Connect Timeout=15;Extended
> Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=bald
> bserver;PORT=5
> 432;UID=postgres;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidI
> ndex=0;ShowOid
> Column=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetc
> h=100;Socket=4
> 096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536
> ;Debug=1;CommL
> og=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;
> UnknownsAsLong
> Varchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTab
> lePrefixes=dd_
> ;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsM
> inus1=0;BI=0;B
> yteaAsLongVarBinary=0;UseServerSidePrepare=0";Locale Identifier=1031
>
> **************************************************************
> **********
> ** Albin Blaschka, Mag. rer. nat.
> ** BAL Gumpenstein
> ** Projekt: Landschaft und Landwirtschaft im Wandel
> ** Tel.: 03682 / 22451 - 244
> ** No trees were killed in the creation of this message.
> ** However, many electrons were terrible inconvenienced.
> **************************************************************
> **********
>
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so
> that your
> message can get through to the mailing list cleanly
>