A lot of problems with Oracle and ASP
324277Aug 26 2002 — edited Jun 9 2003Hi, i need to develop a system using ASP and Oracle. I should have started this about 3 weeks ago and I can't in any way connect these 2 technologies.
First, I tried through ODBC and it could not be done.
Next, I tried through OLEDB and when I thought that the problem was found...
set objSessao = Server.CreateObject("OracleInProcServer.XOraSession")
set objConexao = OraSession.DbOpenDatabase("mozart", "jacto_revendas/bolinha",cint(0))
These 2 lines seems to be correct, then I had the error "access to object denied", and I read in some forum that it was because some DLLs of %oracle_home%\bin were without permission. I scanned all of them, and gave full access. OK. Then, an error ASP 0177 (error accessing DLL library) appeared and I could not find solution over the Internet.
And the incredible part is that the error only happens as soon as I start the OS... the second time I try, the script stops and does not show any errors or results... the page keeps processing without an end.
Please, I can't find anyone that can help me... you are my last hope...
thanks
Mozart