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

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