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

Migration Wizard error type mismatch

From: Silje Ausen <ausen(at)stud(dot)ntnu(dot)no>
To: pgadmin-support(at)postgresql(dot)org
Subject: Migration Wizard error type mismatch
Date: 2003-02-17 12:23:09
Message-ID: Pine.LNX.4.51.0302171315530.25473@gaupe.stud.ntnu.no (view raw or flat)
Thread:
Lists: pgadmin-support
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


pgadmin-support by date

Next:From: Dave PageDate: 2003-02-17 12:53:01
Subject: Re: Migration Wizard error type mismatch
Previous:From: Dave PageDate: 2003-02-16 20:51:06
Subject: Re: pgadmin2-1_4_12 CURSOR PROBLEM. IT RETURNS 'Query executed Ok'!!!Why??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group