Re: Simpler way to connect to Sybase server

This actually depends on which type of sybase server you are trying to connect to. I know of the following 3 types:

Sybase Adaptive Server Enterprise aka ASE (formerly known as Sybase SQL Server)

iAnywhere SQL Anywhere aka ASA (formerly known as Adaptive Server Anywhere and way way back as Watcom SQL)
Sybase IQ server

Most people on this site seem to be familiar ASE. This is the enterprise category server meant to handle really large databases. It has support for hot standby and load balancing, etc. It does need a trained DBA to maintain though. If that's the server you are trying to connect to follow the suggestions from mpeppler.

ASA is the smaller cousin. It is meant for slightly smaller databases. Its focus is to provide good performance out of the box and does not need a dba to maintain. Its great for mobile applications. If you are trying to connect to ASA, then Sybperl will not work. You have two options, get the ASA DBD driver from http://www.ianywhere.com at this page or use DBD::ODBC. I have used both with no problems.

IQ is meant for OLAP like stuff. I believe it uses ASA under the covers.

Comment on Re: Simpler way to connect to Sybase server

Replies are listed 'Best First'.
Re: Re: Simpler way to connect to Sybase server by busunsl (Vicar) on Nov 28, 2001 at 13:27 UTC
You're mostly right ;-) IQ does not use ASA 'under the covers'. It uses ASE or ASA for it's metadata and handles the data by itself. I'd suggest to fetch DBD::ASAny from CPAN to have a common source for all modules and make installation easier.	[reply]