Sybase Adaptive Server Enterprise Connection strings

Connection strings Examples for Sybase Adaptive Server Enterprise

ASE ADO.NET Data Provider

This is a .NET Class Library from Sybase. The namespace for this library is Sybase.Data.AseClient.AseConnection.

You can read more about ADO.NET Development from Sybase

Standard Security:

Data Source='yourASEserver';Port=5000;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

This is a wrapping class from Sybase.

Using the sql.ini file:

DSURL='file://c:\sybase\ini\sql.ini?SQL_MIDOFF_OPC1';Database=yourDataBase; UID=yourUsername;PWD=yourPassword;APP=yourAppName;

Use an IP if you cannot connect through your server alias name.

Adaptive Server Anywhere OLE DB Provider

This is an OLE DB Provider from Sybase. The usage for this provider is Provider=ASAProv.

Standard Security:

Provider=ASAProv;Data source=yourASA;

TCP/IP:

Provider=ASAProv.90;Eng=server.database_name;Uid=yourUsername;Pwd=yourPassword; Links=tcpip(Host=servername);

Using "Links=tcpip(Host=servername)" will enable you to connect to the server on the other side of the router.

.NET Framework Data Provider for OLE DB

This is a .NET class library from Microsoft. The namespace for this library is System.Data.OleDb.OleDbConnection.

Standard Security:

Provider=ASAProv;Data source=yourASA;

You can view more OLE DB connection strings for other data provider from other pages.

Sybase ASE OLE DB Provider

This is an OLE DB driver from Sybase. The usage for this driver is Provider=ASEOLEDB

Data Source .IDS file:

Provider=Sybase ASE OLE DB Provider;Data source=yourASE;

You can the .IDS file from Sybase data administrator console and this will in term generates the dns datasource.

Adaptive Server Enterprise (ASE)

Provider=Sybase.ASEOLEDBProvider;Srvr=yourASEserver,5000;Catalog=yourDataBase;User Id=yourUsername;Password=yourPassword;

OR

Provider=Sybase.ASEOLEDBProvider;Server Name=yourASEserver,5000;Initial Catalog=yourDataBase;User Id=yourUsername;Password=yourPassword;

Adaptive Server Enterprise (ASE) 12.5:

Provider=Sybase.ASEOLEDBProvider.2;Server Name=yourASEserver;Server Port Address=5000;Initial Catalog=yourDataBase;User ID=yourUsername;Password=yourPassword;

Adaptive Server Enterprise (ASE) 15.0:

Provider=ASEOLEDB;Data Source=yourASEserver:5000;Catalog=yourDataBase;User Id=yourUsername;Password=yourPassword;

OR

Provider=ASEOLEDB;Data Source=yourASEserver:5000;Initial Catalog=yourDataBase;User Id=yourUsername;Password=yourPassword;

Intersolv 3.60

This is an ODBC driver from DataDirect Technologies. The usage for this driver is Driver={INTERSOLV 3.60 32-BIT Sybase}.

Standard Security:

Driver={INTERSOLV 3.60 32-BIT Sybase};Srvr=yourServerAddress;Database=yourDataBase; Uid=yourUsername;Pwd=yourPassword;

Intersolv 3.10

This is an ODBC driver from DataDirect Technologies. The usage for this driver is Driver={INTERSOLV 3.10 32-BIT Sybase}.

Standard Security:

Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=yourServerAddress;Uid=yourUsername;Pwd=yourPassword;

Sybase SQL Anywhere (former Watcom SQL) ODBC driver

This is an ODBC driver from Sybase. The usage for this driver is ODBC;Driver=Sybase SQL Anywhere 5.0.

Standard Security:

ODBC;Driver=Sybase SQL Anywhere 5.0;DefaultDir=c:\data\dbfolder\;Dbf=c:\data\yourdatabase.db; Uid=yourUsername;Pwd=yourPassword;Dsn="";

Note: use languange specific escape character for the quote character for dsn.

Adaptive Server Enterprise ODBC driver

This is an ODBC driver from Sybase. The usage for this driver is Driver={Adaptive Server Enterprise}.

Adaptive Server Enterprise 15.0:

Driver=={Adaptive Server Enterprise};app=yourAppName;server=yourServerAddress;port=yourPortnumber; db=yourDataBase;uid=yourUsername;pwd=yourPassword;

Standard Sybase System 12 Enterprise Open Client:

Driver={SYBASE ASE ODBC Driver};Srvr=yourServerAddress;Uid=yourUsername;Pwd=yourPassword;

Standard Sybase System 12.5 Enterprise Open Client:

Driver={SYBASE ASE ODBC Driver};NA=Hostname,Portnumber;Uid=yourUsername;Pwd=yourPassword;

TDS based ODBC driver (from Sybase OCS 12.5):

Driver={Sybase ASE ODBC Driver};NetworkAddress=yourServerAddress,5000;Db=yourDataBase; Uid=yourUsername;Pwd=yourPassword;

Standard Sybase System 11:

Driver={SYBASE SYSTEM 11};Srvr=yourServerAddress;Uid=yourUsername;Pwd=yourPassword;Database=yourDataBase;