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

Sounds like something you'd get if logging were turned off on the 9.4 database. If the information were moved from 7.23 to 9.4 via dbexport/dbimport that would be the default logging level. "RandyE via DBMonster.com" <forum@DBMonster.com> wrote in message news:dcfc9dda6e1c4df1b4dbe8a11bdc0a7a@DBMonster.com... > 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