How to use Sybase ASE OLEDB Provider
This article describes connection string through which Sybase ASE OLEDB provider is connected with database
Introduction
To use Sybase Data Administrator user have to create Data Source .IDS file. These .IDS files resembles ODBC DNSs. Connection string used to connect with Data Source .IDS file is as follows
Provider=sybase ASE OLE DB Provider;Data Source=ase_name;
|
Adaptive Server Enterprise
Adaptive Server Enterprise (ASE) is a high-performance relational database management system for mission-critical, data-intensive environments. It ensures highest operational efficiency and throughput on a broad range of platforms. It releases various versions of ASE.
Connection used to connect Adaptive Server Enterprise (ASE) alternative 1 is given below
Provider=Sybase.ASEOLEDBProvider;Server=aseserver,5000;Catalog=database_name;User Id=user_name;Password=password;
|
Many users find problems with this connection string when connecting to ASE alternative 1. to avoid the problems which are arises with previous connection string a new connection string is introduces which is as follows
Provider=Sybase.ASEOLEDBProvider;Server Name=aseserver,5000;Initial Catalog=database_name;User Id=user_name;Password=password
|
Still some users reported an error with this string which are removed in next versions.
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here