Kbase 21227: How To Manually Modify A UserID and Password In The ODBC File DSN
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/7/2008 |
|
Status: Verified
GOAL:
How to manually modify a userID and password in an ODBC File DSN for the Merant ODBC drivers?
GOAL:
How do I avoid needing to provide userid and passwd when using 3rd party applications?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows
FIX:
These instructions work with both the Merant 3.60 driver and the SQL-92 ODBC Driver.
1) Create a File DSN (instead of a System DSN or
User DSN) through the ODBC Data Source Administrator.
2) Once created, test the connection, and then modify the
file just created (by default this file is kept in the directory:
C:\Program Files\Common Files\ODBC\Data Sources). Using a text
editor (such as, Notepad), add (or modify) the following lines:
UID=<userID>
PWD<password>
Example of a "SQL-89" File DSN after the modifications:
[ODBC]
DRIVER=MERANT 3.60 32-BIT Progress
UID=pepe
PWD=p
DB=sports83b
OIDP=TCP
OIDS=prosv02
OIDH=pcjnunez2
DBAM=Via Server
DBPR=TCP
DBS=prosv01
DBH=pcjnunez2
DBOS=Windows
ASC=0
SR=1
GST=0
Example of a "SQL-92" File DSN after the modifications:
[ODBC]
Driver=MERANT 3.60 32-BIT Progress SQL-92 v9.1B
UID=sysprogress
PWD=s
HOST=pchost3
PORT=9999
DB=sports
Once this is complete, do not modify or save the File DSN through the ODBC Data Source Administrator. It will overwrite the file that was modified. If it is saved, the two lines will need to be added again.
Third party ODBC applications, such as Excel, calling the data source connecting to a Progress Database will no longer prompt for a User ID or Password.