Thanks for your quick response Excel Fox.

We have 8 Different Oracle Databases.

In the Form, It will ask the users to Input 2 Values,

Name :

Department :

Location : Drop down List box (ALL Sites
London
Newyork
Delhi
... )


Submit Cancel

When i select All sites, it has to search the input data in all the Databases and need to return the value via a Msg box or in a Text box stating " The Employee :Joseph is working in London at HR Department " and has to return a value "Employee is not working in this Location " if not matching the data..

When i Select Individual Sites, It has to search only the particular database and return the value via a Msg box or in a Text box stating " The Employee :Joseph is working in XXXX at YYY Department " and has to return a value "Employee is not working in this Location " if not matching the data..


I used Record macro to get the VBA code for connecting the Oracle Database and Got the VBA Code,

But when i am running the recorded macro, it is giving error.

i think the below connection string will suit for me,

Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword

but my recorded macro is showing different,

Source = _ oLEDB;Provider=msdaora.1;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword

Can you please help connecting to the Database thru VBA first, so i can make progress on this work?