Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group