Hi gurus, I am new to this list so pls forgive me if this is a repetition, and pls let ,e know where i could locate the solution. I am on CF 4.5.1 /NT4 sp6a I have a cf-template that calls a procedure which makes (1) an insert into my local database and (2) an insert into a remote database using a dblink (for backup purposes). The insert into the remote db fails leading to an error (S1000 ODBC error). Theres no prob with the insert on the local database. However, if i execute the procedure directly from my SQL, the insert goes thro smoothly both in the local as well as the remore database. I tried putting a db trigger that would do the remote db insert. Same problem there .. What shud i do ? Thanks sanjay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
