RE: [INTERFACES] pgAdmin connection error on NT and W98 - Mailing list pgsql-interfaces
| From | Nicolas Huillard |
|---|---|
| Subject | RE: [INTERFACES] pgAdmin connection error on NT and W98 |
| Date | |
| Msg-id | 01BF206F.3B77AA20@agen.int.ghs Whole thread Raw |
| List | pgsql-interfaces |
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
pgsql-interfaces by date: