This content has been marked as final. Show 2 replies
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.
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 (18.104.22.168.0 64bit) and the Oraoledb driver, only available in 32 bit version. So I tried to download the ODAC 22.214.171.124.1 32bit, but I was unable to get it work. What should I do? Is there an alternative driver to connect to oracle?