Thread: PGADMIN-II Connection to Database Error

PGADMIN-II Connection to Database Error

From

"Steve Burrows"

Date:

17 June 2002, 08:17:20

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

Re: PGADMIN-II Connection to Database Error

From

"Dave Page"

Date:

17 June 2002, 10:58:00

Steve, please bear with me - I'll take a look at this as soon as I can
today or tomorrow...

Regards, Dave.

> -----Original Message-----
> From: Steve Burrows [mailto:steve@jlajla.com]
> Sent: 17 June 2002 10:19
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] PGADMIN-II Connection to Database Error
>
>
> 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=********;DATAB
> ASE=postgres;D
> RIVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOW
> OIDCOLUMN=0;RO
> WVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKE
> T=4096;UNKNOWN
> SIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=
> 1;KSQO=1;USEDE
> CLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLS
> ASCHAR=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.1
68.0.254;PORT=
> 5432;UID=postgres;PWD=postgres;ReadOnly=0;Protocol=6.4;FakeOid
> Index=0;ShowOi
> dColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fet
> ch=100;Socket=
> 4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=6553
> 6;Debug=1;Comm
> Log=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1
> ;UnknownsAsLon
> gVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTa
> blePrefixes=dd
> _;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIs
> Minus1=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.1
68.0.254;PORT=
> 5432;UID=postgres;PWD=postgres;ReadOnly=0;Protocol=6.4;FakeOid
> Index=0;ShowOi
> dColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fet
> ch=100;Socket=
> 4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=6553
> 6;Debug=1;Comm
> Log=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1
> ;UnknownsAsLon
> gVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTa
> blePrefixes=dd
> _;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIs
> Minus1=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
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
http://archives.postgresql.org

Re: PGADMIN-II Connection to Database Error

From

"Dave Page"

Date:

17 June 2002, 19:36:36


> -----Original Message-----
> From: Steve Burrows [mailto:steve@jlajla.com]
> Sent: 17 June 2002 10:19
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] PGADMIN-II Connection to Database Error
>
>
> 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."
>

Hi Steve,

Following some tests, I think this is caused by the large OIDs. I have
fixed the code and committed to CVS. I should be able to upload some
test binaries tomorrow that can be downloaded from
http://cvs.pgadmin.org in the binaries folders (just click the download
tarball link). If you prefer, these changes will be in the next Alpha
release which will probably be fairly soon.

Regards, Dave.