Re: Newbie question....

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Gary

    Re: Newbie question....

    dreimer <member32419@db forums.comwrote in message news:<3069062.1 057183260@dbfor ums.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.c om 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
Working...