Brooks, try turning on SQL logging via the client and see the content of SQL statement being issued to the database, this may help show you what the issue is. Sam
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of brooksm Sent: Thursday, 15 November 2007 2:21 p.m. To: ARSList Subject: Direct SQL Active Link to query Oracle from SQL Server Hi Listers I've built a query using openquery that queries an oracle view from my ARSystem on SQL Server 2005 This doesn't work: select * from openquery(STG,'select * from USER.HOUSEHOLD_VIEW where HOUSEHOLD_ID = ''$Email Address$'') Produces this error: ARERR [552] Failure during SQL operation to the database : The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3903) The preceding message occurred during the execution of active link Retail Help Desk - SQL -- action 1. (ARNOTE 1101) If I change the (= ''$Email Address$'') to (= ''[EMAIL PROTECTED]'') it works fine. I'd ultimately like to use (LIKE ''$Email Address$'' + ''%'') but just can't get the syntax correct. Is there anyone with this kind of experience that can help me figure out the correct syntax? Thanks Brooks -- View this message in context: http://www.nabble.com/Direct-SQL-Active-Link-to-query-Oracle-from-SQL-Se rver-tf4809105.html#a13759981 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
