[RESOLVED] Oracle Connection Run Time Requirement for other Clients

[maqmaq]

Gents,
I am using the following to open an oracle connection from my VB6 ADO, it works great in my machine where I have the Oracle Database 10g Express Edition already installed.

What do I need to install in other users' machines in order to have them a successful connection?
Is installation of msdaora.dll will be enough or do I need to install the oracle components which I hate to do so?.

Your reply and help will be very much appreciated

CONOra.Open "Provider=msdaora;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oradbt01)(PORT=1234)))(C ONNECT_DATA=(SID=oradbt01)(SERVER=DEDICATED)));User Id=RXXXX;Password=UXXXXXS;"

[GaryMazzone]

The oracle client software need to be installed on the client machines. A TNSNames entry for the connection should be placed in the TNSName file. This is an abosulte necessity (IT IS A REQUIREMENT TO HAVE THE ORACLE CLIENT SORTWARE on each machine that will connect to an Oracle database using any MS technology).

[maqmaq]

Thanks

What about if I change it from Oracle to SQL?? will it be the same requirement?? I am trying to avoid Oracle client installation
Apprecaite yur advice
Thanks

[si_the_geek]

By SQL do you mean SQL Server? ..or MySQL? ..or another one?

Assuming SQL Server, you should ideally install the Native Client (link in my signature) for SQL Server 2005+, but in most cases can get away with the older driver included in MDAC/Windows DAC (pre-installed on XP and later) which is designed for SQL Server 2000. There are limitations if you do that, but I can't remember what they are.

[maqmaq]

Thanks
I guess I will go with SQL Server as you suggested, I had confirmed your comments with our data unit and they suggest to use it as well where no additional installation is required as our company is using Windows Vista

Many thanks

[maqmaq]

This is a reference to the resolve of this thread:

I used the following connection string and it works in every machine with Vista without a problem and without the need of additional files installtion:

CONSQL.Open "Provider=SQLOLEDB.1;Server=DRA00730-SQLT01;Database=myDataBase;Uid=myUsername; Pwd=myPassword;"