Database Migration Error - Mailing list pgadmin-support

From Fjeld, Shauna
Subject Database Migration Error
Date
Msg-id 2FCE8613B36ED2118EB800805F6F05AF095CF4A1@nt-comm6
Whole thread Raw
List 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


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: minor bug in pgAdmin3 when creating views
Next
From: "Dave Page"
Date:
Subject: Re: Database Migration Error