Database Publishing Wizard

From: "Paolo Frizzera" <geofrizz(at)mbox(dot)dinamica(dot)it>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Database Publishing Wizard
Date: 2002-12-09 12:26:33
Message-ID: 069d01c29f7e$36a51780$c900000a@domdinamica.dinamica.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi all,

when I try to use the Database Publishing Wizard in pgAdmin2 I receive
always error messages.
I enclose some logs.

Thanks.
Ciao, Paolo

with version 1.4.2:

2002-12-05 13:36:37 -
*******************************************************************
2002-12-05 13:36:37 - Error(s)
2002-12-05 13:36:37 -
*******************************************************************
2002-12-05 13:36:37 - Error in Database Publishing Wizard:Database
Publishing Wizard:frmWizard.cmdOK_Click: -2147467259 - [Microsoft][ODBC
Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

2002-12-05 13:36:37 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-05 13:36:37 - pgSchema Version: 1.4.1
2002-12-05 13:36:37 - MDAC Version: 2.7
2002-12-05 13:36:37 - DBMS Version: 07.02.0005 PostgreSQL 7.2.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2002-12-05 13:36:37 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=10.0.0.129;PORT=54
32;UID=prova;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColu
mn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;
UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0
;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarc
har=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFC
onversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"

2002-12-05 13:37:46 - Executing Plugin: Database Publishing Wizard v1.4.1
2002-12-05 13:37:46 - Examining Server...
2002-12-05 13:37:46 - Done - 0,06 Secs.
2002-12-05 13:37:55 - Examining Server...
2002-12-05 13:37:55 - Done - 0,11 Secs.
2002-12-05 13:38:48 - Publishing database...
2002-12-05 13:38:48 - Opening Connection:
DRIVER=PostgreSQL;SERVER=10.0.0.129;PORT=5432;UID=xxxxxx;PWD=xxxxxx;DATABASE
=test
2002-12-05 13:38:48 - Done - 0,45 Secs.

2002-12-05 13:38:48 -
*******************************************************************
2002-12-05 13:38:48 - Error(s)
2002-12-05 13:38:48 -
*******************************************************************
2002-12-05 13:38:48 - Error in Database Publishing Wizard:Database
Publishing Wizard:frmWizard.cmdOK_Click: -2147467259 - [Microsoft][ODBC
Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

2002-12-05 13:38:48 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-05 13:38:48 - pgSchema Version: 1.4.1
2002-12-05 13:38:48 - MDAC Version: 2.7
2002-12-05 13:38:48 - DBMS Version: 07.02.0005 PostgreSQL 7.2.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2002-12-05 13:38:48 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=10.0.0.129;PORT=54
32;UID=xxxxxx;PWD=xxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColum
n=
0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;Unk
nownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Op
timizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar
=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConv
ersion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"

2002-12-05 13:44:03 - Publishing database...
2002-12-05 13:44:04 - Opening Connection:
DRIVER=PostgreSQL;SERVER=xxx.xxx.xxx.x;PORT=5432;UID=xxxxxx;PWD=xxxxxx;DATAB
ASE=Test
2002-12-05 13:44:04 - Done - 0,12 Secs.

2002-12-05 13:44:04 -
*******************************************************************
2002-12-05 13:44:04 - Error(s)
2002-12-05 13:44:04 -
*******************************************************************
2002-12-05 13:44:04 - Error in Database Publishing Wizard:Database
Publishing Wizard:frmWizard.cmdOK_Click: -2147467259 - [Microsoft][ODBC
Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

2002-12-05 13:44:04 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-05 13:44:04 - pgSchema Version: 1.4.1
2002-12-05 13:44:04 - MDAC Version: 2.7
2002-12-05 13:44:04 - DBMS Version: 07.02.0005 PostgreSQL 7.2.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2002-12-05 13:44:04 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=10.0.0.129;PORT=54
32;UID=xxxxxx;PWD=xxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColum
n=
0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;Unk
nownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Op
timizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar
=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConv
ersion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"

with version 1.4.6:

2002-12-06 15:43:51 -
###################################################################
2002-12-06 15:43:51 - pgAdmin II v1.4 Build 6 Startup
2002-12-06 15:43:51 -
###################################################################
2002-12-06 15:43:51 - Loading Plugins...
2002-12-06 15:43:51 - Loading Plugin: pgConnDebug.pgAdmin2_Plugin
(Connection Debugging Tools v1.4.3)
2002-12-06 15:43:51 - Loading Plugin: pgImport.pgAdmin2_Plugin (Import
Wizard v1.4.3)
2002-12-06 15:43:51 - Loading Plugin: pgMigration.pgAdmin2_Plugin (Database
Migration Wizard v1.4.5)
2002-12-06 15:43:51 - Loading Plugin: pgMSysConf.pgAdmin2_Plugin (MSysConf
Wizard v1.4.3)
2002-12-06 15:43:51 - Loading Plugin: pgPublishing.pgAdmin2_Plugin (Database
Publishing Wizard v1.4.3)
2002-12-06 15:43:51 - Loading Plugin: pgSecurity.pgAdmin2_Plugin (Security
Wizard v1.4.3)
2002-12-06 15:43:51 - Done - 0,74 Secs.
2002-12-06 15:44:02 - Connecting to 10.0.0.129...
...
2002-12-06 15:46:38 - Opening cnPostgreSQL:
SERVER=10.0.0.129;PORT=5432;UID=xxxxxx;PWD=xxxxxx;DATABASE=template1;DRIVER=
{P
ostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSION
ING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;
MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;USEDECLAREFET
CH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCE
LASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=0;
2002-12-06 15:46:39 - Done - 1,99 Secs.

2002-12-06 15:46:39 -
*******************************************************************
2002-12-06 15:46:39 - Error(s)
2002-12-06 15:46:39 -
*******************************************************************
2002-12-06 15:46:39 - Error in pgAdmin
II:frmConnect.cmdConnect_Click: -2147467259 - [Microsoft][ODBC Driver
Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

2002-12-06 15:46:39 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-06 15:46:39 - pgSchema Version: 1.4.4
2002-12-06 15:46:39 - MDAC Version: 2.7
2002-12-06 15:46:39 - cnPostgreSQL.State = adStateClosed

with the last version:

2002-12-09 11:12:40 -
###################################################################
2002-12-09 11:12:40 - pgAdmin II v1.4 Build 7 Startup
2002-12-09 11:12:40 -
###################################################################
2002-12-09 11:12:40 - Loading Plugins...
2002-12-09 11:12:40 - Loading Plugin: pgConnDebug.pgAdmin2_Plugin
(Connection Debugging Tools v1.4.3)
2002-12-09 11:12:40 - Loading Plugin: pgImport.pgAdmin2_Plugin (Import
Wizard v1.4.3)
2002-12-09 11:12:40 - Loading Plugin: pgMigration.pgAdmin2_Plugin (Database
Migration Wizard v1.4.5)
2002-12-09 11:12:40 - Loading Plugin: pgMSysConf.pgAdmin2_Plugin (MSysConf
Wizard v1.4.3)
2002-12-09 11:12:40 - Loading Plugin: pgPublishing.pgAdmin2_Plugin (Database
Publishing Wizard v1.4.3)
2002-12-09 11:12:40 - Loading Plugin: pgSecurity.pgAdmin2_Plugin (Security
Wizard v1.4.3)
2002-12-09 11:12:40 - Done - 0,85 Secs.
2002-12-09 11:13:00 - Connecting to 10.0.0.129...
...
2002-12-09 11:15:26 - Publishing database...
2002-12-09 11:15:26 - Opening Connection:
DRIVER=PostgreSQL;SERVER=10.0.0.129;PORT=5432;UID=xxxxxx;PWD=xxxxxx;DATABASE
=prova
2002-12-09 11:15:26 - Done - 0,12 Secs.

2002-12-09 11:15:26 -
*******************************************************************
2002-12-09 11:15:26 - Error(s)
2002-12-09 11:15:26 -
*******************************************************************
2002-12-09 11:15:26 - Error in Database Publishing Wizard:Database
Publishing Wizard:frmWizard.cmdOK_Click: -2147217843 - FATAL: Non-superuser
connection limit exceeded

2002-12-09 11:15:26 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
2002-12-09 11:15:26 - pgSchema Version: 1.4.4
2002-12-09 11:15:26 - MDAC Version: 2.7
2002-12-09 11:15:26 - DBMS Version: 07.02.0005 PostgreSQL 7.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2002-12-09 11:15:26 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=10.0.0.129;PORT=54
32;UID=xxxxxx;PWD=xxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColum
n=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;U
nknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=1;
Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarch
ar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFCo
nversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message PABLO PEREZ 2002-12-09 19:30:28 question
Previous Message jsmateo 2002-12-08 02:22:05 unsubscribe