oracle bi 12c cannot query data from mssql PDW

Question

hi experts,

i have some issue when connecting BI 12c to MSSQL PDW.

I'm choose technology mssql 2012 and ODBC 3.5 on connection pool.

I'm able to importing metadata  (table, view etc)

but it failed when i tried to view data. the error is 'NQSError:10058 General error has occurred.

I'm using oracle Linux OS.

i already tried this kind of setting to connect to another DB (MS SQL 2012), and it works.

does anybody here know the solutions?

ps: i try to use windows server and it works (using SQL Server Native driver, not Data Direct)

thanks

RS

rmoff · Answer

[SQL Server]Setting QuotedIdentifier to 'OFF' is not supported

That looks like the issue. I'm not so familiar with SQL Server but this makes it look like PDW won't accept it being OFF.

https://msdn.microsoft.com/en-GB/library/ms174393.aspx?f=255&MSPPError=-2147217396

radityo · Answer

hi,

i found this in my admin tool log

[2016-08-24T16:36:58.644+07:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: service1] [tid: 3308]  [nQSError: 43113] Message returned from OBIS. [[

file: server\NQSODBC\NQSODBC35\Src\NQSOdbcHandleManager.cpp; line: 515

[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.

[nQSError: 16001] ODBC error state: 01000 code: 5703 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Changed language setting to us_english..

[nQSError: 16001] ODBC error state: 01000 code: 5701 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Changed database context to 'dm_sldk'..

[nQSError: 16001] ODBC error state: S1000 code: 104409 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Setting QuotedIdentifier to 'OFF' is not supported..

]]

nothing in obis1-query.log.

but in obis1-diagnostic.log i saw this message :

[2016-08-24T16:59:54.359+07:00] [OBIS] [ERROR:1] [] [] [ecid: 005EgtNmdeJFw00Fzzx0g0000EBr000Mw4,0:1] [sik: ssi] [tid: bbbfb700]  [nQSError: 16001] ODBC error state: S1000 code: 104409 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Setting QuotedIdentifier to 'OFF' is not supported.. [[

file: server/Query/Execution/DbGateway/Odbc35/../Odbc/Src/SQXDGOdbcConnection.cpp; line: 983

Properties: description=ExecutePhysical Exchange; producerID=0xed8088c0; requestID=0xb4ea0002; sessionID=0xb4ea0000; userName=weblogic;

[nQSError: 16001] ODBC error state: 01000 code: 5701 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Changed database context to 'dm_sldk'..

[nQSError: 16001] ODBC error state: 01000 code: 5703 message: [DataDirect][ODBC SQL Server Wire Protocol driver][SQL Server]Changed language setting to us_english..

many thanks for your help.

regards,

tyo

rmoff · Answer

Did you check the log file?

And just because one ODBC connection is right, it doesn't necessarily follow that the other would be.