Re: Oracle - ASP problem

In article <37309280.34F0EEB5_at_chilesat.net>,   "Eulogio Robles P." <erobles_at_chilesat.net> wrote:
> 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
>

Try to use MS ODBC driver for Oracle v2.573 (part of MDAC 2.0 SP1, if I'm not mistaken)

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 09:12:20 CDT