Kbase 19298: ODBC Dsrv: Data source name not found and no default driver specified when ODBC DSN created under Us
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
MS SQL DataServer
SYMPTOM(s):
Unable to connect to the MS SQL Server database using DataServer Broker
ERROR:IM002: [Micosoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error occurs when connecting via the Unified Broker (started with Progress Explorer Tool or mssman utility)
Error occurs when connecting via DataServer Broker (started with ProControl)
Error does not occur when _probrkr has been started through proenv shell
Error does not occur when connecting locally to SQL Server without Broker
Within the ODBC Administration, the data source is defined under the 'User DSN'
CAUSE:
When user starts the _probrkr, the broker inherits the user privilege and look at the user DSN to connect to the Microsoft SQL Server Database. Since ProControl and the Unified Broker starts the broker using the system account, the broker inherits the system account's privilege and there by looks at the system DSN.
FIX:
Delete the data source entry created under 'User DSN' and create the ODBC DSN under 'System DSN'.