Steve
Thanks for replying. I have an Access 2000 database called webugnet and
I am attempting to Export it. I have installed MyODBC and configured a
mysql connection to the sql server on DSVR.
So, in the table window right click on the database and select "Export"
This brings up an "Export table to:" window In "Save As" select "ODBC"
and this brings up a window "Export webugnet to webugnet in ODBC
database".
Click "OK" and this brings up a window "Select Data Source" and on this
select "Machine Data Source"
Select the mysql connection with the correct database and click OK
Then up comes the error. I previously got a wrong user name and
password error but solved that one by correct configuration.
Hope you can follow what I am doing or doing wrong from this.
CHRIS
In message <[EMAIL PROTECTED]>, Steve Ruby
<[EMAIL PROTECTED]> writes
>Chris Wilkinson wrote:
>>
>> I am attempting to upload an Access db to a remote mysql server - at
>> dsvr in the UK.
>>
>> I get connected (I think) but receive the following error message:
>> Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
>>
>> Can you point me in the right direction for this or offer some help.
>>
>> Thanks
>>
>> CHRIS
>> --
>> Chris Wilkinson
>
>
>You need to explain better what you are doing. You cannot upload
>an Access DB to a MySQL server. You can upload and insert the data, you
>can write some program to make calls to both DBs and insert the data
>but you can't just upload the database?
>
>And where are you getting the error from, that error is from Access
>not mysql?
--
Chris Wilkinson
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
