Trying To Use Migration Wizard...

From: Paul Malinowski <paul(dot)malinowski(at)wulfsberg(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Trying To Use Migration Wizard...
Date: 2002-10-15 22:49:33
Message-ID: 3DAC9B7D.6000004@wulfsberg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
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.2.2 running on a RedHat 8.0 system. The
following is the message from the log file.

2002-10-15 15:39:20 -
*******************************************************************
2002-10-15 15:39:20 - Error
2002-10-15 15:39:20 -
*******************************************************************
2002-10-15 15:39:20 - Error in Database Migration Wizard:Database
Migration Wizard:frmWizard.dbConnect: -2147217843 - Cannot start your
application. The workgroup information file is missing or opened
exclusively by another user.
2002-10-15 15:39:20 - Windows Version: Windows XP v5.1 build 2600
Service Pack 1
2002-10-15 15:39:20 - pgSchema Version: 1.2.0
2002-10-15 15:39:20 - MDAC Version: 2.7
2002-10-15 15:39:20 - DBMS Version: 07.02.0002 PostgreSQL 7.2.2 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux
8.0 3.2-7)
2002-10-15 15:39:20 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=axiom;PORT=5432;UID=pmalinow;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"

I start PGAdminII
Select "Plugins | Database Migration Wizard"
I select the "Access" radio button, browse to the Access DB i want to
convert and enter user and password.
Then I get another dialog box "Please Enter MS JET OLE DB Initialization
Information" that I'm not really sure wht to do with.
Pressing "OK" on that dialogbox yields the logged error message above.

Any help would really be apprieciated!

Thanks!

--
Paul Malinowski
Wulfsberg Electronics
Ph: (928)708-1575
Fx: (928)756-1640

Browse pgadmin-support by date

  From Date Subject
Next Message Serkan Bektas (SoftHome) 2002-10-16 08:02:12 Re: Problem with Locale , RE: "Runtime Error 55 File Already Open" after clicking the Databases in the tree
Previous Message Dave Page 2002-10-15 12:55:50 Re: Problem with locale