connect to windows mysql from linux

[sanjivsudhakar]

Hello I want to connect to a windows sql server 2000 database from linux.


Any one have idea to connect to the the system

[zeebiggie]

First things first: We need to know on what network your sql server is on. Is it on an Intranet or the internet? If its on the the intranet the you will have configure your linux server to communicate with you sql server. use samba do that. Once the two machines can talk then either use the complete domain or IP address of you sql server in your connection statement.

if its on the internet the you use the complete domain name of that sql server in your connect statements

[sherlabs03]

Hi!
I am actually in the situation right now where in I am trying to establish a connection using openrowset within our MS SQL server 2005 (in a domain) to a visual foxpro database stored and is shared in linux box (sles 9) using samba 3.0.4. and won't work, the error is: OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Visual FoxPro Driver]File 'employee_latest.dbf' does not exist.".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "(null)".

Here's my script:
select idnumber from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceDB=\\samba\payroll\;SourceType=DBF',' select * from employee_latest')

Note: I tried copying the employee_latest table to my desktop and to other window servers and the script just worked flawlessly. I don't what went wrong or what's the issue between samba and sql server.

Any thoughts would be appreciated thanks.
[
QUOTE=zeebiggie]First things first: We need to know on what network your sql server is on. Is it on an Intranet or the internet? If its on the the intranet the you will have configure your linux server to communicate with you sql server. use samba do that. Once the two machines can talk then either use the complete domain or IP address of you sql server in your connection statement.

if its on the internet the you use the complete domain name of that sql server in your connect statements[/quote]