DTC Query giving error 7405

• Jay1971

  SSC Journeyman

  Points: 84

  More actions

  April 22, 2004 at 7:35 am

  #76153

  Hi,

  I'm trying to run a query contained within a stored procedure which references a table in a remote connection and keep getting the Heterogenous queries, ANSI_NULLS, ANSI_WARNINGS error 7405. I've set the defaults on both server connections but the error still persists. Can anyone help with this?

  Many thanks,

  Jay.

• CJ van Niekerk

  SSC Rookie

  Points: 37

  More actions

  April 23, 2004 at 1:44 am

  #503950

  Hi Jay,

  What is your remote db ?

  I had the same problem with IBM DB2/400. Had to change the database default for ansi padding and warnings in the end.

  Regards CJ

• Jay1971

  SSC Journeyman

  Points: 84

  More actions

  April 23, 2004 at 2:54 pm

  #504090

  Hi CJ,

  I was actually trying to connect to another instance of SQL Server.

  Normally, I have no problem doing this but the difference this time was that the two instances were nodes in a clustered server.

  I tried changing the connection settings for ANSI warnings and ANSI Nulls via the Enterprise Manager but had no joy.

  How, precisely, did you get your DB2, DTC instance working?

   

  Cheers,

  Jay.

• rcluciano

  SSC Veteran

  Points: 284

  More actions

  May 20, 2004 at 8:49 am

  #507146

  try this link, works

  http://support.microsoft.com/default.aspx?scid=kb;en-us;296769