Can use SQL Server 2005 to Connection (link table) mySQL table ?
-
Assuming in network LAN have got 2 computer : Computer A and Computer B, Computer A installed mySQL and have got IP:192.168.1.100 and port: 2050, Computer B installed SQL Server 2005, form machine B can connection (or link table) to machine A have mySQL ? Is EveryOne this guide can share me with. thank
-
Assuming in network LAN have got 2 computer : Computer A and Computer B, Computer A installed mySQL and have got IP:192.168.1.100 and port: 2050, Computer B installed SQL Server 2005, form machine B can connection (or link table) to machine A have mySQL ? Is EveryOne this guide can share me with. thank
You might be able to use OPENROWSET, at least it is a avenue of research!
Never underestimate the power of human stupidity RAH
-
Assuming in network LAN have got 2 computer : Computer A and Computer B, Computer A installed mySQL and have got IP:192.168.1.100 and port: 2050, Computer B installed SQL Server 2005, form machine B can connection (or link table) to machine A have mySQL ? Is EveryOne this guide can share me with. thank
I got this from a google search ("sql server 2005 linked server to mysql") How to Create Linked Server for a MySQL database using SQL Server Management Studio[^]
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
I got this from a google search ("sql server 2005 linked server to mysql") How to Create Linked Server for a MySQL database using SQL Server Management Studio[^]
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
Well I'll be dammed, thinking about it you can do a linked server to Oracle so it should be logical that the MySQL has been solved as well. Have 5.
Never underestimate the power of human stupidity RAH
-
I got this from a google search ("sql server 2005 linked server to mysql") How to Create Linked Server for a MySQL database using SQL Server Management Studio[^]
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
In a LAN with multiple computers, a few machines installed MySQL you can use the command line in cmd.exe (or any software) to know how many LAN computers are not installed MySQL ? for example in SQL Server have command line: osql -L