Solved

Connect Sybase ASE 12.5 to MS SQL Server 2000 ??

Posted on 2004-10-14
1
406 Views
Last Modified: 2008-03-10
I'm trying to understand how to create a proxy table from ASE-12_5 to MS Sql Server 2000.
I'm thinking I may need to install a DirectConnect server? If so, is this included on my
installation cd? I'm running on Solaris 2.8 with ASE-12_5. I thought I had seen somewhere
that one of the new features of ASE 12.5 was access to diff. databases.

Thanks in advance
brian
0
Comment
Question by:Bgoss
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 19

Accepted Solution

by:
grant300 earned 125 total points
ID: 12311073
You are correct.  You can only create a proxy table against another Sybase product (ASE, ASA, ASIQ) or via DirectConnect, now Enterprise Connect Data Access.

No DirectConnect is not included on your installation CDs.  It is a separate product that must be purchased.  It is not exactly cheap

Enterprise Connect Data Access, ECDA for short.  The MS-SQL version lists for about $4,000 (on Win-NT).  You may also have to purchase the ECDA Base for $2,000 though you probably escape having to purchase a bunch of network seats because you have a server-to-server application.

Hope that helps.

Bill
0

Featured Post

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains the fundamentals of industrial networking which ultimately is the backbone network which is providing communications for process devices like robots and other not so interesting stuff.
The recent Petya-like ransomware attack served a big blow to hundreds of banks, corporations and government offices The Acronis blog takes a closer look at this damaging worm to see what’s behind it – and offers up tips on how you can safeguard your…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question