pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive help / color / mirror / Atom feed From: Nicolas Huillard <nhuillard@ghs.fr>
To: 'Dave Page' <dpage@vale-housing.co.uk>
Cc: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgresql.org>
Subject: RE: [INTERFACES] pgAdmin connection error on NT and W98
Date: Wed, 27 Oct 1999 11:34:28 +0200
Message-ID: <01BF206F.3B77AA20@agen.int.ghs> (raw )
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 :
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 VBA modules 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
Attachments:
pgAdmin - pb ODBC 2.log (text/plain, 1.7K) download
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" 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:
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.
pgAdmin - pb migration.log (text/plain, 8.0K) download
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", "Code devise" "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" 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:
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
view thread (6+ messages) latest in thread
Message-ID: <01BF206F.3B77AA20@agen.int.ghs>
Permalink: ../01BF206F.3B77AA20@agen.int.ghs/
Also on: postgresql.org/message-id/01BF206F.3B77AA20@agen.int.ghs
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: nhuillard@ghs.fr, dpage@vale-housing.co.uk
Subject: RE: [INTERFACES] pgAdmin connection error on NT and W98
In-Reply-To: <01BF206F.3B77AA20@agen.int.ghs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox