Re: What driver is connecting to my database?

Sybrand Bakker wrote:
> On 7 Sep 2006 13:19:45 -0700, "Ben" <balvey_at_comcast.net> wrote:
>
> >Oracle 9.2.0.5 Ent Ed AIX5L.
> >
> >Is it possible to determine the driver / type of connection that is
> >being used by different users to connect to the database.
> >Our ERP system came with an ODA driver that is read only. If any of our
> >users want to use MS Access to connect to our database they are
> >supposed to use that driver with linked tables. We have had some data
> >corruption lately with some rows being updated and some being deleted.
> >No one is supposed to have the Ora92 driver to avoid this situation,
> >but we are wondering if someone is using the Oracle supplied driver.
> >How can I figure this out?
> >
> >Thanks
>
> You are asking the wrong question. You should ask: why didn't I
> enforce integrity *in my database* so no one can create havoc, and we
> don't have to resort to tricks like using a driver which is supposedly
> 'readonly' (which doesn't exist of course).
>
> --
> Sybrand Bakker, Senior Oracle DBA

Sorry, I didn't design the database. I just took it over when my company laid the only DBA off. Every environment in this World isn't perfect. There being, yes, sometimes you have to do work arounds to accomplish something. Our database environment is a mess, I can't help that, all I can do is try to improve it, and that is what I'm doing. And the JDE ODA odbc driver is supposedly read only, if it is not then JDE/Peoplesoft/Oracle have some explaining to do. I just asked a question, I have read ( and appreciate) your information that you give Sybrand. Can you help me out here, or is there not a way of doing this?
Thanks,
Ben Received on Thu Sep 07 2006 - 20:37:02 CDT