On my computer i have both mssql 2000 and mysql 5.0 installed and im trying to link to the mysql server through the mssql.
Ive used this:
but when i try to access the linked server i get an error stating that it cant find the data source and that there is no default driver specified. what am i doing wrong here??
Ive 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
Ive used this:
Code:
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 cant find the data source and that there is no default driver specified. what am i doing wrong here??
Ive 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
