Declare Connection Object

[Rogerb]

I am trying to declare a connection object in the main.bas module of my VB6 project.

I have tried the following statements:

Dim db As ADODB.Connection

and

Dim db As Connection

I get the following compile error for both

"User-defined type not defined"

Can anyone help?

Thanks

Roger

[axion_sa]

You need to reference the ADO library:
Project > References > Microsoft ActiveX Data Objects 2.x

[Rogerb]

Thanks.

That makes all the diference, I didn't come across it in my book and I find MSDN to be something of a nightmare to consult.

Roger