Kbase P99702: Is it possible to connect via ODBC without using a DSN in ADO.NET?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2008 |
|
Status: Verified
GOAL:
Is it possible to connect via ODBC without using a DSN in ADO.NET?
GOAL:
How to configure a DSN-less connection for use with ADO.NET
FACT(s) (Environment):
Windows
Progress 9.x
OpenEdge 10.x
FIX:
You can connect from ADO.NET to a Progress database using ODBC without defining a DSN in the ODBC Administrator utility. Your connection string must specify all of the connection parameters normally held in the ODBC DSN (i.e. ODBC driver name, database name, host name, port number). For example:
Driver=DataDirect 4.20 32-BIT OpenEdge SQL v10.0B;HOST=localhost;PORT=9999;DB=sports2000;UID=pub;PWD=pub