qzlmq
asked on
how to connect sybase database with sqlserver linked server?
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'
sp_addlinkedsrvlogin inms,'false','sa','inms','
then i execute follow sentence in sqlserver query anlalyer to query a table in sybase database inmsdb:
select * from inms.inmsdb.dbo.alm3005_ps
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.
Thank you!
SQL SENTENCE :
sp_addlinkedserver @server=inms,@provider ='MSDASQL',@datasrc='inms'
,@srvproduct = 'Microsoft OLE DB Provider for ODBC'
sp_addlinkedsrvlogin inms,'false','sa','inms','
then i execute follow sentence in sqlserver query anlalyer to query a table in sybase database inmsdb:
select * from inms.inmsdb.dbo.alm3005_ps
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.
Thank you!
ASKER
when i use sqlserver7.0 instead of the sqlserver2000,i found i can link the sybase database successful.but my database server is sqlserver2000.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://search.microsoft.com/gomsuri.asp?n=1&c=rp_Results&siteid=us&target=http://support.microsoft.com/support/kb/articles/Q137/6/37.asp
There are some third party drivers out there for this purpose. Try this link:
http://www.openlink.co.uk/
From the link above, download the single tier, Universal Data Access Drivers for Windows.