loading - Linking MySQL server to MS SQL server -

loading - Linking MySQL server to MS SQL server -

i have requirement access sql server db ms sql,keep updating tables info ms sql database daily.i tried doing using linked servers.

i have used odbc administrator v 5.3 , driver 'my sql odbc 5.3 ansi driver' , have set connection , tested,which worked fine.i have added mysql db linked server next command

exec master.dbo.sp_addlinkedserver @server = n'mysql', @srvproduct=n'mysql', @provider=n'msdasql', @provstr=n'driver={mysql odbc 5.3 ansi driver}; server=10.36.45.10; _ database=tigerdb; user=casklgh; password=hejsan; option=3'

after creating,when expand linked server tree,i not able access tables , views.i getting error

cannot initialize info source object of ole db provider "msdasql" linked server "mysql". ole db provider "msdasql" linked server "mysql" returned message

please suggest can done

thank you

i found reply question. tried doing same doing remote desktop server , done whole process on server , worked fine.:)

loading