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 |
|
Asteroid
Starting Member
13 Posts |
 Posted - 2005-03-10 : 09:26:48
|
| Hi to all,I am trying to make a Linked server of Mysql running on the same machine having MS sql server.I am using the following script:sp_addlinkedserver @server ='192.168.1.11' , @srvproduct = 'MSDASQL' , @provider ='MSDASQL' , @datasrc = 'demomatch' , @location ='192.168.1.11' , @provstr = 'Driver={MySQL ODBC 3.51 Driver}' ,@catalog = 'demomatch'goI can c the the new linked server made in the linked server list but when I click on the tables, I receive error:error 7399: ole db provider 'MSDASQL' reported an error. Data source name not found and no default driver specifiedAny help? Regards |
|
|
Asteroid
Starting Member
13 Posts |
Posted - 2005-03-11 : 06:15:31
|
| Well no post since last 24 hours, I must request for any idea or any similiar solution related to the above topic, I guess and appreciate any idea with any one might help me.So plz, can you guys place your ideas about the above problem.Regards. |
 |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-03-14 : 21:03:20
|
| Assuming that you have a System DSN named 'demomatch' that is able to make a valid connection to MySQL, then try this:sp_addlinkedserver @server ='192.168.1.11' , @provider ='MSDASQL' , @datasrc = 'demomatch' |
|
|
|
|
|
|
|
|
problem facing in making Linked Server