Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2002-07-03 : 12:14:46
|
| Hi, I'm trying to do a linked server on MSSQL 2000 to a MySQL DB. I Installed the MyODBC drivers. I was successful making an Access project with that DB so my ODBC DSN is working. Anybody was successful doing a Linked Server with MySQL??What is the syntax for the fields?ProductName:DataSource:ProviderString:Location:Catalog:thanks a lot! |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-05 : 06:35:08
|
| If you have a DSN configured all you need to do is put your DSN name in the Datasource field.HTHJasper SmithEdited by - jasper_smith on 07/05/2002 06:35:30 |
 |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2002-07-05 : 09:49:07
|
| Ok with this, I can see my tables in my linked server, but I can't query them, it tells me "invalid catalog" something like that. On microsoft site they say to use OpenQuery to resolve this bug. Like this : select * from openquery(mysql,'select * from validation') When I use this synthax, my Mssql service is running at 99% until I kill it.Anyone found a workaround, I can use DTS to get my tables, but when it comes to update and delete, I could appreciate the linked server.Thanks |
|
|
|
|
|
|
MySQL ODBC linked Server