Oracle - ASP problem

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_at_chilesat.net Received on Wed May 05 1999 - 13:48:33 CDT