ODBC Data Direct Error When Trying To Connect To SQL Server Database In OAS 5.9
(Doc ID 3048741.1)
Last updated on SEPTEMBER 24, 2024
Applies to:
Oracle Analytics Server - Version 5.9.0 and laterInformation in this document applies to any platform.
Symptoms
ODBC data direct error when trying to connect to SQL server database in OAS 5.9
The following error was observed when trying to connect to SQL server database in OAS 5.9 thru OBIEE RPD.
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43093. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. (HY000)
[nQSError: 16001] ODBC error state: 21 code: 0 message: [Oracle DataDirect][ODBC 20101 driver]1252. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL <connection pool name> SELECT GETDATE();', 'PRECISION_SCALE')}
Changes
ODBC data direct error when trying to connect to SQL server database in OAS 5.9
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |