Hi Everybody


I am trying to connect to an Oracle database using Excel VBA (using the ADO objects).

Does anyone know the connection string syntax to connect to Oracle database, preferably prompting the user to enter the user id and password.

I could do the same to connect to SQL Server database.


Best regards


Deepak