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?