Database migration from Access 2000

From: Bernd Ruppel <berupp(at)yahoo(dot)de>
To: pgadmin-support(at)postgresql(dot)org
Subject: Database migration from Access 2000
Date: 2002-10-08 18:02:22
Message-ID: 20021008180222.67995.qmail@web14605.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Dear support team,

I'm trying to migrate an Access 2000 database to
PostgreSQL 7.20.

While migrating a table that doesn't contain any data
the following error message occurs:

An error occured at: 08.10.2002 19:07:01:
94: Ungueltige Verwendung von Null ("Invalid usage of
Null")

The log file says:

2002-10-08 18:58:30 - SQL (MLTD_Postgre): BEGIN
2002-10-08 18:58:30 - Creating table: tbl_tokens
2002-10-08 18:58:30 - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
2002-10-08 18:58:30 - Entering Database Migration
Wizard:frmWizard.bIsAutoIncrement()
2002-10-08 18:58:30 - Entering Database Migration
Wizard:frmWizard.bIsAutoIncrement()
2002-10-08 18:58:30 - Entering Database Migration
Wizard:frmWizard.bIsAutoIncrement()
2002-10-08 18:58:30 - Entering Database Migration
Wizard:frmWizard.bIsAutoIncrement()
2002-10-08 18:58:30 - Entering Database Migration
Wizard:frmWizard.bIsAutoIncrement()
2002-10-08 18:58:30 - Entering Database Migration
Wizard:frmWizard.bIsAutoIncrement()
2002-10-08 18:58:30 - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
2002-10-08 18:58:30 - Entering
pgSchema:pgServer.Property Get Databases()
2002-10-08 18:58:30 - Entering
pgSchema:Databases.Property Get
Item("MLTD_Postgre")
2002-10-08 18:58:30 - Entering
pgSchema:pgDatabase.Execute("ROLLBACK", 0, -1)

2002-10-08 18:58:30 - Entering
pgSchema:pgDatabase.dbConnect()
2002-10-08 18:58:30 - Entering
pgSchema:pgServer.ExecSQL("ROLLBACK",
"Connection: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=MLTD_Postgre;SERVER=konfuzius.intern.uni-erfurt.de;PORT=5432;UID=jachimume;PWD=nihao;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0"")

2002-10-08 18:58:30 - SQL (MLTD_Postgre): ROLLBACK
2002-10-08 18:58:30 - Entering Database Migration
Wizard:frmWizard.txtStatus_Change()
2002-10-08 18:58:30 - Done - 0,26 Secs.

Thanks and greetings

Bernd Ruppel

__________________________________________________________________

Gesendet von Yahoo! Mail - http://mail.yahoo.de
Möchten Sie mit einem Gruß antworten? http://grusskarten.yahoo.de

Browse pgadmin-support by date

  From Date Subject
Next Message ..:: Gilbert B. Gabog ::.. 2002-10-09 01:24:55 Password
Previous Message Johnson, Shaunn 2002-10-07 22:45:44 meaning of following errors