PGADMIN-II Connection to Database Error - Mailing list pgadmin-support

I have just installed PgAdmin-II on W2K.

When trying to open the Databases entry in the navigation tree I get the
following error

"Error in pgAdmin II:frmMain.tvDatabases: -2147217887 - Multiple-step OLE DB
operation generated errors. Check each OLE DB status value, if available. No
work was done."

The log (Full Debug) is as follows:

17/06/2002 10:01:54 - Entering pgAdmin II:frmLog.Form_Load()
17/06/2002 10:01:54 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Log Window", "Left")
17/06/2002 10:01:54 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Log Window", "Top")
17/06/2002 10:01:54 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Log Window", "Width")
17/06/2002 10:01:54 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Log Window", "Height")
17/06/2002 10:01:54 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Log Window", "Always On Top")
17/06/2002 10:01:54 - Entering pgAdmin II:basMisc.SetTopMostWindow(787264,
True)
17/06/2002 10:01:54 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647,
"Software\pgAdmin II\Log Window", "Visible", 1, "Y")
17/06/2002 10:02:04 - Entering pgAdmin II:frmMain.tb_ButtonClick()
17/06/2002 10:02:04 - Entering pgAdmin II:frmMain.mnuPopupConnect_Click()
17/06/2002 10:02:04 - Entering pgAdmin II:frmConnect.Load_Defaults(0)
17/06/2002 10:02:04 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 1")
17/06/2002 10:02:20 - Entering pgAdmin II:frmConnect.cmdConnect_Click()
17/06/2002 10:02:20 - Connecting to 192.168.0.254...
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Let
MasterDB("postgres")
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Connect("192.168.0.254",
5432, "postgres", "********")
17/06/2002 10:02:20 - Closing cnPostgreSQL
17/06/2002 10:02:20 - Entering pgSchema:Databases.Class_Terminate()
17/06/2002 10:02:20 - Opening cnPostgreSQL:
SERVER=192.168.0.254;PORT=5432;UID=postgres;PWD=********;DATABASE=postgres;D
RIVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;RO
WVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWN
SIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;USEDE
CLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE
=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=1;
17/06/2002 10:02:20 - Entering pgSchema:pgServer.ExecSQL("SELECT version(),
datlastsysoid FROM pg_database WHERE datname = 'template1'", "Connection:
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=postgres;SERVER=192.168.0.254;PORT=
5432;UID=postgres;PWD=postgres;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOi
dColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=
4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;Comm
Log=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLon
gVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd
_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0"")
17/06/2002 10:02:20 - SQL (postgres): SELECT version(), datlastsysoid FROM
pg_database WHERE datname = 'template1'
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 1")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 2")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 3")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 4")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 5")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 6")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 7")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 8")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 9")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 10")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647,
"Software\pgAdmin II\Connections", "Connection 1", 1,
"postgres|192.168.0.254|5432")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647,
"Software\pgAdmin II\Connections", "Connection 2", 1,
"luser|192.168.0.254|5432")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647,
"Software\pgAdmin II\Connections", "Connection 3", 1, "postgres|owl|5432")
17/06/2002 10:02:20 - Entering pgAdmin II:basMisc.BuildConnectionMenu()
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 1")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 2")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 3")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 4")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 5")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 6")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 7")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 8")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 9")
17/06/2002 10:02:20 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 10")
17/06/2002 10:02:20 - Entering pgAdmin II:basMisc.BuildPluginsMenu()
17/06/2002 10:02:20 - Entering pgAdmin II:clsPlugins.Property Get NewEnum()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get
ConnectionString()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get
ConnectionString()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get
ConnectionString()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get
ConnectionString()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get
ConnectionString()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get Server()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get Identifier()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:20 - Entering pgAdmin
II:frmMain.tv_NodeClick("192.168.0.254")
17/06/2002 10:02:20 - Examining database...
17/06/2002 10:02:20 - Entering pgAdmin II:frmMain.txtDefinition_Change()
17/06/2002 10:02:20 - Entering pgAdmin II:frmMain.txtDefinition_Change()
17/06/2002 10:02:20 - Entering pgAdmin II:frmMain.tvServer("192.168.0.254")
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get Server()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get Port()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get Username()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get
LastSystemOID()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get DriverName()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get
DriverVersion()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get
DriverVersion()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get
DriverVersion()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get dbVersion()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get dbVersion()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get dbVersion()
17/06/2002 10:02:20 - Entering pgSchema:pgServer.Property Get dbVersion()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get
ConnectionString()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get Identifier()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Entering pgSchema:pgServer.Property Get ObjectType()
17/06/2002 10:02:21 - Done - 0.23 Secs.
17/06/2002 10:02:24 - Entering pgAdmin
II:frmMain.tv_NodeClick("192.168.0.254\Databases")
17/06/2002 10:02:24 - Examining database...
17/06/2002 10:02:24 - Entering pgAdmin II:frmMain.txtDefinition_Change()
17/06/2002 10:02:24 - Entering pgAdmin II:frmMain.txtDefinition_Change()
17/06/2002 10:02:24 - Entering pgAdmin
II:frmMain.tvDatabases("192.168.0.254\Databases")
17/06/2002 10:02:24 - Entering pgSchema:pgServer.Property Get Databases()
17/06/2002 10:02:24 - Entering pgSchema:Databases.Initialize()
17/06/2002 10:02:24 - Entering pgSchema:pgServer.Property Get Connection()
17/06/2002 10:02:24 - Entering pgSchema:pgServer.Property Get Connection()
17/06/2002 10:02:24 - 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=postgres;SERVER=192.168.0.254;PORT=
5432;UID=postgres;PWD=postgres;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOi
dColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=
4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;Comm
Log=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLon
gVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd
_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0"")
17/06/2002 10:02:24 - SQL (postgres): SELECT oid, *,
pg_encoding_to_char(encoding) AS encodingname, pg_get_userbyid(datdba) AS
datowner FROM pg_database ORDER BY datname
17/06/2002 10:02:24 - Error in pgAdmin II:frmMain.tvDatabases: -2147217887 -
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
17/06/2002 10:02:45 - Done - 21.03 Secs.


I can execute the query preceding the error using psql without problem,
screen dump follows:


postgres=# SELECT oid, *, pg_encoding_to_char(encoding) AS encodingname,
pg_get
_userbyid(datdba) AS datowner FROM pg_database order by datname;
    oid     |  datname   | datdba | encoding | datistemplate | datallowconn
| da
tlastsysoid | datpath | encodingname | datowner
------------+------------+--------+----------+---------------+--------------
+---
------------+---------+--------------+----------
 3527156636 | dwh        |     26 |        0 | f             | t
|
      18539 |         | SQL_ASCII    | postgres
 3527156462 | goldmine   |     26 |        0 | f             | t
|
      18539 |         | SQL_ASCII    | postgres
  465885221 | ittasks    |     26 |        0 | f             | t
|
      18539 |         | SQL_ASCII    | postgres
 3527156448 | postgres   |     26 |        0 | f             | t
|
      18539 |         | SQL_ASCII    | postgres
 3507814438 | regression |     26 |        0 | f             | t
|
      18539 |         | SQL_ASCII    | postgres
 4105832380 | stevetest  |     26 |        0 | f             | t
|
      18539 |         | SQL_ASCII    | postgres
      18719 | template0  |     26 |        0 | t             | f
|
      18539 |         | SQL_ASCII    | postgres
          1 | template1  |     26 |        0 | t             | t
|
      18539 |         | SQL_ASCII    | postgres
(8 rows)

Notice that I have some _very_ big OIDs, I don't know if this is causing the
problem.

I would very much like my team to use PgAdmin-II, at the moment most
Postgres admin is done using pgAccess under Linux, and most of my staff
don't use Linux..., so if anyone can resolve this problem it would be much
appreciated.

Thanks,

Steve