By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Using ADO AddNew and my simple trigger won't execute

P: n/a
Hi,

We have been using ADO and the AddNew method for a long time as a means
to add records to the database. It has always worked fine - no problem.
But - we recently started using INSERT triggers that simply call a few
stored procs (they're actually SSNS stored procs that send new event
info to notification services). Anyway, these triggers do not seem to
fire at all! If I execute an insert command manually from Query
Analyser, no problems. But the trigger does not fire at all from my
application!

Does anyone know why this could be? For info, my connection string used
by the ADO connection object looks like this: Provider=SQLOLEDB.1;Data
Source=XXX;Initial Catalog=YYY

And my AddRecord ADO code looks like this:

With rs
.Open sSQL, ConnectionString, adOpenKeyset, adLockOptimistic,
adCmdTable And adExecuteNoRecords
.AddNew

Am I mnissing something obvious here? Any help appreciated!

May 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Apologies everyone - It was my own problem after all.
The user I was running the ADO code under did not have permissions to
write to the database after all.

May 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.