Re: Migration form MSACCESS via ODBC

MessageSorry I cannot connect to the website cvs.pgadmin.org (193.195.77.163).

Also when installing pgAdmin II as Administrator under Windows 2000 I have the following:

Error 1931
cannot update the system file
C:\WINNT\System32\hhctrl.ocx
because the file is protected by Windows.

And then pgAdmin II works, but the connection is VERY slow especially when
clicking on:

Schemas
public

Regards,

Ermanno PREDONZAN
----- Original Message -----
From: Dave Page
To: Ermanno PREDONZAN ; pgadmin-support(at)postgresql(dot)org
Sent: Thursday, April 03, 2003 9:02 PM
Subject: RE: [pgadmin-support] Migration form MSACCESS via ODBC

-----Original Message-----
From: Ermanno PREDONZAN [mailto:ermanno(dot)predonzan(at)ezit(dot)ts(dot)it]
Sent: 03 April 2003 18:48
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Migration form MSACCESS via ODBC

With Yours DataBase Migration Wizard when trasferring 'data/time' values from MSAccess I have always this warning:

Bad date external representation
"1999-12-16 00.00.00".

Why ?

Because your PostgreSQL installation doesn't understand your local time format. The latest snapshot should fix this, but due to ISP issues you will have difficulty getting to the CVS server where the files are. As a temporary fix, please add the following line to your 'hosts' file:

193.195.77.163 cvs.pgadmin.org

Then is you browse to that website (using the name, not the address), in the binaries directory you will find instructions for downloading and installing the latest snapshot. If you have problems, let me know and I'll email it to you tomorrow when I get to the office.

Regards, Dave.