Hi, In the ODBC Datasource Administrator in the control panel, on the Tracing tab please make sure tracing is turned off and try again.
Regards, Dave. > -----Original Message----- > From: Eduardo Valentin [mailto:[EMAIL PROTECTED]] > Sent: 10 April 2002 15:01 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] > > > Hi > > I'm using PostgreSQL 7.2 > PgAdminII 1.2.0 > psqlODBC 7.1.9 > > PgAdmin can connect the database, but when I click the > databases section in database tree the pgAdmin get a loop. It > stays trying to list the databases for a big time (More than > 30 min). So I Kill it. > > I had uninstalled PgAdmin and installed it again. > But I got the same problem. > > What is my wrong > > Here it's my log file (Full log) > /******************************************************** > ****************/ > 2002-04-10 09:49:45 - Entering pgAdmin > II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", > "Log Level", 1, "4") 2002-04-10 09:49:45 - Entering pgAdmin > II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II\Log > Window", "Always On Top", 1, "N") 2002-04-10 09:49:45 - > Entering pgSchema:pgServer.Property Let ShowPassword(True) > 2002-04-10 09:49:45 - Entering pgAdmin > II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", > "Mask Password", 1, "N") 2002-04-10 09:49:45 - Entering > pgAdmin II:basRegistry.RegWrite(-2147483647, > "Software\pgAdmin II", "AutoHighlight", 1, > "ALTER|0|0|16711680;COMMENT|0|0|16711680;CREATE|0|0|16 > 711680;DELETE|0|0|16711680;DROP|0|0|16711680;EXPLAIN|0|0| > 16711680;GRANT|0|0|16711680;INSERT|0|0|16711680;REVOKE|0| > 0|16711680;SELECT|0|0|16711680;UPDATE|0|0|16711680;VACUUM > |0|0|16711680;AGGREGATE|0|0|255;CONSTRAINT|0|0|255;DATABA > SE|0|0|255;FUNCTION|0|0|255;GROUP|0|0|255;INDEX|0|0|255;L > ANGUAGE|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;BE > GIN|0|0|11998061;CHECKPOINT|0|0|11998061;CLOSE|0|0|119980 > 61;CLUSTER|0|0|11998061;COMMIT|0|0|11998061;COPY|0|0|1199 > 8061;DECLARE|0|0|11998061;FETCH|0|0|11998061;LISTEN|0|0|1 > 1998061;LOAD|0|0|11998061;LOCK|0|0|11998061;MOVE|0|0|1199 > 8061;NOTIFY|0|0|11998061;REINDEX|0|0|11998061;RESET|0|0|1 > 1998061;ROLLBACK|0|0|11998061;SET|0|0|11998061;SHOW|0|0|1 > 1998061;TRUNCATE|0|0|11998061;UNLISTEN|0|0|11998061;AND|0 > |0|32768;AS|0|0|32768;ASC|0|0|32768;ASCENDING|0|0|32768;B > Y|0|0|32768;CASE|0|0|32768;DESC|0|0|32768;DESCENDING|0|0| > 32768;ELSE|0|0|32768;FROM|0|0|32768;END|0|0|32768;HAVING| > 0|0|32768;INTO|0|0|32768;ON|0|0|32768;OR|0|0|32768;ORDER| > 0|0|32768;THEN|0|0|32768;USING|0|0|32768;WHEN|0|0|32768;W > HERE|0|0|32768;") > 2002-04-10 09:49:45 - Entering > pgSchema:pgServer.Property Get ConnectionString() > 2002-04-10 09:49:45 - Entering pgAdmin > II:basRegistry.RegRead(-2147483647, "Software\pgAdmin II", > "Master DB") 2002-04-10 09:49:45 - Entering pgAdmin > II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", > "Master DB", 1, "template1") 2002-04-10 09:49:45 - Entering > pgSchema:pgServer.Property Let EncryptPasswords(True) > 2002-04-10 09:49:45 - Entering pgAdmin > II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", > "Encrypt Passwords", 1, "Y") 2002-04-10 09:49:46 - Entering > pgAdmin II:frmMain.imgSplitter_MouseMove(0, 0, 30, 1800) > 2002-04-10 09:49:46 - Entering pgAdmin > II:frmMain.tv_NodeClick("127.0.0.1\Databases") > 2002-04-10 09:49:46 - Examining database... > 2002-04-10 09:49:46 - Entering pgAdmin > II:frmMain.txtDefinition_Change() > 2002-04-10 09:49:46 - Entering pgAdmin > II:frmMain.txtDefinition_Change() > 2002-04-10 09:49:46 - Entering pgAdmin > II:frmMain.tvDatabases("127.0.0.1\Databases") > 2002-04-10 09:49:46 - Entering > pgSchema:pgServer.Property Get Databases() > 2002-04-10 09:49:46 - Entering > pgSchema:Databases.Initialize() > 2002-04-10 09:49:46 - Entering > pgSchema:pgServer.Property Get Connection() > 2002-04-10 09:49:46 - Entering > pgSchema:pgServer.Property Get Connection() > 2002-04-10 09:49:46 - Entering pgSchema:pgServer.ExecSQL > ("SELECT oid, *, pg_encoding_to_char(encoding) AS > encodingname, pg_get_userbyid(datdba) AS datowner FROM > pg_database ORDER BY datname", "Connection: > Provider=MSDASQL.1;Extended Properties="DRIVER= > {PostgreSQL};DATABASE=template1;SERVER=127.0.0.1;PORT=543 > 2;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDI > NDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0 > ;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVA > RCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=0; > OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1; > UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASFRE > ESTMT=0;EXTRASYSTABLEPREFIXES=dd_"") > 2002-04-10 09:49:46 - SQL (template1): SELECT oid, *, > pg_encoding_to_char(encoding) AS encodingname, > pg_get_userbyid(datdba) AS datowner FROM pg_database > ORDER BY datname > 2002-04-10 09:49:52 - Entering pgSchema:Databases.iAdd > (16555, "template0", "", "Administrador", 0, SQL_ASCII) > 2002-04-10 09:49:52 - Entering pgSchema:pgServer.Property Get > LastSystemOID() 2002-04-10 09:49:52 - Entering > pgSchema:pgDatabase.Property Let SystemObject(False) > 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property > Let OID(16555) 2002-04-10 09:49:52 - Entering > pgSchema:pgDatabase.Property Let Name("template0") 2002-04-10 > 09:49:52 - Entering pgSchema:pgDatabase.Property Let Path("") > 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property > Let Owner("Administrador") 2002-04-10 09:49:52 - Entering > pgSchema:pgDatabase.Property Let Encoding(0) 2002-04-10 > 09:49:52 - Entering pgSchema:pgDatabase.Property Let > EncodingName(SQL_ASCII) 2002-04-10 09:49:52 - Entering > pgSchema:pgDatabase.Property Let Identifier("template0") > 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property > Get Identifier() 2002-04-10 09:49:52 - Entering > pgSchema:Databases.iAdd (1, "template1", "", "Administrador", > 0, SQL_ASCII) 2002-04-10 09:49:52 - Entering > pgSchema:pgServer.Property Get LastSystemOID() 2002-04-10 > 09:49:52 - Entering pgSchema:pgServer.Property Get > IncludeSys() 2002-04-10 09:49:52 - Entering > pgSchema:pgDatabase.Property Let SystemObject(True) > 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property > Let OID(1) 2002-04-10 09:49:52 - Entering > pgSchema:pgDatabase.Property Let Name("template1") 2002-04-10 > 09:49:52 - Entering pgSchema:pgDatabase.Property Let Path("") > 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property > Let Owner("Administrador") 2002-04-10 09:49:52 - Entering > pgSchema:pgDatabase.Property Let Encoding(0) 2002-04-10 > 09:49:52 - Entering pgSchema:pgDatabase.Property Let > EncodingName(SQL_ASCII) 2002-04-10 09:49:52 - Entering > pgSchema:pgDatabase.Property Let Identifier("template1") > 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property > Get Identifier() 2002-04-10 09:49:53 - Entering > pgSchema:Databases.iAdd (16557, "testedelphi", "", > "Administrador", 0, SQL_ASCII) 2002-04-10 09:49:53 - Entering > pgSchema:pgServer.Property Get LastSystemOID() 2002-04-10 > 09:49:53 - Entering pgSchema:pgDatabase.Property Let > SystemObject(False) 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Let OID(16557) 2002-04-10 > 09:49:53 - Entering pgSchema:pgDatabase.Property Let > Name("testedelphi") 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Let Path("") 2002-04-10 09:49:53 > - Entering pgSchema:pgDatabase.Property Let > Owner("Administrador") 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Let Encoding(0) 2002-04-10 > 09:49:53 - Entering pgSchema:pgDatabase.Property Let > EncodingName(SQL_ASCII) 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Let Identifier > ("testedelphi") > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get Identifier() > 2002-04-10 09:49:53 - Entering > pgSchema:Databases.Property Get Count(True) > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get SystemObject() > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get SystemObject() > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get SystemObject() > 2002-04-10 09:49:53 - Entering > pgSchema:pgServer.Property Get Databases() > 2002-04-10 09:49:53 - Entering > pgSchema:Databases.Property Get NewEnum() > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get SystemObject() > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get Status() > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.dbConnect() > 2002-04-10 09:49:53 - Entering > pgSchema:pgServer.Property Get Connection() > 2002-04-10 09:49:53 - Entering > pgSchema:pgServer.Property Get MasterDB() > 2002-04-10 09:49:53 - Entering > pgSchema:pgServer.Property Get ShowPassword() > 2002-04-10 09:49:53 - Opening cnDatabase: > Provider=MSDASQL.1;Extended Properties="DRIVER= > {PostgreSQL};DATABASE=template0;SERVER=127.0.0.1;PORT=543 > 2;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDI > NDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0 > ;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVA > RCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=0; > OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1; > UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASFRE > ESTMT=0;EXTRASYSTABLEPREFIXES=dd_" > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get Identifier() > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get SystemObject() > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get SystemObject() > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.Property Get Status() > 2002-04-10 09:49:53 - Entering > pgSchema:pgDatabase.dbConnect() > 2002-04-10 09:49:53 - Entering > pgSchema:pgServer.Property Get Connection() > 2002-04-10 09:49:53 - Entering > pgSchema:pgServer.Property Get MasterDB() > 2002-04-10 09:49:53 - Entering > pgSchema:pgServer.Property Get ShowPassword() > 2002-04-10 09:49:53 - Opening cnDatabase: > Provider=MSDASQL.1;Extended Properties="DRIVER= > {PostgreSQL};DATABASE=testedelphi;SERVER=127.0.0.1;PORT=5 > 432;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOI > DINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES > =0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAX > VARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG= > 0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR= > 1;UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASF > REESTMT=0;EXTRASYSTABLEPREFIXES=dd_" > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.Property Get Identifier() > 2002-04-10 09:49:56 - Entering > pgSchema:pgServer.Property Get Databases() > 2002-04-10 09:49:56 - Entering > pgSchema:Databases.Property Get NewEnum() > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.Property Get SystemObject() > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.Property Get Identifier() > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.Property Get Comment() > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.LookupComment(16555) > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.dbConnect() > 2002-04-10 09:49:56 - Entering > pgSchema:pgServer.Property Get Connection() > 2002-04-10 09:49:56 - Entering > pgSchema:pgServer.Property Get MasterDB() > 2002-04-10 09:49:56 - Entering > pgSchema:pgServer.Property Get ShowPassword() > 2002-04-10 09:49:56 - Opening cnDatabase: > Provider=MSDASQL.1;Extended Properties="DRIVER= > {PostgreSQL};DATABASE=template0;SERVER=127.0.0.1;PORT=543 > 2;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDI > NDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0 > ;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVA > RCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=0; > OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1; > UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASFRE > ESTMT=0;EXTRASYSTABLEPREFIXES=dd_" > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.Property Get SystemObject() > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.Property Get SystemObject() > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.Property Get Identifier() > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.Property Get Comment() > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.LookupComment(16557) > 2002-04-10 09:49:56 - Entering > pgSchema:pgDatabase.dbConnect() > 2002-04-10 09:49:56 - Entering pgSchema:pgServer.ExecSQL > ("SELECT * FROM pg_description", "Connection: > Provider=MSDASQL.1;Extended Properties="DRIVER= > {PostgreSQL};DATABASE=testedelphi;SERVER=127.0.0.1;PORT=5 > 432;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOI > DINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES > =0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAX > VARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG= > 0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR= > 1;UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASF > REESTMT=0;EXTRASYSTABLEPREFIXES=dd_"") > 2002-04-10 09:49:56 - SQL (testedelphi): SELECT * FROM > pg_description 2002-04-10 09:49:58 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:49:59 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:49:59 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:49:59 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:00 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:00 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:00 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:01 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:01 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:01 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:01 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:02 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:02 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:02 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:03 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:03 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:03 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:03 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:04 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:04 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:04 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:05 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:05 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:05 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:05 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:06 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:06 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:06 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:06 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:07 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:07 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:07 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:08 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:08 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:09 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:09 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:09 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:09 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:10 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:10 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:10 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:11 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:11 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:11 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:11 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:12 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:12 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:12 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:13 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:13 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:13 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:14 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:14 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:14 - Entering pgSchema:pgServer.Property Get > dbVersion() 2002-04-10 09:50:15 - Entering > pgSchema:pgServer.Property Get dbVersion() 2002-04-10 > 09:50:15 - Entering > > /******************************************************** > ****************/ > Best regards, > > Eduardo Bezerra > > > > ______________________________________________________________ > ____________ > Quer ter seu próprio endereço na Internet? > Garanta já o seu e ainda ganhe cinco e-mails personalizados. > DomíniosBOL - http://dominios.bol.com.br > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go 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
