Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Location
    Stoke on Trent
    Posts
    8

    Unanswered: asp connection to oracle

    Hello there

    Could some give me advice please, I have my own pc and I install orcale in it, I want to make asp connection to orcale databasse, what I need to install in my pc.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Perhaps check this out:

    Able Consulting - ADO Connection String Samples
    http://www.able-consulting.com/ADO_Conn.htm
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    you don't really need to install anything extra on top of the Oracle installation.

    Just create a DSN on the ODBC control box thing (on control panel/administrative tools depending on what version of windows you run). Make sure you use the Oracle ODBC driver, which will be installed at that time.

    Then its just as simple as connecting to an Access database...! Its EASY!

  4. #4
    Join Date
    May 2004
    Posts
    2

    Trying to connect to oracle

    To all, I have two programs one and HTML and the other one is a .sql.asp. When I run the HTML and it calls the .sql.asp program, I just get a blank screen. I am not sure if I am connecting to the database correctly or if I am not displaying the results returned by the program correctly? Please help. Thanks

    html program:

    <html>
    <head>
    <title>SQL Entry Form</title>
    </head>
    <body>
    <h1 align="center">SQL Entry Form</h1>

    <form id="frmSQL" name="frmSQL" action="dbtest1.sql.asp" method="get">
    <center><p><input id="cmdSubmit" name="cmdSubmit" type= "submit" value="Execute">
    <input id="cmdReset" name="cmdReset" type= "reset" value="Reset">
    </center>
    </form>
    </body>
    </html>

    .sql.asp program:

    <% @language="VBScript" %>
    <% option explicit %>
    <% response.buffer = true %>
    <html>
    <head>
    <title>Show Results</title>
    </head>
    <body>

    <%

    Dim objConn
    Dim rs
    set objConn = Server.CreateObject("ADODB.Connection")
    objConn.Open "Driver={Microsoft ODBC forOracle};
    UID=system;PWD=manager;CONNECTSTRING=xtextron"

    set rs=objConn.execute("SELECT sysdate FROM dual")

    Response.Write rs("sysdate") & "<br>"

    objConn.Close

    %>
    </body>
    </html>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •