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

thomasd04
thomasd04 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
As it stands right now I believe the only way is using the JDBC Thin Client.

There is talk about a .Net Thin client but that isn't out yet.

The Instant Client is probably the way to go here.  It is the smallest footprint possible and doesn't install a lot of stuff you don't need.
Most Valuable Expert 2011
Top Expert 2012
Commented:
EZ Connect only applies to sqlnet configurations which would be part of the client.

you must install "some" kind of client software to get drivers for talking to Oracle.
Something like oci, odbc or jdbc.

If you install the oracle client software from Oracle you can use all 3 of those.

If you use some 3rd party, you might be able to have a smaller foot print with less install files but that will depend on the 3rd party.

Have you considered the "instant client"?  It's still oracle but smaller installation

Author

Commented:
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...
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
The JDBC Thin connection is pretty much it.  Then again, miracles do happen at times!
Top Expert 2009
Commented:
It depends on what application language you use. If you happen to use VB.NET, then Instant client isn't the smallest footprint,  you can instead use the commercial, fully managed thin client dotConnect (http://www.devart.com/dotconnect/oracle/). It amounts to a small dll included in your app. The limitations are it doesn't handle the object features in Oracle.

For older VB or other native requirements, best bet is the instant client, using XCopy deployment (Look for XCopy option on the download page)


@slightwv: >>There is talk about a .Net Thin client but that isn't out yet.

You are referring to the Oracle brand client. But 3rd party ones are available.

Top Expert 2009

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial