MSSQL and MYSQL linked servers

[Puiu]

On my computer i have both mssql 2000 and mysql 5.0 installed and i'm trying to link to the mysql server through the mssql.

 

I've used this:

 

sp_addlinkedserver

@server='MYSQL2',
@srvproduct='Test',
@provider='MSDASQL',
@datasrc='',
@location='',
@provstr='Driver={MySql ODBC 3.51 driver};Server=localhost;port=3306;Option=131072;
Database=MobilePhones;uid=root;pwd=mypwd',
@catalog=''

 

but when i try to access the linked server i get an error stating that it can't find the data source and that there is no default driver specified. what am i doing wrong here??

I've tried linking to an access database and it worked...

 

And one more thing: Option=131072 what does it mean and where can i find the others Options and what they mean ?

Thanks

[HJB417]

I believe server linking works only with oledb.

[gaiusgracchus]

The options I found here:

 

http://www.codeproject.com/KB/database/connectionstrings.aspx#MySQL

 

The one you are asking about has this:

 

"131072 - Add some extra safety checks (should not be needed but...)."