Migration wizard cannot connect via ODBC

Поиск
Список
Период
Сортировка
От Dan Langille
Тема Migration wizard cannot connect via ODBC
Дата
Msg-id 3EF5949C.20949.2FAA9FF8@localhost
обсуждение исходный текст
Ответы Re: Migration wizard cannot connect via ODBC  ("Dave Page" <dpage@vale-housing.co.uk>)
Список pgadmin-support
I'm trying to copy the data in a MySQL database over to a PostgreSQL 
database.  I'm running:

- mysql 3.23.57-nt under Windows XP
- PostgreSQL 7.3.3 under FreeBSD 4.8
- pgAdmin II 1.4.12

Here are my steps:

1 - Connect to my pg db
2 - Select menu item Plugins -> Database Migration Wizard
3 - click on ODBC
4 - From the Datasource drop down list box, select the ODBC database
5 - type in the user name (root)
5 - click on Next

It it then that I get the lovely Windows message "pgAdmin II has 
encountered a problem and needs to close.  We are sorry for 
inconvenience."

If I suppy the wrong user name (e.g. rooted), I get an access denied 
message.

Through the control panel, I have confirmed that the ODBC connection 
works by clicking on the "Test Data Source" button. I've taken scree 
shots of the various ODBC settings:

http://beta.freebsddiary.org/tmp/odbc-main.jpg
http://beta.freebsddiary.org/tmp/odbc-options.jpg
http://beta.freebsddiary.org/tmp/odbc-test.jpg

Any ideas?  Thanks.
-- 
Dan Langille : http://www.langille.org/



В списке pgadmin-support по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: Bug report for pgAdmin III
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Migration wizard cannot connect via ODBC