Link server error The provider did not give any information about the error
Hi!
We have a test server (win 2003) in which MSSQL server is installed.In my system (win XP)I installed MYSQL server ,MY sql odbc driver.Now all I want is to create a linked server on MSSQL server so that data on Both server can be in sync.When even a new record in inserted in MYSQL it should be replicated to MSSQL srvr tabl immeditely
I tried to create a linked server but every time I got this error
Error 7399:OLEDB PROVIDER'MSDASQL' reported an error.The provider did not give any information about the error.OLE DB error trace[OLE/DB provider 'MSDASQL' IDBInitilize ::Initialize returned 0x80004005: The provider did not give any information about the error.]
Here is what I have done
sp_addlinkedserver @server = 'localhost', @srvproduct = 'MYSQL', @provider= 'MSDASQL', @datasrc ='localhost',@location ='ipadd of my sqlserver',@provstr ='DriverDriver={MySQL ODBC 3.51 driver};Server=ip add of mysql server;Port=3306;Option=131072;Stmt=;Database=testDB;Uid=root;Pwd=1234asdf' ,@catalog = 'testDB'
Pls suggest what to do.I am trying for past 2 week but nothing came fruitful..sigh!!
sp_addlinkedserver @server = 'localhost', @srvproduct = 'MYSQL', @provider= 'MSDASQL', @datasrc ='localhost',@location ='ipadd of my sqlserver',@provstr ='DriverDriver={MySQL ODBC 3.51 driver};Server=ip add of mysql server;Port=3306;Option=131072;Stmt=;Database=testDB;Uid=root;Pwd=1234asdf' ,@catalog = 'testDB'
Pls suggest what to do.I am trying for past 2 week but nothing came fruitful..sigh!!
[1353 byte] By [AARONSANDY] at [2008-1-28] 