Feedback
Did this article resolve your question/issue?

   

Article

Oracle ODBC connection fails after upgrade

Information

 
TitleOracle ODBC connection fails after upgrade
URL NameOracle-ODBC-connection-fails-after-upgrade
Article Number000116981
EnvironmentProduct: Connect for ODBC Oracle Wire Protocol driver
Version: 07.14.0145 (B0145, U0104)
OS: Redhat Linux 7.4
Database: Oracle 12.1.0.2.0
Application: N/A
Question/Problem Description
Using the Oracle ODBC connection from version 7.1 on Linux, all connections fail. This issue did not occur with the older version 6 driver, on Solaris. This issue occurs after upgrading to the 7.1 driver on Linux.
The user is however able to connect using the ODBC driver with other reports.
Steps to Reproduce
Clarifying Information
ODBC Trace logs show 
ENTER SQLDriverConnect 

HDBC                0xd7fa5c8
HWND                   (nil)
UCHAR *             0xf5ae8d3c [      -3] "******"
SWORD                       -3 
UCHAR *             0xf5ae8d3c 
SWORD                        6 
SWORD *             0xffa43bc2
UWORD                        0 <SQL_DRIVER_NOPROMPT>

EXIT  SQLDriverConnect  with return code -1 (SQL_ERROR)
HDBC                0xd7fa5c8
HWND                   (nil)
UCHAR *             0xf5ae8d3c [      -3] "******"
SWORD                       -3 
UCHAR *             0xf5ae8d3c 
SWORD                        6 
SWORD *             0xffa43bc2
UWORD                        0 <SQL_DRIVER_NOPROMPT>

ENTER SQLErrorW 
HENV                0xae484f0
HDBC                0xd7fa5c8
HSTMT                  (nil)
WCHAR *             0xffa436be (NYI) 
SDWORD *            0xffa436c4
WCHAR *             0xffa4343f 
SWORD                      511 
SWORD *             0xffa436ca

EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
HENV                0xae484f0
HDBC                0xd7fa5c8
HSTMT                  (nil)
WCHAR *             0xffa436be [ -3] "IM002"
SDWORD *            0xffa436c4 (0)
WCHAR *             0xffa4343f [      81] "[DataDirect][ODBC lib] Data source name not found and no default driver specified"
SWORD                      511 
SWORD *             0xffa436ca (81)

.....

ENTER SQLSetConnectAttr 
SQLHDBC             0xdc9cd88
SQLINTEGER                1061 
SQLPOINTER          [Unknown attribute 1061]
SQLINTEGER                   0 

EXIT  SQLSetConnectAttr  with return code 0 (SQL_SUCCESS)

SQLHDBC             0xdc9cd88
SQLINTEGER                1061 
SQLPOINTER          [Unknown attribute 1061]
SQLINTEGER                   0 
Error Message"[DataDirect][ODBC lib] Data source name not found and no default driver specified".
Defect Number
Enhancement Number
Cause
The application is not able to locate the ODBC data source specified in the connection string. 
Resolution
The SQLSetConnectAttr(1061) is setting the application's WCHAR type. The API call returns with SQL_SUCCESS and is not indicative of a Unicode issue.
SQLDriverConnect API call is returning an error. Refer to KB article DataDirect "Data source name not found and no default driver specified" error on connecting using ODBC driver and ODBC applications to resolve the error.
Workaround
Notes
Last Modified Date11/20/2020 7:08 AM
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.