can I link a table from MySQL in SQL Server? 1

[cs211024]

Hi, inside SQL Server, is there a way to link a table from MySQL? The reason for that is the front end software what I used can only run on Microsoft platform.

Many thanks.

 

[philhege]

cs211024,

Find the ODBC driver for MySQL, and create a link server in Enterprise Manager to a DSN based on the driver.

HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....
-----------
A skeleton walks into a bar, and says "I'll have a beer and a mop.