Upgrade from IDS 7.23 to IDS 9.4 using ASP code and IIS causes DB update error

Hi, I am currently running Microsoft IIS 5.1 (using asp pages w/VB script) and IDS 9.4 with IBM Informix Connect 2.81. I have been trying to figure out why I'm getting an error "ADODB.Connection (0x800A0CB3) Current provider does not support transactions" while trying to do an update to a table on an IDS 9.4 database. This update works correctly on IDS 7.23, but not for the exact same setup/code on IDS 9.4. I'm not sure if there is something added at the server level that I should change or if it is an internal Informix 'feature' that IBM has added. INFORMIXDIR and INFORMIXSERVER has been set in SETNET32 and the connection test works successfully in the ODBC Data Source Administrator. Here is some of my code: <In global.asa> Sub Application_OnStart Application("dbConn_ConnectionString") = "DSN=my Informix" Application("dbConn_ConnectionTimeout") = 15 Application("dbConn_CommandTimeout") = 30 Application("dbConn_CursorLocation") = 3 End Sub <In DATAFUNC.asp> Function OpenDB() Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionTimeout = Application("dbConn_ConnectionTimeout") dbConn.CommandTimeout = Application("dbConn_CommandTimeout") dbConn.Open Application("dbConn_ConnectionString") End Function <In j_up_bio.asp> Call OpenDB() SQLStmt="UPDATE pool_web SET email_acct = '"&memailaddy&"' WHERE part_no = '"&mpart_no&"';" dbConn.BeginTrans Set RS = dbConn.Execute(SQLStmt) The error says that dbConn.BeginTrans is the line with the problem. Any help on this will be greatly appreciated. Randy -- Message posted via http://www.dbmonster.com