Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Connect Sybase ASE 12.5 to MS SQL Server 2000 ??

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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
While opting for any web-to-print solution, you need to discuss with your team and some of your end users and know their opinions about your decisions. In this article we list down some questions you need to ask yourself.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

721 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