Re: Results from SELECT using ODBC 8.0.5.0.0 and ADO

Hi,

I would suggest visiting Openlink Software for a free download of their data access drivers. The Multi-Tier suite they offer has been extensively tested in ADO environments. Visit http://www.openlinksw.com for more information

Regards
In article <7nsna7$o9n$1_at_nnrp1.deja.com>,   interld808_at_aol.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 13 1999 - 15:38:49 CDT