Imagine if I have a application I install via clickonce or setup to the customer machine.And it needs oracle client? How can the oracle instant client be installed by the end user ? Or how the hell should it be installed? Should I go to each pc and install it?
+1
A:
Oracle connection requires SQLNet, an Oracle home, etc. So although you can do instant deployment of .net stuff, the Oracle infrastructure needs to be installed on each and every machine that will connect to the database.
Otávio Décio
2009-12-13 15:16:22
You mean to tell me that I have to download thishttp://www.oracle.com/technology/tech/oci/instantclient/index.htmland install it on each PC.
abmv
2009-12-13 15:27:54
I think it should be possible to install the package you mention on a share folder and then you just need to have that folder in the PATH, this way you don't need to touch every machine.
Otávio Décio
2009-12-13 15:40:31
I must check this ,it looks promising thanks for followup
abmv
2009-12-13 16:20:33
+1
A:
You just need to do whatever is in the Instant Client installation instructions, which as I recall amounts to copying the files to a folder, and setting the TNS_ADMIN env veriable. It's pretty trivial.
David Aldridge
2009-12-13 18:45:35
On Linux you need to set LD_LIBRARY_PATH. ODBC requires an executable to be run (don't know the privileges required to run it)
Gary
2009-12-13 21:47:16