Solved

Connect Sybase ASE 12.5 to MS SQL Server 2000 ??

Posted on 2004-10-14
1
391 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
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Read our guide on how to survive being on-call.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

679 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