Try switching off ANSI warnings.. It may help.. Joe
----- Original Message ---- From: "Opela, Gary L Contr OC-ALC/ITMA" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, March 21, 2007 3:50:00 PM Subject: Re: MS SQL on Win 2k -> Win 2k3 issue ** Wow, thanks. I can believe that, judging by the mass confusion of all of my DBAs. Stephen has pointed out several other posts where users had similar issues. I’m going through and trying all of their different things right now that helped them. So far, no luck. I’ll look at the MS article below in a minute. I already sent one MS article I found on similar issues with DST to my DBA, and he tried configuring the DST service the same way that the article said, and that’s what got us to where we were. Before I started getting this error, my query would just hang. I’ll keep you guys posted. From: Action Request System discussion list(ARSList) [mailto: [email protected] ] On Behalf Of Nall, Roger Sent: Wednesday, March 21, 2007 2:34 PM To: [email protected] Subject: Re: MS SQL on Win 2k -> Win 2k3 issue Gary, Here is some more info from my dba: btw the problem can be reproduced in query analyzer by putting the remote query in a transaction begin tran select * from linkedserver..tablename commit tran you would get an error stating that it could not being a distributed transaction. With Remedy you have to be careful to use the exact Remedy syntax including transaction rules to ensure that you get the same results. Just so you know, it took my dba about a week to figure this out. He said it was the most difficult thing has had had to solve in his 2+ years here. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto: [email protected] ] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Wednesday, March 21, 2007 1:26 PM To: [email protected] Subject: Re: MS SQL on Win 2k -> Win 2k3 issue Okay, so, my DBA changed something on the server, I’m not sure what yet, but we now are getting closer. I asked him about DTC, he said he had already checked it. I am wondering if maybe he had found a configuration was off or something, a colleague and I had found some documentation that seemed to document issues similar to mine and sent it off to him. We now get the following error: ARERR [552] Failure during SQL operation to the database : The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3903) Do I have something configured incorrectly on my side? Thanks, Gary From: Action Request System discussion list(ARSList) [mailto: [email protected] ] On Behalf Of Heider, Stephen Sent: Wednesday, March 21, 2007 10:03 AM To: [email protected] Subject: Re: MS SQL on Win 2k -> Win 2k3 issue Has DTC been enabled and configured on the Win 2003 server? Stephen From: Action Request System discussion list(ARSList) [mailto: [email protected] ] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Wednesday, March 21, 2007 10:57 AM To: [email protected] Subject: MS SQL on Win 2k -> Win 2k3 issue ** Environment: Local Server: Windows 2k MS SQL 2k Remedy 6.3 no patch Remote Server: Windows 2k3 MS SQL 2k Every since the server guys upgraded the remote server to 2k3, it has broken my functionality to connect to it via a linked database using remedy. It works just fine when using SQL Query Analyzer, it just doesn’t work with Remedy. The DBAs can see my connection come through, just not the query. I know I’ve already posted on this, but I have new data in that I’ve found out what was upgraded, Windows 2k server -> Windows 2k3 server. This upgrade is the only thing that changed, and then my linked database stopped working. I was wondering if anyone out there has gone through the same process and had similar results? Thanks ____________________________________________________________________________________ Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
