From: | "Dan Langille" <dan(at)langille(dot)org> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Migration wizard cannot connect via ODBC |
Date: | 2003-06-22 15:35:56 |
Message-ID: | 3EF5949C.20949.2FAA9FF8@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-06-22 15:51:24 | Re: Migration wizard cannot connect via ODBC |
Previous Message | Andreas Pflug | 2003-06-20 09:28:04 | Re: Bug report for pgAdmin III |