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
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
