DB2 Linked Server

Question

DB2 Linked Server

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Lyn Duong SSC-Addicted Points: 448 More actions · Answer 1

Hi,

I found out what it was. My provider string was incorrect. Should've been provider='ibmdadb2',dsn=odbcdatasource;

Anyway, now I have successfully set up a linked server using MICROSOFT odbc for db2 driver as my datasource, I am getting the following error when I select from a table with alot of records

OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.

OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.].

Does anyone know what particular setting must be on ??

Thanks again!!

Lyn

Ben Patrick Right there with Babe Points: 794 More actions · Answer 2

What does mainframe db2 log indicate?...probably times out and can be modified for the id running the linked server.

Lyn Duong SSC-Addicted Points: 448 More actions · Answer 3

Hi,

There is no error in the mainframe.

It appears that if the table that I am selecting from is small...as in only a few hundred records, then the data is returned ok, if the table is larger, i get an error.

Lyn

Ben Patrick Right there with Babe Points: 794 More actions · Answer 4

Any idea where the breaking point is? How many rows are in the db2 table?

What is the query you are using to retrive the data?

I can potentially try to reproduce it .

Lyn Duong SSC-Addicted Points: 448 More actions · Answer 5

Hi all,

I must be the only one with continual problems with creating a linked server from sqlserver to db2.

We have successfully configured on using ibm odbc data source but it has a problem in that it causes the whole server (with 8cpus) to switch to one processor usage so performance is a real issue. Therefore I am now playing around with using the microsoft odbc for db2 driver.

We have installed the Host Integration Server and then I configured a odbc datasource for our db2 database. Then in sql server, I create the linked server using Microsoft oledb provider for odbc data source. I put the dsnname in the provider string and still get an error. The error we get now is again a 7399 error. with initialising MSDASQL.

If i put dsn=dsnname in the provider string i get a EXCEPTION_ACCESS_VIOLATION error.

We seem to flip from Initiliasation error to EXCEPTION errors

Do you have any ideas why this would be happening?

Thanks

Lyn

Joel Ferreira SSC Enthusiast Points: 117 More actions · Answer 6

I created a linked server to as400 using the provider for db2 (his 2006) but i cant even do a select dont know why

Server: Msg 7399, Level 16, State 1, Line 5

OLE DB provider 'DB2OLEDB' reported an error. The provider did not give any information about the error.

OLE DB error trace [OLE/DB Provider 'DB2OLEDB' IUnknown::QueryInterface returned 0x80004005: The provider did not give any information about the error.].

the provider string i think its ok as i get it from a datasource created in the data access tool in the ms his 2006 tool

someone could tell me in the provider options which options should be enabled?

My problem is explained here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=359536

i would appreciate that someone could help me