Oracle with Clients: I must install oracle for client ?

Question

Hi all, I'm very newbie for Oracle and very not sure about Oracle. one question I want to know.

if I want develop oracle windows application. first I must install oracle on server for database server but I'm not sure if I don't want install oracle on client. I must install oracle for client YES or NO !?

thank for help.

Answer 1

Yes. The Oracle client must be installed on any machine wishing to access the database. The components of the client you need to install will depend on the method your application using. eg. OLEDB, ODBC, etc.

Answer 2

The answer is 'it depends' - your software will need some kind of client-side driver or library for communicating with Oracle, but there are many ways you can do this.

1) Compiling Oracle's SDK libraries directing into your application. 2) Using a locally installed SQL*Net client (which can be shared between different local applications, so that things like TNS_NAMES setup can be shared). 3) Using third-party libraries embedded in your application.

Also the different kinds of clients can expose or restrict different levels of functionality.