Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Connect Sybase ASE 12.5 to MS SQL Server 2000 ??

Posted on 2004-10-14
1
Medium Priority
?
421 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 500 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

Take a look at these 6 Outlook Email management tools which can augment the working and performance of Microsoft Outlook to give you a more rewarding emailing experience.
Your business may be under attack from a silent enemy that is hard to detect. It works stealthily in the shadows to access and exploit your critical business information, sensitive confidential data and intellectual property, for commercial gain. T…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

916 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