Adodb

[khanjan_a2k]

Hi all,
I am trying to create some variables as data type ADODB.Connection and ADODB.Recordset but when I actually run the program, I seem to get an error message saying Visual Basic 6.0 does not recognize the variable type. Could someone help me with this.
Do I have to go to Project --> References or
Project --> Components
Whichever one it is, could you please tell me? I don't know which reference or component to select?

Is it Microsoft.Jet.OLEDB.3.51 .... something like that?
Anyways, thanx for your help in advance.

Khanjan

[Dnereb]

Try Microsoft Active(X) data objects with tyhe highest number

[RobDog888]

Add a reference to "Microsoft ActiveX Data Objects 2.x Library"

[Hack]

Add a reference to "Microsoft ActiveX Data Objects 2.x Library"

Once the reference has been added, you can create the variables. Depending on the scope of your project, they should either be declared as Private in the declaration section of your form, or declared Public in the declarations section of a module.

Option Explicit
 
'in a module
Public cn As ADODB.Connection
Public rs as ADODB.Recordset
 
'or, on a Form
Option Explicit
 
Private cn As ADODB.Connection
Private rs as ADODB.Recordset

To use them, the New keyword is required:

Set rs = New ADODB.Recordset 'the recordset object is now ready for use
 
Set cn = New ADODB.Connection 'the connection object is now ready for use