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 |
zubamark
Starting Member
23 Posts |
Posted - 2008-08-21 : 14:17:55
|
Can SQL2005 get data from MySQl that install on Mac? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
zubamark
Starting Member
23 Posts |
Posted - 2008-08-21 : 14:36:33
|
HOW? When I try to use openrowset select * from openrowset('SQLOLEDB','server';'db';'pwrd','SELECT * FROM INFORMATION_SCHEMA.TABLES') ERROR:OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".OLE DB provider "SQLNCLI" for linked server "(null)" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".Msg 53, Level 16, State 1, Line 0Named Pipes Provider: Could not open a connection to SQL Server [53]. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-08-21 : 18:43:38
|
The SQLOLEDB is provider is only for use with SQL Server data sources.CODO ERGO SUM |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-22 : 00:05:50
|
You should install MySql odbc driver on sql server then query MySql via odbc provider. |
|
|
|
|
|