MySQL linked server on SQL Server 2000
- From: "Pete Griffiths" <peteg@xxxxxxxxxx>
- Date: Mon, 15 Oct 2007 09:06:17 +0100
Hi folks,
I'm having a spot of bother creating a linked MySQL server on SQL2K.
I'm using the following code on an SP4 SQL2K instance. MySQL 5.1 is installed on the same box, and I've installed the MySQL ODBC 3.51 Driver.
sp_addlinkedserver
'myAlias'
, 'MySQL'
, 'MSDASQL'
, Null
, Null
, 'Driver={MySQL ODBC 3.51 Driver};DB=myDatabase;UID=myUserName;PWD=myPassword;SERVER=localhost;'
go
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'myAlias',
@useself = 'TRUE',
@locallogin = NULL
GO
-- List the tables on the linked server
EXEC sp_tables_ex 'myAlias'
GO
sp_tables_ex throws the following error:
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].
Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 13
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
BUT if I use the exact same syntax on a SQL2005 server, it works just fine.
Any ideas?
.
- Prev by Date: MULTIPLE ODBC CONNECTIONS SAME NAME
- Next by Date: Enterprise Manager job setup help
- Previous by thread: MULTIPLE ODBC CONNECTIONS SAME NAME
- Next by thread: Enterprise Manager job setup help
- Index(es):
Relevant Pages
|
Loading
