U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Oracle: How can use standard OCI without install oracle client?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Oracle: How can use standard OCI without install oracle client? [message #26744]

Tue, 25 May 2010 14:25

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

Hello all,

Is possible to use oci.dll without installing oracle client?

Of is, what files and setting need to be done?

I need for windows xp platform.

Thanks in advance,
Ion Lupascu (tojocky)

Report message to a moderator

Re: Oracle: How can use standard OCI without install oracle client? [message #26764 is a reply to message #26744]

Wed, 26 May 2010 15:26

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

tojocky wrote on Tue, 25 May 2010 15:25

Hello all,

Is possible to use oci.dll without installing oracle client?

Of is, what files and setting need to be done?

I need for windows xp platform.

Thanks in advance,
Ion Lupascu (tojocky)

I found the solution!

It is possible to copy the files: oci.dll, ociw32.dll (in case if you use oracle7 or explicit set oci.dll/so libname) and oraociei10.dll.

In u++ first of all need to set library path explicit by using the method: OCI8SetDllPath(<full oci.dll/so address path>)
or OCI7SetDllPath(<full oci.dll/so address path>) if you use oracle7.

Hope if this information will be useful for somebody!

Best regards Ion Lupascu (tojocky)

Report message to a moderator

Re: Oracle: How can use standard OCI without install oracle client? [message #26769 is a reply to message #26764]

Wed, 26 May 2010 17:42

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

tojocky wrote on Wed, 26 May 2010 09:26

tojocky wrote on Tue, 25 May 2010 15:25

Hello all,

Is possible to use oci.dll without installing oracle client?

Of is, what files and setting need to be done?

I need for windows xp platform.

Thanks in advance,
Ion Lupascu (tojocky)

Not needed if they are in the same dir as .exe.

You also need tnsnames.ora and sqlnet.ora config files in the same dir as .dlls.

Mirek

Report message to a moderator

Re: Oracle: How can use standard OCI without install oracle client? [message #26773 is a reply to message #26769]

Wed, 26 May 2010 19:15

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

luzr wrote on Wed, 26 May 2010 18:42

tojocky wrote on Wed, 26 May 2010 09:26

tojocky wrote on Tue, 25 May 2010 15:25

Hello all,

Is possible to use oci.dll without installing oracle client?

Of is, what files and setting need to be done?

I need for windows xp platform.

Thanks in advance,
Ion Lupascu (tojocky)

Not needed if they are in the same dir as .exe.

You also need tnsnames.ora and sqlnet.ora config files in the same dir as .dlls.

Mirek

I tested on local network and did not works if isn't specified the full path!

I did not know about tnsnames. my connection is dirrect to server like usser/pass@host:port/SID

Add:
I want to add that is possible to install Oracle Client Lite (only shared library files) by address:
http://www.oracle.com/technology/software/tech/oci/instantcl ient/index.html
According by documentation Oracle Call Interface 10.2 guide.

[Updated on: Fri, 28 May 2010 14:23]

Report message to a moderator

Previous Topic:	Access violation since rev 2407
Next Topic:	SQLITE: remove case sensitive of column type name.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Apr 19 06:04:28 CEST 2024

Total time taken to generate the page: 0.04241 seconds