How to use Sybase ASE OLEDB Provider

This article describes connection string through which Sybase ASE OLEDB provider is connected with database
  • 5709

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

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.