I have two database ,one is named phs in sqlserver,other is named inmsdb in sybase database server.I have some query application must use the tables in both database server.So I create a ODBC DSN named 'inms' with WINDOWS2000 ODBC DATA SOURCE TOOL,Then i execute follow sentence to create a linked server in sqlserver database.
SQL SENTENCE :
sp_addlinkedserver @server=inms,@provider ='MSDASQL',@datasrc='inms'
,@srvproduct = 'Microsoft OLE DB Provider for ODBC'
then i execute follow sentence in sqlserver query anlalyer to query a table in sybase database inmsdb:
select * from inms.inmsdb.dbo.alm3005_psc
but i receive the error information as follow:
SERVER: MSG 7399CLEVEL 16CSTATE 1CLINE 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: SYSTEM ERROR 126 (Sybase System 11)CCan't Load appointed Driver ]
now my problem is how can i link the sybase6.5 database with sqlserver2000 linked server and what' wrong in the sql sentence that i give above.