How connect to ORACLE SERVER over LAN in VB6

[nasreen]

Hi,

My server (IP: 192.168.0.100) is installed ORACLE database. My application in clients want to connect to the ORACLE installed in the server using ADO.

How will be the connectin string used in ADO connection object ? How can I specfy the server name or IP in the connecting string ? Is there needed any additional installation of ORACLE software or components in each client machine ?

I can connect from the server itself using the following connection string

Provider=MSDAORA.1;Password=MyPwd;User ID=MyUid;Data Source=MyDb;Persist Security Info=True

But I can't use this to connect from clients.

With regards,
Nasreen

[techgnome]

Take a look at http://www.connectionstrings.com/oracle the connection string will vary slightly based on how you are connecting.

-tg

[nasreen]

Hi techgnome
I already come over the link specified by you.
But none of the string work with me. And I have no much idea about how to set ODBC settings for ORACLE in clients.
So can you please explain how to do this step by step ?
Or can you help in connection string using ADO (Native connection) ?
I want either ODBC or ADO connection string and ODBC settings for ORACLE in clients.

Nasreen

[RhinoBull]

First: your clients (or users) must have Oracle Client installed.
Then you will have to make sure that local (on each user machine) tnsnames.ora file is up to date (ask your database administrator to supply you with one or you can just file from server).
When you complete first two steps you should be able to connect to your Oracle database using connection string from your original post.

[si_the_geek]

Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

[abhijit]

First: your clients (or users) must have Oracle Client installed.
Then you will have to make sure that local (on each user machine) tnsnames.ora file is up to date (ask your database administrator to supply you with one or you can just file from server).
When you complete first two steps you should be able to connect to your Oracle database using connection string from your original post.

Once you have this done, you should be able to use the TNSPING utility to locate your Oracle Server. You should also be able to use SQLPLUS and connect to this server. Unless you have done the connection with SQLPLUS, do not attempt to use the connection string or your front-end code.

The tnsping utility is used to determine whether or not an Oracle service can be successfully reached. If a connection can be established from a client to a server (or server to server), tnsping will report the number of milliseconds it took to reach the remote service. If unsuccessful, a network error will be displayed. However, tnsping will only report if the listener process is up and provides no indication of the state of the database.