Migration Wizard Error: Library not registered

From: "Whiteley, Kenneth M(dot)" <kmwhiteley(at)tva(dot)gov>
To: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Migration Wizard Error: Library not registered
Date: 2002-05-30 14:28:36
Message-ID: 5371ABDC57CCD411926700508BCFE572043512C8@tvachaxch2.cha.tva.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)tva(dot)gov)
Internet Services
TVA Information Services
Chattanooga, TN

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-05-30 14:34:55 Re: Migration Wizard Error: Library not registered
Previous Message Dave Page 2002-05-30 08:32:41 Re: PROBLEM - Creating a database cluster