Link to home
Start Free TrialLog in
Avatar of thomasd04
thomasd04Flag for United States of America

asked on

Is it possible to connect to Oracle database without installing Oracle Client on my workstations?

I know this questions has been asked many times before but the answers I saw in the knowledge base were years old. I'm hoping that technology has changed and it may now be possible.

I have a script that we're using to collect much information about our computers and users. I need it to write the data to an Oracle DB but would rather not install client on all workstations (which I think would introduce new problems I'd rather avoid). I read that EZ Connect can do it but it seems to me that it still needs Oracle Client installed. Does anyone know if it's possible to connect to an Oracle DB without having to install Oracle Client?
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thomasd04

ASKER

I'm anticipating that Instant Client will be the best option with the smallest footprint. I was just hoping that someone discovered a miracle work around. I'll give the thread a day...
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

The JDBC Thin connection is pretty much it.  Then again, miracles do happen at times!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The nice thing about dotConnect is it also acts as a layer on top of the native client, if it is available, and takes care of dynamic loading of any version. So it gets around all of the aggravation of keeping a specific version of ODP.NET with your app.