Home > database >  Create links consult SQLServerq server access DB2 data query error: link "PACS_DB" OLE DB
Create links consult SQLServerq server access DB2 data query error: link "PACS_DB" OLE DB

Time:04-21

A business need to access a remote DB2 database, I installed the Microsoft OLE DB Provider V5, and "data access tool configuration data PACS, obtain the connection string, use the data source and the connection string to create a link in the Sql Server 2014 Server (PACS_DB), creation is successful, also can see on the remote database tables and views, but can not query, query is an error:" message 7355, level 16, state 1, line 1. Link server "PACS_DB" OLE DB access interface "DB2OLEDB" for column metadata inconsistencies, changed the name of execution, "please help solve,

The following for related configuration information:
1, PCAS data source connection string:
The Provider=DB2OLEDB; User ID=* * *; Password=* * *; Initial Catalog=gdpacsdb; The Network Transport Library=TCPIP; The Host CCSID=1208; The PC Code Page=1381; The Network Address=10.238.10.111; The Network Port=50000; Package Collection=gdpacsdb; Units of Work=RUW; The DBMS Platform=DB2/MVS; Use Early Metadata=https://bbs.csdn.net/topics/True; Defer Prepare=False; DateTime As Char=False; Rowset Cache Size=0; Binary CodePage=0; Datetime As Date=False; The AutoCommit=True; The Authentication=Server; A Decimal As Numeric=True; Derive the Parameters=False; LoadBalancing=False; Persist Security Info=True; Cache Authentication=False; Connection Pooling=False;

2, the link server configuration:
  • Related