Thread: RE: [INTERFACES] pgAdmin connection error on NT and W98

RE: [INTERFACES] pgAdmin connection error on NT and W98

From
Nicolas Huillard
Date:
Hello,

I solved the NT problem by reinstalling MDAC, and just reopened the user session. I know I shouldn't use this server as
aworkstation, but sometimes, we don't decide... 

I created the pgAdmin system tables. OK.
By now the resulting problem is the same under NT and W98 : the same error still occur, but only when I show the tables
(menuSchema/Tables) or indexes (Schema/Indexes). Here is the log file : 


The Migration error was about an OLE field in the Access database (s_Lineage). Which is converted in a blank field
type.See the log file : 


Then the last suggestion/question :
* I try to migrate replicated databases (with fields s_Generation, s_Lineage, and s_GUID),
* I don't want to migrate thoses system fields
* the s_Lineage OLE field is not correctly converted
--> could it be possible to migrate replicated databases ?
--> have you heard of people replicating data between Access and Postgres, using either a standard tool, pgAdmin, or
VBAmodules inside Access ? 

TIA,

Nicolas Huillard
G.H.S
Directeur Technique
Tél : +33 1 43 21 16 66
Fax : +33 1 56 54 02 18
mailto:nhuillard@ghs.fr
http://www.ghs.fr

27/10/99 11:11:55    Loading Form: frmTables
27/10/99 11:11:55    Retrieving Table Definitions...
27/10/99 11:11:55    Executing: SELECT c.oid, c.* FROM "pg_class" c, "pg_tables" t WHERE c."relname" = t."tablename"
ORDERBY "relname"; 
27/10/99 11:11:55    Executing: SELECT "version" FROM "pgadmin_ver";
27/10/99 11:11:55    Done - 0,39 Secs.
**********************************************************************
* Error - 27/10/99 11:11:55
**********************************************************************

Software
********
Program: pgAdmin
Version: 6.5.2
Sub or Function: frmTables, cmdRefresh_Click

Error Details
*************
Error No: -2147217887
Error Description: The request properties can not be supported by this ODBC Driver.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
DLL Error Code: 0

Memory Details
**************
Total Physical: 66572288
Total Swap: 2080907264
Total Virtual: 2143289344
Available Physical: 2007040
Available Swap: 2051723264
Available Virtual: 2077949952
Percentage Free: 77

System Details
**************
Processor: 586
OEM ID: 0
No. Processors: 1
Page Size: 4096

OS Details
**********
Platform: Windows 95/98
Version: 4.10
Build: 1998
OS Info:

Environment Details
*******************
Datasource: PostgreSQL
Tracking: False
TrackVer: 0
Connect: Provider=MSDASQL.1;Connect Timeout=15;Extended
Properties="DSN=PostgreSQL;DATABASE=test;SERVER=auch;PORT=5432;UID=nhuillard;PWD=XXXX;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS=";Locale
Identifier=1036
Version: 2.1

27/10/99 11:11:56    Retrieving User Info...
27/10/99 11:11:56    Executing: SELECT "usename", "usesysid" FROM "pg_user";
27/10/99 11:11:56    Done - 0 Secs.
27/10/99 10:43:01    Loading Form: frmDatabases
27/10/99 10:43:01    Retrieving database names...
27/10/99 10:43:01    Executing: SELECT d.oid, d.datname, d.datpath, u.usename FROM 'pg_database' d, 'pg_user' u WHERE
d.datdba= u.usesysid ORDER BY 'datname'; 
27/10/99 10:43:01    Done - 0,06 Secs.
27/10/99 10:43:05    Loading Form: frmMigration
27/10/99 10:43:43    Finding indexes...
27/10/99 10:43:43    Done - 0,21 Secs.
27/10/99 10:44:00    Migrating database...
27/10/99 10:44:00    CREATE TABLE "G�n�rique devises" ( "s_Generation" "int4", "s_Lineage" "", "Cl� devise" "int4",
"Codedevise" "text" NOT NULL, "Libell� devise" "text" NOT NULL, "s_GUID" "text" ); 
27/10/99 10:44:00    Done - 0,16 Secs.
**********************************************************************
* Error - 27/10/99 10:44:00
**********************************************************************

Software
********
Program: pgAdmin
Version: 6.5.2
Sub or Function: frmMigration, cmdMigrate_Click

Error Details
*************
Error No: -2147168242
Error Description: No transaction is active.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
DLL Error Code: 0

Memory Details
**************
Total Physical: 66572288
Total Swap: 2080907264
Total Virtual: 2143289344
Available Physical: 4894720
Available Swap: 2058547200
Available Virtual: 1998061568
Percentage Free: 69

System Details
**************
Processor: 586
OEM ID: 0
No. Processors: 1
Page Size: 4096

OS Details
**********
Platform: Windows 95/98
Version: 4.10
Build: 1998
OS Info:

Environment Details
*******************
Datasource: PostgreSQL
Tracking: False
TrackVer: 0
Connect: Provider=MSDASQL.1;Connect Timeout=15;Extended
Properties="DSN=PostgreSQL;DATABASE=test;SERVER=auch;PORT=5432;UID=nhuillard;PWD=XXXX;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS=";Locale
Identifier=1036
Version: 2.1

27/10/99 10:52:36    Loading Form: frmMigration
27/10/99 10:52:45    Finding indexes...
27/10/99 10:52:46    Done - 0 Secs.
27/10/99 10:52:52    Migrating database...
27/10/99 10:52:52    CREATE TABLE "G�n�rique devises 2" ( "Cl� devise" "int4", "Code devise" "text" NOT NULL, "Libell�
devise""text" NOT NULL ); 
27/10/99 10:52:52    Done - 0,32 Secs.
27/10/99 10:53:29    Retrieving database info...
27/10/99 10:53:29    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 18624;
27/10/99 10:53:29    Done - 0,16 Secs.
27/10/99 10:53:30    Retrieving database info...
27/10/99 10:53:30    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 17120;
27/10/99 10:53:30    Done - 0,17 Secs.
27/10/99 10:53:30    Retrieving database info...
27/10/99 10:53:30    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 22016;
27/10/99 10:53:30    Done - 0,16 Secs.
27/10/99 10:53:30    Retrieving database info...
27/10/99 10:53:30    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 17120;
27/10/99 10:53:31    Done - 0,15 Secs.
27/10/99 10:53:31    Retrieving database info...
27/10/99 10:53:31    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 18624;
27/10/99 10:53:31    Done - 0,16 Secs.
27/10/99 10:53:31    Retrieving database info...
27/10/99 10:53:31    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 18592;
27/10/99 10:53:31    Done - 0,16 Secs.
27/10/99 10:53:32    Retrieving database info...
27/10/99 10:53:32    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 18624;
27/10/99 10:53:32    Done - 0,16 Secs.
27/10/99 10:53:32    Retrieving database info...
27/10/99 10:53:32    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 17120;
27/10/99 10:53:32    Done - 0,16 Secs.
27/10/99 10:53:32    Retrieving database info...
27/10/99 10:53:32    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 22016;
27/10/99 10:53:33    Done - 0,16 Secs.
27/10/99 10:53:33    Retrieving database info...
27/10/99 10:53:33    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 17120;
27/10/99 10:53:33    Done - 0,16 Secs.
27/10/99 10:53:33    Retrieving database info...
27/10/99 10:53:33    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 18624;
27/10/99 10:53:33    Done - 0 Secs.
27/10/99 10:53:34    Retrieving database info...
27/10/99 10:53:34    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 18592;
27/10/99 10:53:34    Done - 0 Secs.
27/10/99 10:53:34    Retrieving database info...
27/10/99 10:53:34    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 18624;
27/10/99 10:53:34    Done - 0 Secs.
27/10/99 10:53:35    Retrieving database info...
27/10/99 10:53:35    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 17120;
27/10/99 10:53:35    Done - 0 Secs.
27/10/99 10:53:35    Retrieving database info...
27/10/99 10:53:35    Executing: SELECT "description" FROM "pg_description" WHERE "objoid" = 22016;
27/10/99 10:53:35    Done - 0,05 Secs.
27/10/99 10:53:36    Loading Form: frmTables
27/10/99 10:53:36    Retrieving Table Definitions...
27/10/99 10:53:36    Executing: SELECT c.oid, c.* FROM "pg_class" c, "pg_tables" t WHERE c."relname" = t."tablename"
ORDERBY "relname"; 
27/10/99 10:53:36    Executing: SELECT "version" FROM "pgadmin_ver";
27/10/99 10:53:36    Done - 0,22 Secs.
**********************************************************************
* Error - 27/10/99 10:53:36
**********************************************************************

Software
********
Program: pgAdmin
Version: 6.5.2
Sub or Function: frmTables, cmdRefresh_Click

Error Details
*************
Error No: -2147217887
Error Description: The request properties can not be supported by this ODBC Driver.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
DLL Error Code: 0

Memory Details
**************
Total Physical: 66572288
Total Swap: 2080907264
Total Virtual: 2143289344
Available Physical: 921600
Available Swap: 2050490368
Available Virtual: 1990721536
Percentage Free: 79

System Details
**************
Processor: 586
OEM ID: 0
No. Processors: 1
Page Size: 4096

OS Details
**********
Platform: Windows 95/98
Version: 4.10
Build: 1998
OS Info:

Environment Details
*******************
Datasource: PostgreSQL
Tracking: False
TrackVer: 0
Connect: Provider=MSDASQL.1;Connect Timeout=15;Extended
Properties="DSN=PostgreSQL;DATABASE=test;SERVER=auch;PORT=5432;UID=nhuillard;PWD=XXXX;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS=";Locale
Identifier=1036
Version: 2.1

27/10/99 10:53:38    Retrieving User Info...
27/10/99 10:53:38    Executing: SELECT "usename", "usesysid" FROM "pg_user";
27/10/99 10:53:38    Done - 0 Secs.
27/10/99 10:54:30    Loading Form: frmMigration
27/10/99 10:54:38    Finding indexes...
27/10/99 10:54:38    Done - 0 Secs.
27/10/99 10:54:39    Migrating database...
27/10/99 10:54:39    CREATE TABLE "G�n�rique devises 2" ( "Cl� devise" "int4", "Code devise" "text" NOT NULL, "Libell�
devise""text" NOT NULL, "OLE" "" ); 
27/10/99 10:54:40    Done - 0,1 Secs.
**********************************************************************
* Error - 27/10/99 10:54:40
**********************************************************************

Software
********
Program: pgAdmin
Version: 6.5.2
Sub or Function: frmMigration, cmdMigrate_Click

Error Details
*************
Error No: -2147168242
Error Description: No transaction is active.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
DLL Error Code: 0

Memory Details
**************
Total Physical: 66572288
Total Swap: 2080907264
Total Virtual: 2143289344
Available Physical: 937984
Available Swap: 2050666496
Available Virtual: 1998061568
Percentage Free: 79

System Details
**************
Processor: 586
OEM ID: 0
No. Processors: 1
Page Size: 4096

OS Details
**********
Platform: Windows 95/98
Version: 4.10
Build: 1998
OS Info:

Environment Details
*******************
Datasource: PostgreSQL
Tracking: False
TrackVer: 0
Connect: Provider=MSDASQL.1;Connect Timeout=15;Extended
Properties="DSN=PostgreSQL;DATABASE=test;SERVER=auch;PORT=5432;UID=nhuillard;PWD=XXXX;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS=";Locale
Identifier=1036
Version: 2.1

27/10/99 10:55:01    Loading Form: frmBugRep