Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked Server to DB2 V10.1 (LUW) Expand / Collapse
Author
Message
Posted Monday, July 23, 2012 7:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, September 01, 2012 2:23 PM
Points: 1, Visits: 26
I am trying to create linked server from SQL Server (SQL2012 on Windows 2012 x64) to DB2 (V10.1 Red Hat Linux x64). The connection test works fine, but I wan't able to run "Package" nor "Sample Query" from Data Access Tool.

Data Access Tool:
- output for connect
Successfully connected to data source 'New Data Source'.
Server class: DB2/LINUX
Server version: 10.01.0000

- output for package
Connected to data source 'New Data Source'.
The package creation process has failed on resource 'New Data Source':
Error in BIND or PRECOMPILE option "KEEPDYN?0xF1" with value "". SQLSTATE: 56095, SQLCODE: -30104

- output for sample query
Could not connect to data source 'New Data Source':
One or more errors occurred during processing of command.
Error in BIND or PRECOMPILE option "KEEPDYN?0xF1" with value "". SQLSTATE: 56095, SQLCODE: -30104

- Connection String
Provider=DB2OLEDB;User ID=db2inst1;Password=XXX;Initial Catalog=mydb1;Network Transport Library=TCPIP;Host CCSID=37;PC Code Page=1252;Network Address=10.200.47.178;Network Port=50000;Package Collection=db2inst1;Process Binary as Character=False;Units of Work=RUW;DBMS Platform=DB2/6000;Use Early Metadata=False;Defer Prepare=False;DateTime As Char=False;Rowset Cache Size=0;Datetime As Date=False;AutoCommit=True;Authentication=Server;Decimal As Numeric=False;Derive Parameters=True;LoadBalancing=False;Persist Security Info=True;Cache Authentication=False;Connection Pooling=False;

Also verified same error when creating linked server (linked server alias name: db2pojen)

select * from db2pojen.mydb1.db2inst1.demo_sqlserver

OLE DB provider "DB2OLEDB" for linked server "db2pojen" returned message "One or more errors occurred during processing of command.".
OLE DB provider "DB2OLEDB" for linked server "db2pojen" returned message "Error in BIND or PRECOMPILE option "KEEPDYN?0xF1" with value "". SQLSTATE: 56095, SQLCODE: -30104".
Msg 7330, Level 16, State 2, Line 2
Cannot fetch a row from OLE DB provider "DB2OLEDB" for linked server "db2pojen".

Any advice/input are appreciated.

Thanks!
Post #1333781
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse