DB2 and SQL Server connection issues

Brian Lawrence

Summary

DB2 and SQL Server connection issues

Content

A DVD user is trying to connect all of their current data sources in the Data Visualization product and have had only 2 successes out of 6.  Two of their four DB2 UDB connections fail.  Mainframe DB2 fails.  SQL Server fails.
They are thinking that the driver is not able to interpret Active Directory security groups and Windows security defaults, The two connections that work have userid direct-connected to the database. The other DB2 connections are Active Directory group-based.  The SQL Server databases expect to default to Windows credentials, which are not detected and fail even if the credentials are entered.

The two DB2 UDB connections that work both display tables that are stored on other servers.
  Is there a way to use other drivers with the tool?

Log File Info:

[2017-01-04T16:23:13.727-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 2988] LCMAPIsUtil.GetSDD-> C:\Users\LM26836\AppData\Local\DVDesktop

[2017-01-04T16:23:13.754-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 2988] call NQSExternalVerifyConnection( '<?xml version="1.0" encoding="UTF-8" standalone="no"?><cm:dsConnMetadata xmlns:cm="com.oracle.bi/ConnMetadata/v1"><cm:dsMetadata><cm:cliName>ODBC 3.5</cm:cliName><cm:targetName>DB2 V5</cm:targetName><cm:providerName>db2</cm:providerName></cm:dsMetadata><cm:dsSignon><cm:dsn>DRIVER=Oracle 7.1 DB2 Wire Protocol;IpAddress=COR089D206;PORT=50000;DB=UCMDB;</cm:dsn><cm:host>COR089D206</cm:host><cm:port>50000</cm:port><cm:serviceName>UCMDB</cm:serviceName><cm:userName>lm26836</cm:userName><cm:password>XXXXXX</cm:password><cm:driverClass>oracle.bi.jdbc.AnaJdbcDriver</cm:driverClass></cm:dsSignon><cm:enablePooling>false</cm:enablePooling><cm:dsConnPoolParams><cm:maxConnections>100</cm:maxConnections><cm:timeOut>600</cm:timeOut></cm:dsConnPoolParams></cm:dsConnMetadata>' )

[2017-01-04T16:23:14.73-05:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 2988]  [nQSError: 16001] ODBC error state: S1000 code: 0 message: [Oracle DataDirect][ODBC DB2 Wire Protocol driver]Command Not Supported.. [[

file: server\Query\Execution\DbGateway\Odbc35\..\Odbc\Src\SQXDGOdbcConnection.cpp; line: 1018

**********  Task: 1. Running for (mls): 327 **********

Description: Execute Query

Repository Name: ssi

Catalog: Sample Targets Lite

Tenant:

Tenant ID:

Service Name:

User: weblogic

Session ID: 0x1cca0000

Request ID: 0x1cca0003

ProcedureID: 1000216

Logical SQL:

]]

[2017-01-04T16:23:59.687-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 790] LCMAPIsUtil.GetSDD-> C:\Users\LM26836\AppData\Local\DVDesktop

[2017-01-04T16:23:59.704-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 790] call NQSExternalVerifyConnection( '<?xml version="1.0" encoding="UTF-8" standalone="no"?><cm:dsConnMetadata xmlns:cm="com.oracle.bi/ConnMetadata/v1"><cm:dsMetadata><cm:cliName>ODBC 3.5</cm:cliName><cm:targetName>DB2 V5</cm:targetName><cm:providerName>db2</cm:providerName></cm:dsMetadata><cm:dsSignon><cm:dsn>DRIVER=Oracle 7.1 DB2 Wire Protocol;IpAddress=COR089D206;PORT=50000;DB=UCMDB;</cm:dsn><cm:host>COR089D206</cm:host><cm:port>50000</cm:port><cm:serviceName>UCMDB</cm:serviceName><cm:userName>lm26836</cm:userName><cm:password>XXXXXX</cm:password><cm:driverClass>oracle.bi.jdbc.AnaJdbcDriver</cm:driverClass></cm:dsSignon><cm:enablePooling>false</cm:enablePooling><cm:dsConnPoolParams><cm:maxConnections>100</cm:maxConnections><cm:timeOut>600</cm:timeOut></cm:dsConnPoolParams></cm:dsConnMetadata>' )

[2017-01-04T16:23:59.998-05:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 790]  [nQSError: 16001] ODBC error state: S1000 code: 0 message: [Oracle DataDirect][ODBC DB2 Wire Protocol driver]Command Not Supported.. [[

file: server\Query\Execution\DbGateway\Odbc35\..\Odbc\Src\SQXDGOdbcConnection.cpp; line: 1018

**********  Task: 1. Running for (mls): 281 **********

Description: Execute Query

Repository Name: ssi

Catalog: Sample Targets Lite

Tenant:

Tenant ID:

Service Name:

User: weblogic

Session ID: 0x3310000

Request ID: 0x3310003

ProcedureID: 1000216

Logical SQL:

]]

[2017-01-04T16:24:53.669-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 11ac] LCMAPIsUtil.GetSDD-> C:\Users\LM26836\AppData\Local\DVDesktop

[2017-01-04T16:24:53.681-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 11ac] call NQSExternalVerifyConnection( '<?xml version="1.0" encoding="UTF-8" standalone="no"?><cm:dsConnMetadata xmlns:cm="com.oracle.bi/ConnMetadata/v1"><cm:dsMetadata><cm:cliName>ODBC 3.5</cm:cliName><cm:targetName>DB2 V5</cm:targetName><cm:providerName>db2</cm:providerName></cm:dsMetadata><cm:dsSignon><cm:dsn>DRIVER=Oracle 7.1 DB2 Wire Protocol;IpAddress=COR089D206;PORT=50000;DB=UCMDB;</cm:dsn><cm:host>COR089D206</cm:host><cm:port>50000</cm:port><cm:serviceName>UCMDB</cm:serviceName><cm:userName>lm26836</cm:userName><cm:password>XXXXXX</cm:password><cm:driverClass>oracle.bi.jdbc.AnaJdbcDriver</cm:driverClass></cm:dsSignon><cm:enablePooling>false</cm:enablePooling><cm:dsConnPoolParams><cm:maxConnections>100</cm:maxConnections><cm:timeOut>600</cm:timeOut></cm:dsConnPoolParams></cm:dsConnMetadata>' )

[2017-01-04T16:24:53.955-05:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 11ac]  [nQSError: 16001] ODBC error state: S1000 code: 0 message: [Oracle DataDirect][ODBC DB2 Wire Protocol driver]Command Not Supported.. [[

file: server\Query\Execution\DbGateway\Odbc35\..\Odbc\Src\SQXDGOdbcConnection.cpp; line: 1018

**********  Task: 1. Running for (mls): 265 **********

Description: Execute Query

Repository Name: ssi

Catalog: Sample Targets Lite

Tenant:

Tenant ID:

Service Name:

User: weblogic

Session ID: 0x45b30000

Request ID: 0x45b30003

ProcedureID: 1000216

Logical SQL:

]]

[2017-01-04T16:25:41.190-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 2a34] LCMAPIsUtil.GetSDD-> C:\Users\LM26836\AppData\Local\DVDesktop

[2017-01-04T16:25:41.206-05:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 2a34] call NQSExternalVerifyConnection( '<?xml version="1.0" encoding="UTF-8" standalone="no"?><cm:dsConnMetadata xmlns:cm="com.oracle.bi/ConnMetadata/v1"><cm:dsMetadata><cm:cliName>ODBC 3.5</cm:cliName><cm:targetName>DB2 V5</cm:targetName><cm:providerName>db2</cm:providerName></cm:dsMetadata><cm:dsSignon><cm:dsn>DRIVER=Oracle 7.1 DB2 Wire Protocol;IpAddress=COR089D206;PORT=50000;DB=UCMDB;</cm:dsn><cm:host>COR089D206</cm:host><cm:port>50000</cm:port><cm:serviceName>UCMDB</cm:serviceName><cm:userName>lm26836</cm:userName><cm:password>XXXXXX</cm:password><cm:driverClass>oracle.bi.jdbc.AnaJdbcDriver</cm:driverClass></cm:dsSignon><cm:enablePooling>false</cm:enablePooling><cm:dsConnPoolParams><cm:maxConnections>100</cm:maxConnections><cm:timeOut>600</cm:timeOut></cm:dsConnPoolParams></cm:dsConnMetadata>' )

[2017-01-04T16:25:41.512-05:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 2a34]  [nQSError: 16001] ODBC error state: S1000 code: 0 message: [Oracle DataDirect][ODBC DB2 Wire Protocol driver]Command Not Supported.. [[

file: server\Query\Execution\DbGateway\Odbc35\..\Odbc\Src\SQXDGOdbcConnection.cpp; line: 1018

**********  Task: 1. Running for (mls): 312 **********

Description: Execute Query

Repository Name: ssi

Catalog: Sample Targets Lite

Tenant:

Tenant ID:

Service Name:

User: weblogic

Session ID: 0x37a70000

Request ID: 0x37a70003

ProcedureID: 1000216

Logical SQL:

]]

Adam Bloom-Oracle

Currently there is no way to register your own database driver with DV Desktop.

Currently the connectors for DB2 and SQL Server only support userID/password as a connection method.