Totally Weird-Oracle Returns Empty RecordSet!

aitai · Dec 5, 2001

Hi, All

I am getting a weird problem accessing data from an Oracle 8.1.7 Database. The SQL query only returns the ColumnHeaders, but no data (no error message either)! Even more weird, the same script (with the obvious modifications) runs perfectly in SQLServer 7.0. I would greatly appreciate any insight that anyone has to offer. Below are the relevent details.

OS: WIN2K
Server: IIS 5.0
Database: Oracle 8.1.7
Table: Desination [DestinationID(CHAR(3)),Country(VARCHAR(20))]
Script: See below

<%@ Language=VBScript %>

<html>
<head>
<title>Oracle Test</title>
</head>
<body>
<center>
<%
Set objConn = Server.CreateObject("ADODB.Connection&quot

objConn.Open "dsn=OraDev;uid=scott;pwd=tiger;"

Set objRs = objConn.Execute("SELECT * FROM Destination&quot

Response.Write "<table border=1 cellpadding=4>"
Response.Write "<tr>"

For I = 0 To objRS.Fields.Count - 1
Response.Write "<td><b>" & objRS(I).Name & "</b></td>"
Next

Response.Write "</tr>"

Do While Not objRS.EOF
Response.Write "<tr>"

For I = 0 To objRS.Fields.Count - 1
Response.Write "<td>" & objRS(I) & "</td>"
Next

Response.Write "</tr>"

objRS.MoveNext
Loop

Response.Write "</table>"

objRs.Close
objConn.Close
%>
</center>
</body>
</html>

link9 · Dec 6, 2001

Try making all this:

Set objConn = Server.CreateObject("ADODB.Connection&quot

objConn.Open "dsn=OraDev;uid=scott;pwd=tiger;"

Set objRs = objConn.Execute("SELECT * FROM Destination&quot

into

Set objConn = Server.CreateObject("ADODB.Connection&quot

objConn.Open "dsn=OraDev;uid=scott;pwd=tiger;"
dim sql
sql = "SELECT * FROM Destination"
Set objRs = server.createObject("ADODB.Recordset&quot

objRs.open sql,objCon

Might put it over the hump because you aren't asking for anything implicitly.

hope that helps!

Paul Prewett

aitai · Dec 6, 2001

Thanks, Paul-that did it!

danielhai · Dec 6, 2001

your code looks fine - you sure you have stuff in your destination table?

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Totally Weird-Oracle Returns Empty RecordSet!

aitai

MIS

link9

Programmer

aitai

MIS

danielhai

Programmer

Similar threads

Part and Inventory Search

Sponsor