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

asked 13 Jun '13, 03:44

mobybrown's gravatar image

mobybrown
1111
accept rate: 0%

edited 14 Jun '13, 04:01

Volker%20Barth's gravatar image

Volker Barth
31.5k318461676

The question has been closed for the following reason "Question is off-topic or not relevant" by Mark Culp 13 Jun '13, 08:29


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.

permanent link

answered 13 Jun '13, 04:34

AlexeyK77's gravatar image

AlexeyK77
70761224
accept rate: 8%

edited 14 Jun '13, 04:02

Volker%20Barth's gravatar image

Volker Barth
31.5k318461676

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×51
×48
×27

question asked: 13 Jun '13, 03:44

question was seen: 1,538 times

last updated: 14 Jun '13, 04:02