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
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 |