Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Microsoft OLE DB for DB2 - SQL Server" for linked server "(null"). Error: 7330

Status
Not open for further replies.
jambaii

jambaii

Programmer
Nov 3, 2016
1
US
When I try to open the tables from a linked server (DB2 V10.5) I am getting the below error, but when I run the "Test Connection" it says: "The test connection to the linked server succeeded".
I have a SQL Server 2012 R1, DB2 v10.5 and have installed "Microsoft OLE DB Provider for DB2 v4.0".
Code: 
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
Additional information:
An exception occurred while executing a Transact-SQL statement or batch.
(Micrisoft.SqlServer.ConnectionInfo)
Cannot fetch a row from OLE DB provider "SQL Server" for linked server "(null)". (Microsoft SQL Server, Error: 7330)

Any help is highly appreciated.

Thank you
 
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
269
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
215
tekpr00
tekpr00
handle907
  • Locked
  • Question
ADM10501W - Health indicator "Database Automatic Storage Utilization"
Replies
0
Views
235
handle907
handle907
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
189
mikrom
mikrom
Thomas B
  • Locked
  • Question
"BMC AMI Ops Monitor for Db2" (mvmon) trace for prepared statements (from Java)
Replies
0
Views
122
Thomas B
Thomas B

Part and Inventory Search

Sponsor

Back
Top