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

    Unhappy Unanswered: ASP connection to oracle

    Hello there

    ASP connction to oracle database

    could some one advise me please

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    Code:
    OLE DB Provider for Oracle (from Microsoft)
    
    oConn.Open "Provider=msdaora;" & _
                      "Data Source=OracleServer.world;" & _ 
                      "User Id=;" & _
                      "Password=;"
    
    
    OLE DB Provider for Oracle (from Oracle)
    
    For Standard Security
    
    oConn.Open "Provider=OraOLEDB.Oracle;" & _
                      "Data Source=MyOracleDB;" & _ 
                      "User Id=;" & _
                      "Password=;"
    
    For a Trusted Connection
    
    oConn.Open "Provider=OraOLEDB.Oracle;" & _
                      "Data Source=MyOracleDB;" & _ 
                      "User Id=;" & _
                      "Password=;"
    Or
    
    oConn.Open "Provider=OraOLEDB.Oracle;" & _
                      "Data Source=MyOracleDB;" & _ 
                      "OSAuthent=1;"

  3. #3
    Join Date
    Mar 2003
    Location
    Stoke on Trent
    Posts
    8

    Unhappy asp error message

    Hello there

    after using following code

    OLE DB Provider for Oracle (from Microsoft)[/B]

    oConn.Open "Provider=msdaora;" & _
    "Data Source=bsntora;" & _
    "User Id=;" & _
    "Password=;"


    I am getting this error message

    Microsoft OLE DB provider for oracle (0*80004005)
    ora-12514: TNS:listener could not resolve SERVICES_Name given
    in connection descriptor

    I am working on uni server

  4. #4
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    nas your going to have to ask uni to let you play with the settings. I think most of uni computers are not set up to allow you to connect like this.

    Go and ask your FYP tutor, he will be able to tell you what to do. But your cutting it fine leaving it this late: its due friday!

Posting Permissions

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