How to create connection with the help of RDO Control?

Firstly Create DSN(Data Source Name) using following steps:

1.      open control panel->Select Administrative tool->select DataSources(ODBC) and double click on it, open a dialog box whose name is ODBC Data Source Administrator and select user DSN tab

2.      click on Add button->Create New Data Source window is open->select a driver for which you want to set up a data source->click on finish button

3.        Again open a dialog box where you give data source name and description->click on select button ->ok.

After the above steps we again follow the following steps…

1.Firstly add RDO control in toolbox  with the help of following steps

a)      Project Menu

b)      Components

c)      Select Microsoft RemoteData Control 6.0

2.Add Control in VB form

3.Set the following property from Property Window

   a)   DataSourceName

b)   SQL