I have a CA-OpenIngres 2.80 ODBC driver and I am trying to setup a
connection to Ingres database
in VB 6 using ADO. (Works through MS Access.)

Dim cn as ADODB.Connection
Dim connstr as String
Dim rs As ADODB.Recordset

Connstr =
"driver="{CA-OpenIngres}";uid=*******;pwd=******;server=mydatabse;"

Set cn = New ADODB.Connection
With cn

            .ConnectionString = connstr
            .Cursorlocation = adUseClient
            .Open
End With

I am getting an error: Insufficient connect information and dialog
prohibited.
If anyone could help me with the correct order of parameters or correct
connection string
I would really appreciate it.