To all, I have two programs one and HTML and the other one is a .sql.asp. When I run the HTML and it calls the .sql.asp program, I just get a blank screen. I am not sure if I am connecting to the database correctly or if I am not displaying the results returned by the program correctly? Please help. Thanks
html program:
<html>
<head>
<title>SQL Entry Form</title>
</head>
<body>
<h1 align="center">SQL Entry Form</h1>
<form id="frmSQL" name="frmSQL" action="dbtest1.sql.asp" method="get">
<center><p><input id="cmdSubmit" name="cmdSubmit" type= "submit" value="Execute">
<input id="cmdReset" name="cmdReset" type= "reset" value="Reset">
</center>
</form>
</body>
</html>
.sql.asp program:
<% @language="VBScript" %>
<% option explicit %>
<% response.buffer = true %>
<html>
<head>
<title>Show Results</title>
</head>
<body>
<%
Dim objConn
Dim rs
set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Driver={Microsoft ODBC forOracle};
UID=system;PWD=manager;CONNECTSTRING=xtextron"
set rs=objConn.execute("SELECT sysdate FROM dual")
Response.Write rs("sysdate") & "<br>"
objConn.Close
%>
</body>
</html>
dBforums
>
asp connection to oracle
06-20-03, 12:50
Linear Mode
