Database Migration Error

From: "Fjeld, Shauna" <shauna_fjeld(at)nrel(dot)gov>
To: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Database Migration Error
Date: 2003-07-16 14:13:07
Message-ID: 2FCE8613B36ED2118EB800805F6F05AF095CF4A1@nt-comm6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,
I'm trying to migrate an Access 2000 database to Postgres. Even with the
most simple database (1 table, 1 field), I get the following error:

380: Invalid property value

Rolling back... Done.

Here is the log file.

2003-07-16 08:04:43 - Executing Plugin: Database Migration Wizard v1.4.12
2003-07-16 08:04:49 - Opening and Examining Source Database...
2003-07-16 08:04:49 - Opening File: C:\weatherization.mdb
2003-07-16 08:04:49 - Opened connection:
Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=C:\weatherization.mdb;Mode=Share Deny None;Extended Properties="";Jet
OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database
Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet
OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet
OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet
OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on
Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False
2003-07-16 08:04:49 - Provider: Microsoft.Jet.OLEDB.4.0 v2.5
2003-07-16 08:04:49 - Quote Character: '`'
2003-07-16 08:04:49 - Done - 0.07 Secs.
2003-07-16 08:04:49 - Looking for possible target databases...
2003-07-16 08:04:49 - Done - 0 Secs.
2003-07-16 08:04:54 - Migrating database...
2003-07-16 08:04:54 - Opening cnDatabase: Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=weatherization;SERVER=enterprise;PO
RT=XXXX;UID=xeieje;PWD=****;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidCo
lumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=409
6;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog
=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVa
rchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;L
FConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"
2003-07-16 08:04:54 - SQL (weatherization): ROLLBACK
2003-07-16 08:04:54 - Done - 0.12 Secs.

Can anyone help?
thanks,
Shauna

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-07-16 14:27:40 Re: BUG: pgAdmin III View table with empty strings
Previous Message Marc Cuypers 2003-07-16 12:16:57 changing comment for a table makes pgadmin III crash