Hi,

I know this thread is many years ago but hoping someone came up with the solution to this problem as i am facing the same issue. Ie after a cluster...

Hi, we use mountpoints in our clustered SQL instance. I think it would be great to include this into your scripts

Hi David,

I am having the same problem and noticed your post.

When u use dbcc traceon (1204,3605,-1),

what is the 3605??? just another traceflag ?? does the -1 set it permanently for...

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...

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...

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...

Hi,

I have verified that the database user and pw is correct as I am able to connect to the database using the same credentials using the db2 client.

I'm thinking that...

Hi all,

Still on the subject of creating db2 as a source for linked server, I have tried to create one with no success on a particular server. (works on other...