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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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.


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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group