How to Install Oracle without installing Oracle Client?

How to Install Oracle without installing Oracle Client?

Postby AntonyGumi » Tue 07 Mar 2006 09:57

Hi there:)
I'd like to know how to install Oracle Database without installing its Oracle Client but will still be able to have access to the oracle database. Could anyone help me on this? :roll:
Moreover, I have searched some topics on the internet and found a software called Instant Client. Could u please tell what other components are needed in order not to install Oracle Client?
Thanks for your help
With Regards,
Antony :D
AntonyGumi
 
Posts: 3
Joined: Tue 07 Mar 2006 09:12

Postby Paul » Tue 07 Mar 2006 13:37

In Direct mode OraDirect .NET Data Provider talks to Oracle server in person, without calling any third party libraries. It allows your application to work with Oracle directly through TCP/IP protocol without involving Oracle client software.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

IIS

Postby Guest » Wed 08 Mar 2006 03:07

Hi.Thanks for the answer. :D
I still have few more questions. What if I use IIS? Will there be any difference? What components should I install to make my database (Oracle) and web server(IIS) runs?
p.s. I dont want to install Oracle Client
Thanks
Antony :)
Guest
 

Postby Paul » Thu 09 Mar 2006 16:21

You can set Direct=true in OracleConnection.ConnectionString and work without Oracle client installed.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Hi there

Postby AntonyGumi » Tue 04 Apr 2006 10:00

Thanks again for the reply.
Now I have a different case but still about Oracle Client.
How to access to Oracle Server without installing Oracle Client software?
What components should I install, please specify.
I've tried Instant Client but it didn't work :cry:
Please reply ASAP.
Thank you :D
AntonyGumi
 
Posts: 3
Joined: Tue 07 Mar 2006 09:12

Postby Paul » Wed 05 Apr 2006 10:45

OraDirect .NET can work with standard Oracle client, Oracle Instant client and without any client at all. It works without problems with web applications running on IIS. However, it may be required to set access permissions properly on the web server.

The only product you have to install on client side to develop applications is OraDirect .NET; to deploy application written with OraDirect .NET you have to include CoreLab.Oracle.dll file in the installation.
To connect to Oracle server directly you can set Direct=true in OracleConnection.ConnectionString as indicated above, for example:
OracleConnection.ConnectionString = "Direct=true;Sid=...;Server=...".

To connect to server through Instant Client you have to specify path to oci.dll in Windows environment PATH variable. In OracleConnection.Server property (or Server part of connection string) specify connection parameters as follows:
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))) (CONNECT_DATA = (SID = ORCL)))
Another way to provide this information to OraDirect .NET is to put TNSNAMES.ORA file to the current directory for your application.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Problem when using Direct in connection string

Postby MentorUser » Mon 03 Jul 2006 17:34

Hi,

I set the 'Direct' property to true in my connection string. I got the following error message

ORA-12545: Connect failed because target host or object does not exist

What am I missing? I tried putting the TNSNAMES.ORA in the same folder as the application without any luck. Any ideas?

Thanks

Louis
MentorUser
 

Postby Paul » Tue 04 Jul 2006 06:47

Please check that the host name or IP address is specified in Server parameter. Please see "Using Direct Mode" topic in OraDirect .NET documentation for more details.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

PATH requirement

Postby athony.meehan » Fri 18 Aug 2006 10:26

Paul wrote:To connect to server through Instant Client you have to specify path to oci.dll in Windows environment PATH variable.


Is there any way to get around this requirement? We would really like xcopy deployment for our desktop app, so we would like to be able to put oci.dll in the same directory as the application.
athony.meehan
 
Posts: 1
Joined: Fri 18 Aug 2006 10:22

Postby Alexey » Tue 22 Aug 2006 08:44

From the Installation Instructions of Instant Client (http://www.oracle.com/technology/tech/oci/instantclient/index.html):
Unzip the packages into a single directory such as "instantclient". Set the library loading path in your environment to that directory. On Windows, PATH should be used.
So we cannot give you advices on working around it because this exceeds goals of our support.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby RMata » Fri 22 Dec 2006 19:22

The Direct Mode can be used in a Connection String in a Pocket PC application?
RMata
 
Posts: 2
Joined: Fri 22 Dec 2006 00:29

Postby Alexey » Mon 25 Dec 2006 15:47

The only mode which can be used in a Pocket PC application is direct mode.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle