Re: ADO ASP

"BBurke" <bburke007_at_mindspring.com> wrote in message news:ak8pf7$93v$1_at_slb7.atl.mindspring.net...
> I'm running 8i on Win2k Advanced Server. I have a few questions about
> connecting to the db for Active Server Pages.
> 1. I can connect using dsn, which is OK, but the integer fields all return
> '0'. Do I need to convert that datatype? Which is the best ODBC connection
> to use?

None! use Oledb, or even better if you are only using Oracle; Oracle Objects for OLE (OO4O).
In any case always explicitly convert datatypes in ASP.

> 2. I would prefer to connect using oledb, but keep getting errors. I
> remember someone telling me I have to install a different Oracle client
> (maybe 2.3.4) to get ADO to work. Has anyone had any luck with that?

Use the 8i client if you can. If you have errors try posting them here or on an ASP forum.

> 3. What drivers would I need for ASP.NET?

A choice of

Oracle Data Provider for DotNet (from technet.oracle.com and a beta) Requires 9.2 client IIRC
Microsoft Oracle Client for DotNet (from MS) Requires at least 8.1.7 client A Third Party wire protocol driver (can't recall the supplier - the driver isn't free)
OLEDB DotNet (Use the oracle OLEDb provider).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************