Raman

• Nov 5th, 2007

 

You can use ADO's(ActiveX Data Objects) for connecting database from applications.

If u are new to ADO and want to learn refer the following URL

http://msdn2.microsoft.com/en-us/library/ms807730.aspx



 

archus

 Profile Answers by archus 

• Jun 26th, 2009

 

We can use connection object class to establish connection to the specified
DB during runtime

set ConObj=CreateObject("ADODB.Connection")
ConObj.Open"Provider = Provider Name"

For MS-Access the provider name is
ConObj.Open"Provider = Microsoft.Jet,OLEDB.4.0; dataSource = Path of the
DataBase"

For Oracle SQL Server the Provider name is
ConObj.Open"Provider = sqloledb.1;Server=IP Address;uid=username;pwd=****;DataBase=path
of the database"

For Oracle the Provider Name is
ConObj.Open"Provider = oraoledb.1;Server=****;userid=username(Scott);password=****(tiger)"