ADODB

I am trying to make a db connection, but it doesn't give me ADODB as an option from the list.

You need to add the Microsoft Active Data Objects Library to your project.

Projects | References...
Scroll down a ways and you will see the option. Check the box and click OK. (Use 2.1)

Then you dim a variable as ADODB.

Actually, that's what I did. I'm wondering why it still doesn't work.

Did you try adding the MS ADO Data Control under Project|Components?

Did you create your control by copying another control? Is so, did you answered 'Y' to create data control array? That could be the problem.