Re: MySQL linked server on SQL Server 2000

I'm not sure about a fix for the specific issue you mention above but
i've found this post providing details on making the connection via ODBC
between MSSQL2000 and MySQL.

http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

Hope this helps.

Paul


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • MySQL on Win 98
    ... I'm just getting into MySQL and I'm trying to learn about it at home. ... and created a DSN connection for it. ... User: root ... ODBC Data Source Administrator and get a "success" result. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Local Access database to shared PHP/MySql hosting export
    ... The client has an ADSL connection. ... Long ago I was shown how Excel could query data from a mysql ... database _on Linux_ using ODBC. ... access the linux mysql server, and then use that connection to allow MS ...
    (comp.lang.php)
  • Re: Local Access database to shared PHP/MySql hosting export
    ... ODBC connection. ... ODBC to the MySQL Server. ...
    (comp.lang.php)
  • Re: VFP8 and MySQL
    ... I have partly solved the connection problem by doing the following:- ... error but got the ball rolling (and a hint that I needed a user named ODBC) ... Setting up a MySQL user called ODBC with no password ...
    (microsoft.public.fox.programmer.exchange)
  • Re: VFP Updates?
    ... Try talking ODBC or OleDb and they say HU. ... make up my apps so that what ever they want to run has to be from a command ... kind of connection and assign it the right to do exactly what you want. ...
    (microsoft.public.fox.programmer.exchange)
Loading