Kbase P65682: How to set up a FILE DSN for SQL92/ODBC connections
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/30/2009 |
|
Status: Verified
GOAL:
How to set up a FILE DSN for read uncommitted connections.
GOAL:
What is the correct parameter syntax for read uncommitted in FILE DSN?
GOAL:
How to create a FILE DSN for SQL92 connections
GOAL:
How to set up a FILE DSN for ODBC connections
FACT(s) (Environment):
Windows 32 Intel
Progress 9.x
OpenEdge 10.x
FIX:
A File DSN is a text file which may be stored anywhere.
The default path for storing is C:\Program Files\Common Files\ODBC\Data Source.
This is an example of a simple FILE DSN.
The DSN connects to a sports2000 database (DB), started on port 6666 (PORT), running locally on the same machine (HOST). The user is sysprogress (UID) and the password is sysprogress (PWD).
file.dsn
[ODBC]
Driver=MERANT 3.60 32-BIT Progress SQL-92 v9.1D
UID=sysprogress
PWD=sysprogress
HOST=localhost
PORT=6666
DB=sports2000
DIL=READ UNCOMMITTED