Hi,
I'm trying to use the DB Migration Wizard to migrate an MS Access 97 .mdb
database to postgres 7.3. I first installed mdac and the jet engine, then
the wizard dll. In pgAdmin I connect to my database without any trouble,
but when I click on the migration wizard plugin, I get an errormessage.
This is the log:
2003-02-17 13:14:05 -
*******************************************************************
2003-02-17 13:14:05 - Error(s)
2003-02-17 13:14:05 -
*******************************************************************
2003-02-17 13:14:05 - Error in pgAdmin II:frmMain.mnuPluginsPlg_Click: 13
- Type mismatch
2003-02-17 13:14:05 - Windows Version: Windows NT v4.0 build 1381 Service
Pack 6
2003-02-17 13:14:05 - pgSchema Version: 1.4.12
2003-02-17 13:14:05 - MDAC Version: 2.7
2003-02-17 13:14:05 - DBMS Version: 07.02.0005 PostgreSQL 7.3 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.1 20021207 (Gentoo Linux
3.2.1-20021207)
2003-02-17 13:14:05 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=223.223.223.223;PORT=5432;UID=test;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"
Any idea what's causing this?
-S
