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