Kbase P97292: How to setup the connection string for a DSN-less connection to a Progress database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/04/2011 |
|
Status: Verified
GOAL:
How to setup the connection string for a DSN-less connection to a Progress database?
GOAL:
Is it possible to create a DSN-less connection to a Progress database from an ASP page?
GOAL:
How to connect to a database using just a driver instead of an ODBC DSN?
GOAL:
What is the connection string for a DSN-less connection?
GOAL:
What is the syntax of an ODBC Connect String?
GOAL:
How to configure the Default Isolation level string when connecting to an ODBC Driver without using an ODBC DSN?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
FIX:
It is possible to create a connection string to a Progress database to avoid using an ODBC DSN (Data Source Name). A DSN-less connection allows a user to connect to a database without an ODBC DSN being created on the server, thereby granting greater flexibility. DSN-less connections can be used from a variety of source such as an ASP page or the Crystal Reports Designer and ActiveX runtime.
DSN-less Connection String:
DRIVER=<ODBC Driver Name>;HOST=<Hostname>;PORT=<Port>;DB=<Database Name>;UID=<Username>;PWD=<Password>;DIL=<DEFAULT ISOLATION LEVEL>
ODBC Driver Name
The name of the ODBC driver as it appears in Drivers tab of the Microsoft ODBC Data Source Administrator or in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
Hostname
The name (address) of the database server machine; the equivalent of -H.
Port
The port number of the host; the equivalent of -S.
Username
Name of the user establishing the connection
Password
Password of the user establishing the connection
Default Isolation Level
Specifies the Default Isolation Level for concurrent transactions. This parameter is case-sensitive and the value needs to be in upper-case. Possible values:
READ COMMITTED
READ UNCOMMITTED
REPEATABLE READ
SERIALIZABLE
Samples:
Example of connection string for a specific provider:
myDSN="PROVIDER=MSDASQL:DRIVER={MERANT 3.60 32-BIT Progress SQL92 v9.1D};HOST=localhost;PORT=9999;DB=Sports2000;UID=sysprogress;PWD=sysprogress;DIL=READ UNCOMMITTED"
Examples of connection string for a specific ODBC driver:
DRIVER={DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E};HOST=localhost;PORT=9999;DB=Sports2000;UID=sysprogress;PWD=sysprogress;DIL=READ UNCOMMITTED
DRIVER={Progress OpenEdge 10.1B driver};HOST=localhost;PORT=9999;DB=Sports2000;UID=myUser;PWD=myPassword;DIL=READ UNCOMMITTED