SQL Server 2005连接mysql出错
新建了DSN,测试成功
然后添加linkserver,
EXEC sp_addlinkedserver @server = 'TestMysql',
@srvproduct='MySQL',@provider = 'MSDASQL', @datasrc = 'MysqlTest'
EXEC sp_addlinkedsrvlogin @rmtsrvname='TestMysql',@useself='false',@locallogin='sa',@rmtuser='root',@rmtpassword='11'
SELECT * FROM OPENQUERY(TestMysql,'select * from tt.aa' )
查询数据就出错
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "MYSQL" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MYSQL".
EXEC master.dbo.sp_addlinkedserver @server = N'MYSQL', @srvproduct=N'MySQL', @provider=N'MSDASQL', @provstr=N'DRIVER={MySQL ODBC 3.51 Driver} ;SERVER=172.18.191.21;DATABASE=tt; USER=root; PASSWORD=11; OPTION=3'
SELECT * FROM OPENQUERY(MYSQL,'select * from tt.aa' )
这样得到的是同样的错误
请求帮助