Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How can I add an SQLServer2005 remote server to ASE 12.5.4 ?

3 posts in General Discussion Last posting was on 2009-09-01 19:21:12.0Z
Pedro Santos Posted on 2009-09-01 16:44:34.0Z
Sender: 2fa3.4a9d4535.1804289383@sybase.com
From: Pedro Santos
Newsgroups: sybase.public.ase.general
Subject: How can I add an SQLServer2005 remote server to ASE 12.5.4 ?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a9d4f72.3170.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub4a9d4f72"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Sep 2009 09:44:34 -0700
X-Trace: forums-1-dub 1251823474 10.22.241.41 (1 Sep 2009 09:44:34 -0700)
X-Original-Trace: 1 Sep 2009 09:44:34 -0700, 10.22.241.41
Lines: 91
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28257
Article PK: 77501

Hello all,

For tests purpose I'm trying to add a SQLServer2005 -
Express Edition remote server in ASE12.5.4. Both servers are
in a local virtual machine.

In ASE 12.5 System Administration Guide - Chapter 13 -
Managing Remote Servers: "...List the remote server in the
interfaces file or Directory Service for the local
server...".
Although in dsedit ping it's not succeeding. The following
questions are troubling me:

1. Which port sql server uses? I tried the default 1433 for
what I saw here: "http://support.microsoft.com/kb/287932"
without success. In attachment goes an output of netstat -a
with sql server running, from this output I can't see what's
the sql server port.

2. What should I place in "Server Address" value? Any
specific protocol, network address and/or port?

3.Is there a way to add data in a SQLServer table from ASE
without using Direct Connect?

Thanks in advance,
Pedro Santos
Sybase Consultant

C:\Documents and Settings\Administrator>netstat -a

Active Connections

Proto Local Address Foreign Address State
TCP uaxpvm:epmap 0.0.0.0:0 LISTENING
TCP uaxpvm:microsoft-ds 0.0.0.0:0 LISTENING
TCP uaxpvm:4900 0.0.0.0:0 LISTENING
TCP uaxpvm:1030 0.0.0.0:0 LISTENING
TCP uaxpvm:netbios-ssn 0.0.0.0:0 LISTENING
TCP uaxpvm:1027 169.254.206.160:4900 ESTABLISHED
TCP uaxpvm:1029 169.254.206.160:5000 ESTABLISHED
TCP uaxpvm:1031 169.254.206.160:5000 ESTABLISHED
TCP uaxpvm:1032 169.254.206.160:5000 ESTABLISHED
TCP uaxpvm:1033 169.254.206.160:5000 ESTABLISHED
TCP uaxpvm:1034 169.254.206.160:5000 ESTABLISHED
TCP uaxpvm:1035 169.254.206.160:5000 ESTABLISHED
TCP uaxpvm:1036 169.254.206.160:5000 ESTABLISHED
TCP uaxpvm:1041 169.254.206.160:5000 ESTABLISHED
TCP uaxpvm:4900 169.254.206.160:1027 ESTABLISHED
TCP uaxpvm:5000 0.0.0.0:0 LISTENING
TCP uaxpvm:5000 169.254.206.160:1029 ESTABLISHED
TCP uaxpvm:5000 169.254.206.160:1031 ESTABLISHED
TCP uaxpvm:5000 169.254.206.160:1032 ESTABLISHED
TCP uaxpvm:5000 169.254.206.160:1033 ESTABLISHED
TCP uaxpvm:5000 169.254.206.160:1034 ESTABLISHED
TCP uaxpvm:5000 169.254.206.160:1035 ESTABLISHED
TCP uaxpvm:5000 169.254.206.160:1036 ESTABLISHED
TCP uaxpvm:5000 169.254.206.160:1041 ESTABLISHED
UDP uaxpvm:microsoft-ds *:*
UDP uaxpvm:isakmp *:*
UDP uaxpvm:4500 *:*
UDP uaxpvm:ntp *:*
UDP uaxpvm:1025 *:*
UDP uaxpvm:1900 *:*
UDP uaxpvm:ntp *:*
UDP uaxpvm:netbios-ns *:*
UDP uaxpvm:netbios-dgm *:*
UDP uaxpvm:1900 *:*

C:\Documents and Settings\Administrator>


Jeff Tallman [Sybase] Posted on 2009-09-01 18:29:49.0Z
From: "Jeff Tallman [Sybase]" <jeff.tallman@sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: How can I add an SQLServer2005 remote server to ASE 12.5.4 ?
References: <4a9d4f72.3170.1681692777@sybase.com>
In-Reply-To: <4a9d4f72.3170.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a9d681d$1@forums-1-dub>
Date: 1 Sep 2009 11:29:49 -0700
X-Trace: forums-1-dub 1251829789 10.22.241.152 (1 Sep 2009 11:29:49 -0700)
X-Original-Trace: 1 Sep 2009 11:29:49 -0700, vip152.sybase.com
Lines: 43
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28259
Article PK: 77503

I believe you are going to need the ECDA to make this work. While MSSQL
2000 still supported native TDS protocol and could look like a generic
"sqlserver" to ASE, I think MSSQL 2005 finished breaking any
compatibility here.

...however, you do have a tcp listener at port 5000 - that seems to be
the standard port for most product installs. You could try that....

Jeff Tallman
Enterprise Data Management Products Technical Evangelism
jeff.tallman@sybase.com
http://blogs.sybase.com/database

Pedro Santos wrote:
> Hello all,
>
> For tests purpose I'm trying to add a SQLServer2005 -
> Express Edition remote server in ASE12.5.4. Both servers are
> in a local virtual machine.
>
> In ASE 12.5 System Administration Guide - Chapter 13 -
> Managing Remote Servers: "...List the remote server in the
> interfaces file or Directory Service for the local
> server...".
> Although in dsedit ping it's not succeeding. The following
> questions are troubling me:
>
> 1. Which port sql server uses? I tried the default 1433 for
> what I saw here: "http://support.microsoft.com/kb/287932"
> without success. In attachment goes an output of netstat -a
> with sql server running, from this output I can't see what's
> the sql server port.
>
> 2. What should I place in "Server Address" value? Any
> specific protocol, network address and/or port?
>
> 3.Is there a way to add data in a SQLServer table from ASE
> without using Direct Connect?
>
> Thanks in advance,
> Pedro Santos
> Sybase Consultant
>


Sherlock, Kevin [TeamSybase] Posted on 2009-09-01 19:21:12.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4a9d4f72.3170.1681692777@sybase.com>
Subject: Re: How can I add an SQLServer2005 remote server to ASE 12.5.4 ?
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a9d7428$1@forums-1-dub>
Date: 1 Sep 2009 12:21:12 -0700
X-Trace: forums-1-dub 1251832872 10.22.241.152 (1 Sep 2009 12:21:12 -0700)
X-Original-Trace: 1 Sep 2009 12:21:12 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28260
Article PK: 77504

You aren't going to get any of this to work without ECDA.

<Pedro Santos> wrote in message news:4a9d4f72.3170.1681692777@sybase.com...
> Hello all,
>
> For tests purpose I'm trying to add a SQLServer2005 -
> Express Edition remote server in ASE12.5.4. Both servers are
> in a local virtual machine.
>
> In ASE 12.5 System Administration Guide - Chapter 13 -
> Managing Remote Servers: "...List the remote server in the
> interfaces file or Directory Service for the local
> server...".
> Although in dsedit ping it's not succeeding. The following
> questions are troubling me:
>
> 1. Which port sql server uses? I tried the default 1433 for
> what I saw here: "http://support.microsoft.com/kb/287932"
> without success. In attachment goes an output of netstat -a
> with sql server running, from this output I can't see what's
> the sql server port.
>
> 2. What should I place in "Server Address" value? Any
> specific protocol, network address and/or port?
>
> 3.Is there a way to add data in a SQLServer table from ASE
> without using Direct Connect?
>
> Thanks in advance,
> Pedro Santos
> Sybase Consultant
>