Postgres Pro
Downloads
Home   >   mailing lists

Thread: Trying To Use Migration Wizard...

Trying To Use Migration Wizard...

From
Paul Malinowski
Date:
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

Re: Trying To Use Migration Wizard...

From
"Dave Page"
Date:

> -----Original Message-----
> From: Paul Malinowski [mailto:paul.malinowski@wulfsberg.com]
> Sent: 15 October 2002 23:50
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Trying To Use Migration Wizard...
>
>
> 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 - 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.

Hi Paul,

The problem is that the Wizard cannot open the .mdw file. There is an
item on the todo list to allow selection of the file, but I don't know
when that will happen (or how for that matter - I know very little about
Access). Probably the best bet is to try one of the following:

1) Make sure the .mdw file is in the same location as the .mdb. If that
doesn't work, try dropping it in the pgAdmin working directory.

2) Copy the database and remove the security using access. If there is
no security the MS Jet engine won't need to access the mdw file.

Regards, Dave.