Re: Upgrade from IDS 7.23 to IDS 9.4 using ASP code and IIS causes DB update error
Posted in 2005
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life
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