Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC Driver Error with MySQL data source

913106Jan 25 2012
Hi,
I am using OBI EE 11g with a MySQL data source. It worked fine for a couple of weeks, I was able to create nice reports and dashboards and then it stopped working.
When I try to open a report, I now get the following error:

Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 16001] ODBC error state: HY000 code: 0 message: [DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased. You can order a license by calling DataDirect Technologies at 800-876-3101 in North America and +44 (0) 1753-218 930 elsewhere. Thank you for your cooperation.. [nQSError: 16015] SQL statement execution failed. (HY000)
SQL Issued: SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7, s_8, s_9, s_10, s_11 FROM ..........

The funny thing is that I do not use DataDirect driver. I installed unixODBC driver from [http://www.unixodbc.org|http://www.unixodbc.org] and MySQL driver from [MySQL website|http://dev.mysql.com/downloads/connector/odbc/3.51.html]

My odbc.ini looks like this: (I added the [ADV DEV at ADP] part)

[ODBC]
QEWSD=2455910
Trace = 0
TraceFile = /data/OracleBI/MDW/instances/instance1/diagnostics/logs/OracleBIApplication/coreapplication/odbctrace.out
TraceDll = /data/OracleBI/MDW/Oracle_BI1/common/ODBC/Merant/5.3/lib/odbctrac.so
InstallDir = /data/OracleBI/MDW/Oracle_BI1/common/ODBC/Merant/5.3
UseCursorLib = 0
IANAAppCodePage = 4

[ODBC Data Sources]
AnalyticsWeb = Oracle BI Server
ADV DEV at ADP = Oracle BI Server

[AnalyticsWeb]
Driver = /data/OracleBI/MDW/Oracle_BI1/bifoundation/server/bin/libnqsodbc64.so
Description = Oracle BI Server
Repository =
Catalog =
UID =
PWD =
ForwardOnlyCursor =
SelectPhysical =
IsClusteredDSN = Yes
Regional = Yes
PrimaryCCSPort = 9706
SSL = No
PrimaryCCS = ncegcobi13.nce.amadeus.net

[ADV DEV at ADP]
Driver = /data/OracleBI/odbc/lib/libmyodbc3_r.so
Description = ADV DEV at ADP
Driver = MySQL
SERVER = xxx.xx.xx.xxx
USER = xxxxxxx
PASSWORD = xxxxxx
PORT = xxxxx
DATABASE = xxxxxxx


Note that the [AnalyticsWeb] is something that was already there. If I remove it, I can no longer log to the Analytics web page. I guess that OBI uses DataDirect driver somewhere but I cannot find where exactly.

Has anybody encountered such an error before? Any help/advise will be welcome.
It looks like a license problem expiring after some time. But why should I be forced to use DataDirect drivers? Maybe there is a way not to use them and use mysql drivers instead.
I saw licence files in my installation of Oracle BI here:
./Oracle_BI1/common/ODBC/Merant/6.0SP1/DDAR.LIC
./Oracle_BI1/common/ODBC/Merant/6.0/DDAR.LIC
./Oracle_BI1/common/ODBC/Merant/5.3/DDAR.LIC
./Oracle_BI1/bifoundation/odbc/lib/DDSE.LIC

Thanks & Regards,
Yan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details