Forum Stats

  • 3,816,055 Users
  • 2,259,134 Discussions
  • 7,893,374 Comments

Discussions

Server Error 500 with windows 7

676094
676094 Member Posts: 30
edited Dec 15, 2011 3:10AM in Oracle Provider for OLE DB
hi,
Im trying to migrate a web site from Windows XP to windows 7. My web site worked on XP, but when I try to run it in W7, I cant connect to my oracle Database!
This is the connection string (perfectly working in XP)

<%
Dim conOracle, OraSession
Dim NRigheLista, OraDatabase
Dim BgColor, SocDataBase


Set conOracle = Server.CreateObject("ADODB.connection")

ConOracle.Open ="Provider=ORAOLEDB.Oracle;Data Source=MYDB;User ID=usr;Password=password;" (this comes into error!)

set OraSession = server.createobject("OracleInProcServer.XOraSession")
set OraDatabase = OraSession.dbOpenDatabase("MYDB","usr/password",cint(0))

%>

Now Im getting the 500 - Internal Server Error. But I know MYDB is well installed and I can reach it via SQLPlus. Can someone help me? thank you

Answers

  • Jim Smith
    Jim Smith Member Posts: 2,873 Silver Trophy
    Server error 500 is pretty meaningless. You need to find out what the error number/message from your code is. See if any more detail is in the webserver logs. Or try to reproduce it with a standalone piece of VB which prints out the error.
  • 676094
    676094 Member Posts: 30
    hi Jim,
    the error code is "429: ActiveX component can't create object", caused by this command line

    set OraSession = server.createobject("OracleInProcServer.XOraSession")

    I know it may depend on a mismatch between Oracle server (11.2.0.1.0 64bit) and the Oraoledb driver, only available in 32 bit version. So I tried to download the ODAC 11.2.0.2.1 32bit, but I was unable to get it work. What should I do? Is there an alternative driver to connect to oracle?
This discussion has been closed.