Kbase P129838: How to avoid being prompted for login when connecting to Microsoft Office products via ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/25/2008 |
|
Status: Unverified
GOAL:
How to avoid being prompted for login when connecting to Microsoft Office products via ODBC
GOAL:
How to login automatically via Progress / OpenEdge ODBC driver in Microsoft Office products
GOAL:
How to login automatically via ODBC in Microsoft Access
GOAL:
How to login automatically via ODBC in Microsoft Excel
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
Windows
FIX:
Create a File DSN and edit it manually, adding a password parameter (PWD):
[ODBC]
DRIVER=<Driver Name>
UID=<Username>
PWD=<Password>
DB=<Database Name>
PORT=<Port Number>
HOST=<Host Name>
Example:
[ODBC]
DRIVER=DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E
UID=pub
PWD=pub
DB=sports2000
PORT=9999
HOST=localhost
Specify this File DSN when connecting via MS Access, MS Excel etc. and the PWD parameter will be read and a connection to the Progress database established.