Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Jul 2002
    Location
    Athens, Greece
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    connecting to oracle 8i via ASP

    howdy ho


    can somebody tell me what is the easiest way to connect to an oracle database? via asp? thanx!!



    PS:um, did this site change in the last 2 months? my account was disabled and the layout looks different but im sure it was this site!..

  • #2
    New Coder
    Join Date
    Jun 2002
    Location
    Pilipinas
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hi

    you connect to oracle just like you connect to any db in asp. the connection string to use is:

    Provider=MSDAORA.1;Data Source=path to database on server

  • #3
    New to the CF scene
    Join Date
    Jul 2002
    Location
    Athens, Greece
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    um, ok, suppose im stupid, just supose, so what exaclty do i have to write in my file in the place of the folowing code wich works with access to connect to my oracle 8idatabase??

    <%
    strconn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.mappath("db2.mdb")
    set conn=server.createobject("adodb.connection")
    Conn.open strconn
    %>

  • #4
    New Coder
    Join Date
    Jun 2002
    Location
    Pilipinas
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts
    okay

    using your existing setup:

    <%
    strconn="Provider=MSDAORA.1;Data Source=dbName"
    set conn=server.createobject("adodb.connection")
    Conn.open strconn
    %>

    that should do it, unless you have access restrictions built into the db, in which case you would need to pass (not sure about the exact syntax) uid= and pwd= parameters as well.

    one other thing you can do is to create a file DSN that connects to an oracle db on your localhost, open the DSN file, and use the connection string generated on that file in your setup above.


  •  

    Posting Permissions

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