Xref: alice comp.databases.oracle.misc:30603
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!iad-peer.news.verio.net!nuq-peer.news.verio.net!uunet!lax.uu.net!ffx.uu.net!in5.uu.net!news.chilesat.net!not-for-mail
From: "Eulogio Robles P." <erobles@chilesat.net>
Newsgroups: comp.databases.oracle.misc,microsoft.public.windowsnt.misc
Subject: Oracle - ASP problem
Date: Wed, 05 May 1999 14:48:33 -0400
Organization: Chilesat
Lines: 32
Message-ID: <37309280.34F0EEB5@chilesat.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: ancud.chilesat.net			 925930112 5437 200.9.151.131 (5 May 1999 18:48:32 GMT)
X-Complaints-To: usenet@chilesat.net
NNTP-Posting-Date: 5 May 1999 18:48:32 GMT
X-Mailer: Mozilla 4.51 [en] (Win95; I)
X-Accept-Language: en

Can anyone tell me why this code works fine with
an ASP page using a
SQL Server 6.5 DSN data source, but if I change to
a Oracle 8.0.5
DSN datasource, it displays no data (and no error
message)? :

myDSN="DSN=marte;uid=customers;pwd=secret.001"
set  dset=server.createobject("adodb.recordset")
mySQL="select ac_id,  ac_name  from tblAccounts"
dset.open mySQL, myDSN
response.write "records : " & dset.recordcount
DO  while not dset.eof
 response.write dset("ac_name") & "<br>"
   dset.movenext
LOOP
dset.close
set dset=nothing

With Oracle, all the output I get is "records =
-1", and I
know for sure the table is populated. If I move
the query
to a IDC - HTX file (using Oracle), it works just
fine.
I'm using NT 4.0, SP4, Option Pack 4, IIS 4.

Thanks in advance,

E. Robles
erobles@chilesat.net