How to connect to Progress ODBC Driver

This article explains how Progress ODBC driver is connects with database
  • 4434

Introduction :

The Progress SQL-92 ODBC driver allows tools and applications that support the ODBC call library to use the Progress database as a data source. With it, applications based on tools such as Crystal Reports, PowerBuilder, and Visual Basic can include a Progress database as a data source. The Multi-Tier ODBC Drivers for Progress consists of the generic ODBC client driver and the Progress Database agent on the server utilizing the built in database independent network layer for communication between the client and server.

You can specify either long or short names in the connection string. The connection string has the form :

Syntax :

DSN=dsn_name;HOST=myServerAddress;DB=database_name;UID=user_name;PWD=password;PORT=port_num;

DataSourceName=dsn_name;HostName=server_add;Database=database_name;LogonID=user_name; Password=password;PortNumber=port_num;

Connecting to a Data Source Using a Connection String :

If user's application requires a connection string to connect to a data source, user must specify the data source name that tells the driver which section in the system information to use for the default connection information. Connection used to connect to Progress ODBC Driver is

DSN=dsn_name;HOST=server_add;DB=database_name;UID=user_name;PWD=password;PORT=port_num

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

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.