The connection works on my local machine but not on our Intranet server. The DSN is set up correctly and it tests fine but when I try to run a page with the connection DSN, it just tells me that the page cannot be found and no mention of a problem with the database.
If I commect the connection information out, the page runs fine.
Is there something in IIS that needs to be set-up differently.
Below is the page I was trying to load:
<%
dim cnnData Object
set cnnData = SERVER.createObject("adodb.Connection")
cnnData.open "DSN=mytime"
RESPONSE.write "HELLO"
%>
Thanks
If I commect the connection information out, the page runs fine.
Is there something in IIS that needs to be set-up differently.
Below is the page I was trying to load:
<%
dim cnnData Object
set cnnData = SERVER.createObject("adodb.Connection")
cnnData.open "DSN=mytime"
RESPONSE.write "HELLO"
%>
Thanks