Results from SELECT using ODBC 8.0.5.0.0 and ADO

I have an ASP page using ADO attaching to Oracle through ODBC.

I can successfully connect to Oracle ODBC data set.

If I issue an INSERT, a record is inserted. This is good.

If I issue a DELETE, records are deleted. This is good.

If I issue a SELECT with an invalid table name I get a table does not exist error. This is good.

If I issue a valid SELECT, I get a successful completion code (good) but no records in my result set. This is not good.

We have tried this using Oracle's driver, Microsoft's driver, and Intersolv's driver with the same results.

A similarly architected application (ASP/ADO/ODBC/Oracle) against a version 7.x database works fine.

Any suggestions?

Here is the code:

Set rsReports = Server.CreateObject("ADODB.Recordset") Set cmdTemp = Server.CreateObject("ADODB.Command") cmdTemp.CommandText = "SELECT ReportId, MenuRow, ReportName,ReportType, ReportFileName, IndentLevel FROM Report ORDER BY MenuRow" cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = SystemDb rsReports.Open cmdTemp, , 0, 1
'response.write "err from Open= " & err.number & err.description &
"<br>"
'response.write rsReports.EOF & " " & rsReports.BOF & " " & "<br>"

• Ronald K. Olcott, President
• Interlude Enterprises.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 30 1999 - 12:27:48 CDT