Trying to connect to Oracle

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

May 21st, 2004, 10:16 PM

jperson19468

Registered User

Join Date: May 2004

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

Trying to connect to Oracle

To all, I have two programs one and HTML and the other one is a .asp.
I am running windows xp home addition using Oracle 8I.

When I run the HTML and it calls the .asp program, I just get the Before and After messages.
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? I have never used ODBC stuff before there for I am not sure if I set it up correctly. If I need to show the ODBC stuff I have screen snap shots
I can post.

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="dbtest2.asp" method="post">
<center><p><input id="cmdSubmit" name="cmdSubmit" type= "submit" value="Execute">
<input id="cmdReset" name="cmdReset" type= "reset" value="Reset">
</center>
</form>
</body>
</html>

.asp program:

<%@ Language=VBScript %>
<% option explicit %>
<% response.buffer = True %>
<html>
<head>
<title>Show Results</title>
</head>
<body>

<center><h1><b>Before the Oracle SQL Statements</b></h1></center>

<%
Dim objConn
Dim rs
set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Driver={Microsoft ODBC Driver for Oracle};" &
"ConnectString=xtextron;" & "Uid=system;" & "Pwd=manager"

set rs=objConn.execute("SELECT sysdate FROM dual")

Response.Write "sysdate = " & rs("sysdate") & "<br>"

objConn.Close

%>

<center><h1><b>After the Oracle SQL Statements</b></h1></center>

</body>
</html>

Viewing: Dev Articles Community Forums > Databases > General SQL Development > Trying to connect to Oracle

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump