Database Connection with Informix using VBA
 

Hi,
Nowadays I'm able to create and execute some queries in a Oracle Database.
To connnect I use the follwing code (username and passwd is gave by user)
'Open DB Connections
Set primeSession = CreateObject("ADODB.Connection")
Set objADORecordSet = CreateObject("ADODB.Recordset")

primeSession.Open "Provider='MSDAORA';" & _
"Data Source='" & database & "';" & _
"User ID='" & username & "';" & _
"Password='" & password & "';"

But I was going to retrieve some info from this DB and then connect to a
Informix Database. But I could not connect to an informix Database.
Have any of you done something similar?

But I'd like to ask the user username and passwd before connecting (not
using an external odbc source)

Thanks for any help, direction or example.