Thread: 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 ?
Regards,
Ermanno PREDONZAN
-----Original Message-----
From: Ermanno PREDONZAN [mailto:ermanno.predonzan@ezit.ts.it]
Sent: 03 April 2003 18:48
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Migration form MSACCESS via ODBCWith 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.
Sorry 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 PageSent: Thursday, April 03, 2003 9:02 PMSubject: RE: [pgadmin-support] Migration form MSACCESS via ODBC-----Original Message-----
From: Ermanno PREDONZAN [mailto:ermanno.predonzan@ezit.ts.it]
Sent: 03 April 2003 18:48
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Migration form MSACCESS via ODBCWith 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.orgThen 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.
Hi,
-----Original Message-----
From: Ermanno PREDONZAN [mailto:ermanno.predonzan@ezit.ts.it]
Sent: 05 May 2003 18:01
To: Dave Page; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Migration form MSACCESS via ODBCSorry I cannot connect to the website cvs.pgadmin.org (193.195.77.163).
The problems with the IP address have now been resolved. cvs.pgadmin.org should work fine now - it's at 80.176.1.147 which should not change again.
Also when installing pgAdmin II as Administrator under Windows 2000 I have the following:Error 1931cannot update the system fileC:\WINNT\System32\hhctrl.ocxbecause the file is protected by Windows.
This is normal in some situations and may be ignored.
And then pgAdmin II works, but the connection is VERY slow especially whenclicking on:Schemaspublic
Please make sure that logging is *not* set to Full Debug (under Tools -> Options), and that ODBC Tracing is turned off. You can check this in the ODBC Driver Manager in the Administrative Tools folder.
Regards, Dave.