Received: from lectoure.ghs.fr (IDENT:root@e009.paris-88.cybercable.fr [212.198.88.9]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA33394 for ; Wed, 27 Oct 1999 05:35:01 -0400 (EDT) (envelope-from nhuillard@ghs.fr) Received: from agen.int.ghs (agen.int.ghs [192.168.200.21]) by lectoure.ghs.fr (8.8.7/8.8.7) with SMTP id LAA24923; Wed, 27 Oct 1999 11:34:30 +0200 Received: by agen.int.ghs with Microsoft Mail id <01BF206F.3B77AA20@agen.int.ghs>; Wed, 27 Oct 1999 11:34:30 +0200 Message-ID: <01BF206F.3B77AA20@agen.int.ghs> From: Nicolas Huillard To: "'Dave Page'" Cc: "'pgsql-interfaces@postgresql.org'" Subject: RE: [INTERFACES] pgAdmin connection error on NT and W98 Date: Wed, 27 Oct 1999 11:34:28 +0200 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="---- =_NextPart_000_01BF206F.3B77AA20" ------ =_NextPart_000_01BF206F.3B77AA20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I solved the NT problem by reinstalling MDAC, and just reopened the user = session. I know I shouldn't use this server as a workstation, 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 (menu Schema/Tables) = or indexes (Schema/Indexes). Here is the log file : =20 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 = : =20 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 VBA modules inside = Access ? TIA, Nicolas Huillard G.H.S Directeur Technique T=E9l : +33 1 43 21 16 66 Fax : +33 1 56 54 02 18 mailto:nhuillard@ghs.fr http://www.ghs.fr ------ =_NextPart_000_01BF206F.3B77AA20 Content-Type: text/plain; name="pgAdmin - pb ODBC 2.log" Content-Transfer-Encoding: quoted-printable 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" =3D t."tablename" ORDER BY "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:=20 Environment Details ******************* Datasource: PostgreSQL Tracking: False TrackVer: 0 Connect: Provider=3DMSDASQL.1;Connect Timeout=3D15;Extended = Properties=3D"DSN=3DPostgreSQL;DATABASE=3Dtest;SERVER=3Dauch;PORT=3D5432;= UID=3Dnhuillard;PWD=3DXXXX;READONLY=3D0;PROTOCOL=3D6.4;FAKEOIDINDEX=3D1;S= HOWOIDCOLUMN=3D1;ROWVERSIONING=3D1;SHOWSYSTEMTABLES=3D1;CONNSETTINGS=3D";= Locale Identifier=3D1036 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. ------ =_NextPart_000_01BF206F.3B77AA20 Content-Type: text/plain; name="pgAdmin - pb migration.log" Content-Transfer-Encoding: quoted-printable 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 =3D = 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=E9n=E9rique devises" ( "s_Generation" = "int4", "s_Lineage" "", "Cl=E9 devise" "int4", "Code devise" "text" NOT = NULL, "Libell=E9 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:=20 Environment Details ******************* Datasource: PostgreSQL Tracking: False TrackVer: 0 Connect: Provider=3DMSDASQL.1;Connect Timeout=3D15;Extended = Properties=3D"DSN=3DPostgreSQL;DATABASE=3Dtest;SERVER=3Dauch;PORT=3D5432;= UID=3Dnhuillard;PWD=3DXXXX;READONLY=3D0;PROTOCOL=3D6.4;FAKEOIDINDEX=3D1;S= HOWOIDCOLUMN=3D1;ROWVERSIONING=3D1;SHOWSYSTEMTABLES=3D1;CONNSETTINGS=3D";= Locale Identifier=3D1036 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=E9n=E9rique devises 2" ( "Cl=E9 = devise" "int4", "Code devise" "text" NOT NULL, "Libell=E9 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D 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" =3D t."tablename" ORDER BY "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:=20 Environment Details ******************* Datasource: PostgreSQL Tracking: False TrackVer: 0 Connect: Provider=3DMSDASQL.1;Connect Timeout=3D15;Extended = Properties=3D"DSN=3DPostgreSQL;DATABASE=3Dtest;SERVER=3Dauch;PORT=3D5432;= UID=3Dnhuillard;PWD=3DXXXX;READONLY=3D0;PROTOCOL=3D6.4;FAKEOIDINDEX=3D1;S= HOWOIDCOLUMN=3D1;ROWVERSIONING=3D1;SHOWSYSTEMTABLES=3D1;CONNSETTINGS=3D";= Locale Identifier=3D1036 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=E9n=E9rique devises 2" ( "Cl=E9 = devise" "int4", "Code devise" "text" NOT NULL, "Libell=E9 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:=20 Environment Details ******************* Datasource: PostgreSQL Tracking: False TrackVer: 0 Connect: Provider=3DMSDASQL.1;Connect Timeout=3D15;Extended = Properties=3D"DSN=3DPostgreSQL;DATABASE=3Dtest;SERVER=3Dauch;PORT=3D5432;= UID=3Dnhuillard;PWD=3DXXXX;READONLY=3D0;PROTOCOL=3D6.4;FAKEOIDINDEX=3D1;S= HOWOIDCOLUMN=3D1;ROWVERSIONING=3D1;SHOWSYSTEMTABLES=3D1;CONNSETTINGS=3D";= Locale Identifier=3D1036 Version: 2.1 27/10/99 10:55:01 Loading Form: frmBugRep ------ =_NextPart_000_01BF206F.3B77AA20--