How to use Adaptive Server Anywhere OLEDB Provider

This article explains how ASA OLEDB provider is used to connect with the database
  • 1614

Introduction to Adaptive Server Anywhere :

Adaptive Server Anywhere (ASA) can communicate with other Adaptive Servers, Open Server applications, and client software on the network. Clients can talk to one or more servers, and servers can communicate with other servers via remote procedure calls. In order for products to interact with one another, each needs to know where the others reside on the network. This network service information is stored in the interfaces file.

Syntax :

Provider=ASAProv;Data Source=asa_name;

Connection string which can be used to connect to a server located on the other side of the router

Provider=ASAProv.90;Eng=server.database_name;uid=user_name;Password=password;Links=tcpip(Host=server_name);

Note : Links=tcpip(Host=server_name) is used to avoid error "Server could not be found" which can be arise at the time of connection.

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2013 dotNetheaven. All rights reserved.