4 Replies Latest reply on Feb 9, 2006 9:16 PM by 489621

    ASP Connection Oracle and ASp error during connect

    422674
      Hi @ all,

      the problem is to get a connect with these function that is the connection for every asp site

      With these function I call the connection from each asp site..

      <%
      Function GetDBConnection()

      Dim objConnection

      Set objConnection = Server.CreateObject("ADODB.Connection")

      With objConnection
      .ConnectionString = "Provider=MSDAORA; " & _
      "Data Source=instance_name; " & _
      "User ID=hr; Password=hr;"

      .Open

      End With

      Set GetDBConnection = objConnection

      End Function
      %>

      When I call the default.asp occurs these error


      Microsoft OLE DB Provider for Oracle error '80004005'

      Oracle error occurred, but error message could not be retrieved from Oracle.

      /includes/ADOFunctions_inc.asp, line 13


      I use the global.asa to refernce the correct *.dll

      C:\Program Files\Common Files\System\ado\msado15.dll

      So I am not sure is it still a problem with the connection or withe the setting
      of the folders "security" privileges ?

      Has anyone an idea to solve the connection problem...

      Regards
      Marcel