Feedback
Did this article resolve your question/issue?

   

Article

Cannot connect to database via ODBC

« Go Back

Information

 
TitleCannot connect to database via ODBC
URL NameP165026
Article Number000142816
EnvironmentProduct: OpenEdge
Version: 10.0x, 10.1x
OS: Windows Server 2008 R2
Other: IIS 7.0 64-bit
Question/Problem Description
Cannot connect to database via ODBC.

When application is published, it cannot connect to database.

Errors reported that the ODBC data source name cannot be found.

The application is unable to load the ODBC driver.

Steps to Reproduce
Clarifying Information
Application is built in a .NET language.

Application running from Visual Studio on same machine works.
 
Using 32 bit ODBC driver. 

Test Connection succeeds from ODBC Administrator (32-bit).
 
ODBC connection is DSN-less.
 
Error MessageERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver

Specified driver could not be loaded.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
Defect/Enhancement Number
Cause
IIS 7.0 on Windows 2008 64-bit attempting to load 64-bit ODBC drivers when .NET programs try to accessing databases with ODBC.
Resolution

Configure IIS 7.0 to use 32-bit drivers, Application Pools parameter has to be changed to support 32-bit applications.

Steps to configure IIS 7.0:

- Open Internet Information Services from  Control Panel->Administrative Tools
- Find Server to modify and click on Application Pools.
- Click on DefaultAppPool then on the right-hand side will be a link to "Advanced Settings".
- Click on that link and another window with Advanced Settings will be opened.
- Find in (General) where it says Enable 32-bit Applications
- Change it to TRUE and click on OK
- In the same menu on the right-hand side where it says Application Pools Actions find Stop
- Click on STOP and then START when it is enabled.
- Try application again.

Workaround
Notes
64-bit ODBC drivers for Windows are available in OpenEdge 10.2A and later.
Last Modified Date9/13/2015 4:22 AM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.