June 8, 2005 at 8:01 am
Has anyone managed to connect from sql server to mysql on linux via a linked server. I'm using the Microsoft OLE DB Provider for ODBC Drivers
if someone can help me complete the product name & provider string fileds I'd be grateful. Stumped.Thks.
June 9, 2005 at 8:56 am
I'm not sure about product name, but the provider string should be something like this:
DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;
June 9, 2005 at 10:50 am
I connect to a Postgres dataabse on Linux using a System DSN ODBC Connection "Data source" and I specify the IP if the server for "Provider String" AND and "Location". I use an IP because its across a domain. Its a bit tricky and I'm sure theies more than one way to do it. Same should work for MySql.
-Isaiah
June 10, 2005 at 1:53 am
The last response did the trick. Many thanks.
June 10, 2005 at 11:16 am
Happy to help out. Youre very welcome.
-Isaiah
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply