Re: ODBC MySQL driver porting to Microsoft SQL

>From looking around some docs this error code means that the MySql driver
does not support the needed ODBC conformance level to allow Access to use
the driver at all. You could try importing the data directly from SQL
Server (not through Access), this might work. SQL Server has something
called DTS that lets you import and export data.

--
Matt Neerincx [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1BFDD594-3871-491D-A019-ACF18BE4E3B5@xxxxxxxxxxxxxxxx
> Hi I am trying to port a MySQL database to microsoft SQL server 2000. I
> downloaded the mysql odbc driver, both versions 3.1 and 5.0. I am able to
> create the odbc machine source and the connection to the MySQL machine
> works
> but when I try to import a table into Access I get the error Microsoft
> access
> reserved error (-7701) there is no message for this error.
> Anyhow just wondering if anyone has any ideas?
> thanks.
> --
> Paul G
> Software engineer.


.

Relevant Pages
Loading