Hello Listers, ARS 7.1 Patch 4 MS SQL Version 9.0.3007
I have a remote linked MS SQL Server (probably SQL 2000) that I have been pushing data to for years. Now that the Remedy ARS db is on a new box and a newer version of MS SQL I can not longer push the data. The SQL statement is Insert INTO SW_License.License_Management_Test.dbo.ARS_View1 (MR_Date, EDD) VALUES ( '1/7/2009 12:00:00 AM', '2/19/2009 12:00:00 AM') I get the following message in the arsql.log file. * WARNING * The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "SW_License" was unable to begin a distributed transaction. (SQL Server 7391)OLE DB provider "SQLNCLI" for linked server "SW_License" returned message "No transaction It gets truncated in the log so I don't know what the returned message is indicating. the ARS_View1 is a view that was created on the remote DB that converts date values to integers so we can display dates in ARSystem using a view form. I am wondering if that is causing a problem when pushing the values back to the remote view. If I am missing some information needed to understand this question please feel free to ping me. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
