Forum Stats

  • 3,816,055 Users
  • 2,259,134 Discussions


Server Error 500 with windows 7

676094 Member Posts: 30
edited Dec 15, 2011 3:10AM in Oracle Provider for OLE DB
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


  • 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 ( 64bit) and the Oraoledb driver, only available in 32 bit version. So I tried to download the ODAC 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.