Re: Newbie question....

dreimer <member32419_at_dbforums.com> wrote in message news:<3069062.1057183260_at_dbforums.com>...
> Please bear with the newbie questions I am about to ask...
>
> I have an Oracle 8.1.7.3.0 on an HP-UX box, and am familiar with running
> what I need to run from the SQL*Plus command line....
>
> What I would LIKE to do (please don't critisize)is write a small select
> query for use in an ASP page running on a Win2K server. I have checked
> the sqlnet.ora and tnsnames.ora files, and have run sqlplus from the
> windows box, and am able to get what I need, but have no idea how to get
> the connection to work in an ASP page, or get the query to work....I
> have tried using tools like Dreamweaver, but it seems to not like the
> drivers...
>
> Any short HOWTO's on basic VB script or ASP connections to Oracle? Or do
> I need to buy a book and start reading?

Dreimer,

you should be using OraOLEDB(Oracle provider for OLE DB). Go tahiti.oracle.com and search for it.

Ask your DBA for a userid on the database with proper privileges and you need to install OraOLEDB on your IIS server and then put ADO code in your ASP.

Cheers,

Gary Received on Thu Jul 03 2003 - 04:09:42 CEST