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
