I have a ADODB connection using a ODBC informix connection string in VB script. however when I try to use the connection to open a record set. It gives me the error"The connection cannot be used to perform this operation
It is either closed or invalid".

oConn.connectionstring = "Provider=Ifxoledbc;Password=pass;Persist Security Info=True;User ID=user;Data Source=market_report;"

 oRs.ActiveConnection = oConn


Please advice.

You are not opening the connection
oConn.connectionstring = "Provider=Ifxoledbc;Password=pass;Persist Security Info=True;User ID=user;Data Source=market_report;"

oConn.Open

oRs.ActiveConnection = oConn


Sal