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
|
Список | 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 по дате отправления: