Can I create a remote server to access a MS SQL Server database?

[Former Member]

Hi guys (and girls),

I am a bit of a newby to Sybase so forgive me if I come across as - a newby :) I have a sybase database running on ASE 15.5 which is itself running on Windows Server 2003. I would like to know if I can (from Sybase) query a view on a remote SQL Server from a database within this Sybase installation? I have created an entry within the interfacesdriver file (which I can ping), like so:

[HQCVSQLDEV01] master=TCP,HQCVSQLDEV01,1433,ether query=TCP,HQCVSQLDEV01,1433,etherstrong text

I have created my remote server within Sybase using sp_addserver. The details within sysservers are like so:

srvid,srvstatus,srvname,srvnetname,srvclass,srvsecmech,srvcost,srvstatus2 9,9,'FHQOMSDEV01','FHQOMSDEV01',7,,1000,2strong text

when I try and run the query below on my remote server I get the error:

exec sp_remotesql HQCVSQLDEV01, "select @@version"strong text

Could not execute statement. Internal Ct-Lib/Cs-Lib error 84083974: 'ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect'. Sybase error code=11216 Severity Level=16, State=13, Transaction State=1 Line 0strong text

Any help on this matter would be most appreciated.

Cheers

Glenn

[Former Member]

This forum is dedicated to Sybase SQL Anywhere (SA or ASA for former releases) server. Sybase ASE is another Sybase product, absolutely different from SA server. Try to ask your question is special ASE forums.