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 |
|
bendertez
Yak Posting Veteran
94 Posts |
 Posted - 2009-06-08 : 04:14:03
|
| HelloI'm trying to link a MYSQL database (held on a LINUX server) as a linked server through SQL Server 2005.I have installed all the relevant software - ODBC MYQL drivers (latest version) and have set up an ODBC DNS which seems to connect with no problems. I have also set up the linked server which enables me to see the MYSQL database and expand to the tables, however i can't see any tables, the folder is empty.This seems to me like its a priovelege issue within MYSQL, howevere all the priveleges seem okay and look like they are setup to see SQL server 2005 user.Can anyone shed any ligtht on this?Could it be something to do with it being on a LINUX server?Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-08 : 05:05:08
|
http://www.connectionstrings.com/mysql
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Linked Server to MYSQL database