I managed something similar to this once before but now I can't make it work again.
I want to export some Access database tables to mySql. I am trying to use ODBC. It's all installed and set up in my Windows machine (Vmware). In the "ODBC Data Source Administrator" the connection I have set up to the mySql database tests OK.
However when I try to Export from my Access database I get a pop up box saying:-
[MySQL][ODBC 3.51 Driver]User cancelled
A Google search for this error doesn't reveal much of help. I've tried turning on the logging for the ODBC connection and I'm none the wiser really.
What I can't really understand is that when I do the export it doesn't allow me to select the database to export to, how can it do an export of a table without knowing the database name? If I click on the Database pull-down in the export configuration it says "Loading database list not implemented for SQLDriverConnect()".
Any ideas anyone?
On Sun, Oct 05, 2008 at 04:26:03PM +0100, Chris G wrote:
I managed something similar to this once before but now I can't make it work again.
I want to export some Access database tables to mySql. I am trying to use ODBC. It's all installed and set up in my Windows machine (Vmware). In the "ODBC Data Source Administrator" the connection I have set up to the mySql database tests OK.
However when I try to Export from my Access database I get a pop up box saying:-
[MySQL][ODBC 3.51 Driver]User cancelledA Google search for this error doesn't reveal much of help. I've tried turning on the logging for the ODBC connection and I'm none the wiser really.
What I can't really understand is that when I do the export it doesn't allow me to select the database to export to, how can it do an export of a table without knowing the database name? If I click on the Database pull-down in the export configuration it says "Loading database list not implemented for SQLDriverConnect()".
Any ideas anyone?
It was something arcane to do with mySql privileges, I found that another used *could* create what I wanted. Even though I thought I'd got them both the same the wanted user still couldn't create the tables so I deleted the user and started again - it then worked.
-
Chris G