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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-11 : 07:55:51
|
| Phan writes "Hello SQLTeam,Please help me in resolving an issue which I have been facing with Linked Servers.We are using MS SQL Server 2000. I'm trying to setup a Linked Server to MySQL DB which is running on a different box.The following are the steps which I had followed.1. Installed MySQL DB on Box 2. Enabled remote access to this DB.2. On Box 1, which is running SQL Server 2000, created a System DSN which is pointing to MySQL DB on Box2. The test connection was successful.3. I have used MySQL ODBC 3.51 Driver for the above.4. Created a Linked Server called LinkMySQL. The creation of the Linked Server was successful.5. When I tried to access the Linked Server, I got an error message, which is as following:ERROR 7399: OLEDB Provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure.Any help in this regards is appreciated.Thanks." |
|
|
|
|
|
Linked Server