Re: ASP & Oracle insert/update problem

"Ivan" <ilee_at_bigpond.net.au> wrote in message news:90137e1b.0304220732.78d17aa6_at_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

Ivan, could it be a record-locking problem? You said it worked a few days ago; is this a live website? Possibly someone else has that record open, and the ADO object is just waiting for a lock on the record? Also, have you tried using the Oracle Provider for OLE DB driver? It will support more of Oracle's functions than the ODBC driver would. Is there a specific reason you're using the ODBC driver (just curious)? I've used the Oracle provider for my ASP/Javascript/IIS5/Win2k Advanced Server routines.

-Thomas Received on Tue Apr 22 2003 - 11:13:37 CDT