This topic is locked

ASP to Oracle DB

9/9/2006 8:35:24 PM
ASPRunnerPro General questions
C
chris author

I created this front end on my local pc and connected to the oracle 10g db over the internet using the oracle odbc driver. I am now trying to get it on the server that it will reside. I copied the directory from my local pc to the server and specified the directory in IIS.

I have checked various setting for permissions on IIS and SBS 2003, environment, etc. I have generated a different db using your product and moved it in the same fashion, but that is using MS Access db not oracle.

I can run the localhost version and it works fine.

Depending on what I select from the login.asp page I get different errors:
When I select Submit:

The page cannot be displayed

There is a problem with the page you are trying to reach and it cannot be displayed...

HTTP 500 - Internal server error

Internet Explorer
When I select Register:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/register.asp, line 21
When I select forgot password:

ASP error happened

Error number -2147467259

Error description [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Search ASPRunner support forum for more info on this error.
this is my dbconnection.asp as found in the include directory(I have blocked the UID and password for security reasons):

<%

strConnection = "DRIVER={Oracle in OraClient10g_home1};SERVER=OBSERVE;UID=***;PWD=**;DBQ=OBSERVE;DBA=W;APA=

T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessf

ul;NUM=NLS;DPM=F;MTS=T;MDI=Me;CSR=F;FWC=F;FBS=60000;TLO=O;"

%>
What I am not doing to get this running?

Thanks in advance.

Chris.
Update: it was OraClient10g_home1(local pc) needs to be OraDb10g_home1(on server)

How do I make that change other than manually changing the dbconnection.asp pages in the include directory?

Sergey Kornilov admin 9/11/2006

You can setup a new Oracle homw on your local PC with the same name as it created on the server.
Also you can create an ODBC DSN on both local PC and on the Server. In this case there is nothing to change in dbconnection.asp file - just move created application the server.