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!
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?
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?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
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.
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
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
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...
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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial