Feedback
Did this article resolve your question/issue?

   

Article

Error "The DataDirect ODBC driver you are attempting to access has been provided to you by Company_ABC" when executing a SQL statement with the Connect for ODBC drivers

« Go Back

Information

 
TitleError "The DataDirect ODBC driver you are attempting to access has been provided to you by Company_ABC" when executing a SQL statement with the Connect for ODBC drivers
URL Name2970
Article Number000121425
EnvironmentProduct: Connect for ODBC drivers
Versions: All supported versions
OS: All supported platforms
Databases: All supported databases
Application: All ODBC applications
Question/Problem Description
When attempting to execute a SQL statement with any Connect for ODBC driver, the below error is returned
Steps to Reproduce
Clarifying Information
Error Message[xxxx][ODBC drivername]The DataDirect driver you are attempting to access has been provided to you by Company for exclusive use with Product. You are not licensed to use this driver with any application other than Product. If you would like to purchase a driver for some other use, please call 800-876-3101 or visit DataDirect at www.datadirect.com
Defect/Enhancement Number
Cause
Resolution
The reason for the error is the driver is not properly licensed. Typically, this errors occur when using a copy of the driver that has been locked for OEM use with a particular application.

Example:
 
  • XYZ Corp has licensed and shipped a copy of the Connect for ODBC Oracle WP driver
  • In that process, the driver has been renamed from its original name, ivora27.dll, to XYZ Corp's company-specific name, xyora27.dll
  • A data source using xyora27.dll driver is set up and an attempt to connect to that data source from something other than XYZ Corp's application
  • The application throws the error "The DataDirect ODBC driver you are attempting to access has been provided to you by Company_ABC..."
This error message reflects that xyora27.dll is locked for use by XYZ Corp's application only. It is not an "open" license for use with any application. No other application is able to use that driver except the application for which it is locked. To connect to that ODBC driver with any other application, obtain a valid, open license driver by contacting DataDirect Technologies Sales team.



If the user already has an open driver installed, either licensed or evaluation, but are still seeing this error, try the following:
On UNIX: Verify that your library path is set correctly to your open driver installation.

On Windows:
  • In the ODBC Administrator, verify that the data source is using the DataDirect Technologies driver, not a driver with any other company name
  • In the ODBC Administrator, verify on the Drivers tab that the file in use begins with iv(32-bit) or dd(64-bit_ and is located in the directory to which the DataDirect Technologies Connect for ODBC open (licensed or evaluation) driver is installed.
  • In the Windows registry, check the location of the files listed for the Setup and Driver keys under the driver name at HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI. Those keys should point to iv*(32-bit) or dd*(64-bit) files in the directory in which the DataDirect Technologies Connect for ODBC open (licensed or evaluation) driver is installed.
OEM vendors should unlock the ODBC drivers as per the instructions in the OEM ODBC Distribution Guide.
Workaround
Notes
Last Modified Date9/2/2018 1:14 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.