Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> access and odbc error with a database link
Hi-
Does anyone have experience in successfully getting an Oracle trigger which
is directly on the underlying Oracle table to fire from access. I get it to
work out side of access no problem, but as soon as I add the reference to
the oracle database link. ie: insert into sys.testable_at_Test.cc.university.
Then I receive an odbc error that it can't update a linked table. If I try
to update the table directly though access, I get an ORA-02041: client did
not begin a transaction. I am placing the trigger directly in Oracle
because the access application is an off the shelf deal, that I don't want
to mess with because of legal issues.
Received on Thu Feb 07 2002 - 13:44:46 CST