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;"




Reply With Quote