Options other than ADODB.Connect

[sabev]

Help again.

I'm am using ADODB.connect to try to connect to an informix database. I have tried to connect with both a DSN and a connect string. I built the connect string with a .udl file and the test connect with that file works fine.

The DSN works fine with other VB code

CODE -
set conShark = Server.CreateObject("ADODB.CONNECTION&quot
conShark.Open "Provider=MSDASQL.1;Persist Security Info=False;User ID=summit;Data Source=Informix7;Initial Catalog=summit@test_live"

It won't work with ASP.

ASP VBScript ERROR -

err no 450__Wrong number of arguments or invalid property assignment

GRRRRR. Anyone see what might be wrong? I have a feeling that the provider may not be correct for informix (but why would it work on a test connect?)

Also, is there another connect object that I could use with VBScript? I think this uses an OLEDB bridge to ODBC. Could I connect straight with the ODBC?

Thanks