ASP & Oracle insert/update problem

From: Ivan <ilee_at_bigpond.net.au>
Date: 22 Apr 2003 08:32:37 -0700
Message-ID: <90137e1b.0304220732.78d17aa6@posting.google.com>

Hi all,

I've just written an app that uses ASP and Oracle, I am currently having trouble with inserts and updates. The site works fine with the select queries but when i attempt to execute insert and update queries nothing happens, no errors etc.

for eg with the following code

response.write "executing query"
dbConn.execute(insertQuery)
response.write "query executed"

it will just write out the first line - executing query and stays there. Also this worked a couple of days agao with no code change.

Using w2k iis5 and oracle odbc driver. DB server is 8.1.7

Anyone have any expereince on this???

thanks
Ivan Received on Tue Apr 22 2003 - 10:32:37 CDT