Thread: Database Migration Error

Database Migration Error

From
"Fjeld, Shauna"
Date:
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


Re: Database Migration Error

From
"Dave Page"
Date:

> -----Original Message-----
> From: Fjeld, Shauna [mailto:shauna_fjeld@nrel.gov]
> Sent: 16 July 2003 15:13
> To: 'pgadmin-support@postgresql.org'
> Subject: [pgadmin-support] Database Migration Error
>
>
> 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.

Can you try the 1.5.60 release from http://www.pgadmin.org please?

Regards, Dave.