[DotNetDevelopment] Data source name not found(its urgent some body plz help me)

[Programmer]

while doing this


sp_addlinkedserver @server = 'Surya',
                   @srvproduct = 'MySQL',
          @provider= 'MSDASQL',
                   @datasrc= 'mysql-evodb-surya',
                 @provstr='DATABASE=evodb;DSN=mysql-evodb-
surya;OPTION=0;PWD=readonly;SERVER=192.168.1.234;UID=evo'

select * from openquery(Surya,'Select *  from shipmentheadertb')


i am getting this error

[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL'
IDBInitialize::Initialize returned 0x80004005:   ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.