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