Very Computer

problem:Is it necessary to have tnsnames.ora on each
machine on which I run my vb application that access
remote oracle database ?

How can we run an VB.6 application that access a remote
oracle 7.3 database on a machine which does not have Net8
installed ? What is the other way whereby I can run my
application and access remote oracle database without
configuring local tnsnames.ora/ or without Net8.

So the question is if my machine does not have Net8
Assistant and I want to run my vb application to access
remote oracle database what is the way.

pl. help me find this soultion

Thanks a lot

Manish shah

Manish,

Connectivity to an Oracle database requires the Oracle client installation
on any machine from which a client application is going to connect.

If you can't install the Oracle client on all workstations, one alternative
would be to break your application into the client interface, and a
middle-tier server data access component running on a single central
machine, and interacting with Oracle for your clients. Then only the
middle-tier server would require the Oracle client installation.

But again, whatever machine or machines are connecting to Oracle will
require the Oracle client installation.

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Paul Durdin

Quote:> H! Everybody

> problem:Is it necessary to have tnsnames.ora on each
> machine on which I run my vb application that access
> remote oracle database ?

> How can we run an VB.6 application that access a remote
> oracle 7.3 database on a machine which does not have Net8
> installed ? What is the other way whereby I can run my
> application and access remote oracle database without
> configuring local tnsnames.ora/ or without Net8.

> So the question is if my machine does not have Net8
> Assistant and I want to run my vb application to access
> remote oracle database what is the way.

> pl. help me find this soultion

> Thanks a lot

> Manish shah