I am trying to migrate an Access database to PostgreSQL (behind our
firewall) using the Database Migration Wizard. I select "Access" as the
Database Type and enter the local path in the ".mdb File". After clicking
on "Next", I get the following message (lifted from the "pgAdmin II_xxx.log"
file) and the migration to the remote server fails.
2002-05-30 10:05:19 -
*******************************************************************
2002-05-30 10:05:19 - Error
2002-05-30 10:05:19 -
*******************************************************************
2002-05-30 10:05:19 - Error in Database Migration Wizard:Database Migration
Wizard:frmWizard.dbConnect: -2147319779 - Automation error[0A]Library not
registered.
2002-05-30 10:05:19 - Windows Version: Windows NT v4.0 build 1381 Service
Pack 6, RC 1.3
2002-05-30 10:05:19 - pgSchema Version: 1.2.0
2002-05-30 10:05:19 - MDAC Version: 2.5
2002-05-30 10:05:19 - DBMS Version: 07.01.0009 PostgreSQL 7.2.1 on
i586-pc-linux-gnu, compiled by GCC 2.96
2002-05-30 10:05:19 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=pgserver.tva.gov;P
ORT=5432;UID=postgres;PWD=********;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SH
OWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOC
KET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;
COMMLOG=0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSA
SLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXE
S=dd_"
File information: pgAdmin2.exe is verion 1.02; pgMigration.dll is version
1.02 and was successfully registered. This happened before and after the NT
workstation was rebooted. Any help would be appreciated.
------------------------------------------------------------------------
Ken Whiteley (kmwhiteley@tva.gov)
Internet Services
TVA Information Services
Chattanooga, TN