Opening Sybase databases

This page explains how to connect BaseNow to Sybase database.

1. Click the Open button and the ‘Data Link Properties' window will pop up.

2. Click OK and the new database connection will appear in BaseNow:

3. Right click the connection in the Object Browser and choose Properties. The Connection Properties dialog is opened:

4. You need to enter correct connection string value in the Connection String text box. There are several different options. Please see the examples below. You can use either OLE DB provider for Sybase or ODBC driver.

OLE DB Provider for Sybase Adaptive Server Anywhere (ASA)

Provider=ASAProv;Data source=myASA"

For more information, see:  ASA Programming Interfaces Guide and ASA User's Guide

OLE DB Provider for Sybase Adaptive Server Enterprise (ASE)

Provider=Sybase ASE OLE DB Provider; Data source=myASEServer"

Or

Provider=Sybase.ASEOLEDBProvider;Srvr=myASEServer,5000;Catalog=myDBName;User Id=myUserName;Password=myUserPassword

Where:
- The Sybase ASE OLE DB provider from the Sybase 12.5 client CD 
- 5000 is the port number for Sybase.

Note: The Open Client 12 Sybase OLE DB Provider fails to work without creating  a Data Source .IDS file using the Sybase Data Administrator.  These .IDS files resemble ODBC DSNs.

Note: With Open Client 12.5, the server port number feature finally works, allowing fully qualified network connection strings to be used without defining any .IDS Data Source files.

For more information, see:  Sybase Advance Search

ODBC Driver for Sybase

If using the Sybase System 12 (or 12.5) Enterprise Open Client ODBC Driver

Driver={SYBASE ASE ODBC Driver};Srvr=myServerName;Uid=myUsername;Pwd=myPassword

If using the Sybase System 11 ODBC Driver

Driver={SYBASE SYSTEM 11};Srvr=myServerName;Uid=myUsername;Pwd=myPassword

If using the Intersolv 3.10 Sybase ODBC Driver

Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=myServerName;Uid=myUsername;Pwd=myPassword

For more information, see: Sybase System 10 ODBC Driver Reference Guide

To view Microsoft KB articles related to ODBC Driver for Sybase, click here

ODBC Driver for Sybase SQL Anywhere

ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:\dbpath\;Dbf=c:\sqlany50\mydb.db;Uid=myUsername;Pwd=myPassword;Dsn=""

Note: Including the DSN tag with a null string is absolutely critical or else you get the dreaded -7778 error.

For more information, see:  Sybase SQL Anywhere User Guide

Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.