pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpgAdmin connection error on NT and W98
6+ messages / 2 participants
[nested] [flat]
* pgAdmin connection error on NT and W98
@ 1999-10-26 16:59 Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 0 replies; 6+ messages in thread
From: Nicolas Huillard @ 1999-10-26 16:59 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
I have different errors while running pgAdmin (6.5.2) on NT (4.0 SP4) and Windows 98, connecting to a Linux box (RH 5.1, Postgres 6.5.2 RPMs).
Under W98 :
I first installed just pgAdmin, then deinstalled it, and installed MDAC (mdac_typ.exe, 6.492.488 bytes), DCOM98 (dcom98.exe, 1.229.056 bytes) and then pgAdmin.
The error occurs while opennign the main pgAdmin window :
**********************************************************************
* Error - 26/10/99 17:45:57
**********************************************************************
Software
********
Program: pgAdmin
Version: 6.5.2
Sub or Function: frmMain, MDIForm_Load
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: 0
Available Swap: 2047569920
Available Virtual: 2085289984
Percentage Free: 81
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=XXXXXX;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS=";Locale Identifier=1036
Version: 2.1
**********************************************************************
I can open pgAdmin windows, but many things doesn't work. This error often arrives when openning windows.
I then had the following error while trying to migrate an Access database (last button in the migration wizard) :
**********************************************************************
* Error - 26/10/99 17:50:28
**********************************************************************
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: 24576
Available Swap: 2045628416
Available Virtual: 2003042304
Percentage Free: 82
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=XXXXXXXX;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS=";Locale Identifier=1036
Version: 2.1
**********************************************************************
Under NT:
I cannot connect to Postgres using pgAdmin. I installed MDAC 2.1, then pgAdmin. The problem is that this machine is a very used server, and I cannot reboot it when I want, if I install something.
The error is stored in VSErr.log, and not in pgAdmin.log :
**********************************************************************
* Error - 25/10/99 18:48:49
**********************************************************************
Software
********
Program: Unknown
Version: Unknown
Sub or Function: frmODBCLogon, cmdOK_Click
Error Details
*************
Error No: 430
Error Description: Class does not support Automation or does not support expected interface
Error Source: vsError
DLL Error Code: 0
Memory Details
**************
Total Physical: 133615616
Total Swap: 275083264
Total Virtual: 2147352576
Available Physical: 60940288
Available Swap: 137273344
Available Virtual: 2103435264
Percentage Free: 0
System Details
**************
Processor: 586
OEM ID: 0
No. Processors: 1
Page Size: 4096
OS Details
**********
Platform: Windows NT
Version: 4.0
Build: 1381
OS Info: Service Pack 4
Environment Details
*******************
Datasource:
Tracking: False
TrackVer: 0
TIA
Nicolas Huillard
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [INTERFACES] pgAdmin connection error on NT and W98
@ 1999-10-27 08:46 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 6+ messages in thread
From: Dave Page @ 1999-10-27 08:46 UTC (permalink / raw)
To: 'Nicolas Huillard' <nhuillard@ghs.fr>; +Cc: pgsql-interfaces
Hello,
> -----Original Message-----
> From: Nicolas Huillard [mailto:nhuillard@ghs.fr]
> Sent: 26 October 1999 16:59
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] pgAdmin connection error on NT and W98
<SNIP>
> The error occurs while opennign the main pgAdmin window :
This is a known bug that has been fixed for the next release! If you go to:
System -> Tracking
you will be asked if you wish to create some required tables.
> I then had the following error while trying to migrate an
> Access database (last button in the migration wizard) :
I can't reproduce this error at all. Does it still occur after the first
problem has been fixed? If so, please switch on logging (File -> Logging),
exit and restart pgAdmin and then re-create the error and send me the
logfile.
> Under NT:
> I cannot connect to Postgres using pgAdmin. I installed MDAC
> 2.1, then pgAdmin. The problem is that this machine is a very
> used server, and I cannot reboot it when I want, if I install
> something.
> The error is stored in VSErr.log, and not in pgAdmin.log :
Any errors that occur before pgAdmin has finished starting up will be logged
to VSErr.log. When a file is installed on a win32 machine, if an older
version is already on the system and is locked open, then the install
program will copy the new file to a temporary filename which will be moved
into place on reboot. This is essential for files such as the Visual C
runtime libraries that windows needs to startup and run.
To cut a long explanation short, you *must* reboot if you want things to
work correctly. I would suggest though that you should avoid running
anything (other than backup/server management software etc.) on a server
that is that critical.
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [INTERFACES] pgAdmin connection error on NT and W98
@ 1999-10-27 09:34 Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 0 replies; 6+ messages in thread
From: Nicolas Huillard @ 1999-10-27 09:34 UTC (permalink / raw)
To: 'Dave Page' <dpage@vale-housing.co.uk>; +Cc: 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 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
* RE: [INTERFACES] pgAdmin connection error on NT and W98
@ 1999-10-27 11:08 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 6+ messages in thread
From: Dave Page @ 1999-10-27 11:08 UTC (permalink / raw)
To: 'Nicolas Huillard' <nhuillard@ghs.fr>; +Cc: pgsql-interfaces
Hello,
> -----Original Message-----
> From: Nicolas Huillard [mailto:nhuillard@ghs.fr]
> Sent: 27 October 1999 09:34
> To: 'Dave Page'
> Cc: 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] pgAdmin connection error on NT and W98
>
>
> 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 :
That's the other bug! If you execute:
CREATE VIEW pgadmin_ver AS SELECT version() AS version;
on each database you use that error should go away. Again this has been
fixed for v6.5.3.
I am looking at the other problem and will let you know when I have found
something...
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [INTERFACES] pgAdmin connection error on NT and W98
@ 1999-10-28 09:04 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 6+ messages in thread
From: Dave Page @ 1999-10-28 09:04 UTC (permalink / raw)
To: 'Nicolas Huillard' <nhuillard@ghs.fr>; +Cc: pgsql-interfaces
> -----Original Message-----
> From: Nicolas Huillard [mailto:nhuillard@ghs.fr]
> Sent: 27 October 1999 09:34
> To: 'Dave Page'
> Cc: 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] pgAdmin connection error on NT and W98
>
> 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 :
>
I have tested pgAdmin with OLE fields in an Access MDB, and they seem to
work correctly on my system (that is, the table is created, but the
Migration Wizard cannot migrate blob data and will ignore it). My guess is
that you do not have the lo datatype configured on your PostgreSQL system.
If this is the case, you can create it with the following SQL:
CREATE TYPE "lo" ( internallength = 4,
externallength = 10,
input = int4in,
output = int4out,
send = int4out,
receive = int4in,
default = '',
passedbyvalue);
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [INTERFACES] pgAdmin connection error on NT and W98
@ 1999-10-28 09:51 Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 0 replies; 6+ messages in thread
From: Nicolas Huillard @ 1999-10-28 09:51 UTC (permalink / raw)
To: 'Dave Page' <dpage@vale-housing.co.uk>; +Cc: pgsql-interfaces
OK, it works fine, but the data is not copied, because of the large binary objects (the message is quite clear).
I will look at ftp://ftp.sdc.com.au/pub/repl for "a general purpose database replicator for any pair of databases which inderstand ODBC" (as posted in this list by Stephen Davies).
The last (I hope) problem is due to database protection : my Access databases are password protected, by an Access Workgroup (MDW file). pgAdmin says it can't access the database, even if I type the right Username/Password in the Database Migration Wizard. The message is :
Error Details
*************
Error No: 3033
Error Description: You don't have the necessary permissions to use the 'C:\Donnees\G.H.S\Creation\Nutrigest\Développement\Bases\Internet Nutrigest admin.mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.
Error Source: DAO.Workspace
DLL Error Code: 0
TIA,
Nicolas Huillard
-----Message d'origine-----
De: Dave Page [SMTP:dpage@vale-housing.co.uk]
Date: jeudi 28 octobre 1999 11:04
À: 'Nicolas Huillard'
Cc: 'pgsql-interfaces@postgresql.org'
Objet: RE: [INTERFACES] pgAdmin connection error on NT and W98
> -----Original Message-----
> From: Nicolas Huillard [mailto:nhuillard@ghs.fr]
> Sent: 27 October 1999 09:34
> To: 'Dave Page'
> Cc: 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] pgAdmin connection error on NT and W98
>
> 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 :
>
I have tested pgAdmin with OLE fields in an Access MDB, and they seem to
work correctly on my system (that is, the table is created, but the
Migration Wizard cannot migrate blob data and will ignore it). My guess is
that you do not have the lo datatype configured on your PostgreSQL system.
If this is the case, you can create it with the following SQL:
CREATE TYPE "lo" ( internallength = 4,
externallength = 10,
input = int4in,
output = int4out,
send = int4out,
receive = int4in,
default = '',
passedbyvalue);
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~1999-10-28 09:51 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-26 16:59 pgAdmin connection error on NT and W98 Nicolas Huillard <nhuillard@ghs.fr>
1999-10-27 08:46 RE: [INTERFACES] pgAdmin connection error on NT and W98 Dave Page <dpage@vale-housing.co.uk>
1999-10-27 09:34 RE: [INTERFACES] pgAdmin connection error on NT and W98 Nicolas Huillard <nhuillard@ghs.fr>
1999-10-27 11:08 RE: [INTERFACES] pgAdmin connection error on NT and W98 Dave Page <dpage@vale-housing.co.uk>
1999-10-28 09:04 RE: [INTERFACES] pgAdmin connection error on NT and W98 Dave Page <dpage@vale-housing.co.uk>
1999-10-28 09:51 RE: [INTERFACES] pgAdmin connection error on NT and W98 Nicolas Huillard <nhuillard@ghs.fr>
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