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
Code:
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