All,
Using Vista IIS7 with Oracle 10G.
I'm getting a "Multiple-step OLE DB operation generated errors" when issuing the execute command. Here is the code I'm executing. When I execute the same command from visual basic it works fine, I just get the error from ASP.
set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=MSDAORA; DataSource=DB01; User ID=MAIN; Password=MAIN;"
sql= "SELECT * From securityinfo WHERE user='TEST' AND dte_effect <= {fn curdate() } and (dte_cncld IS NULL or dte_cncld >= {fn curdate() } )"
Set oRs = oConn.Execute(Sql)
Here is the entire error message.
Number: -2147217887
Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Source: Microsoft OLE DB Provider for Oracle
SQLState:
NativeError: 0
Any ideas?
Thanks,
Jerry R.