Hi,
There's too much traffic in the General category, so I thought I'd repost here in efforts to be seen.
To resummarize, here is my current setup:
Windows 2000
ASP via IIS 5.0
Oracle 8.1.7 Enterprise Edition (downloaded)
Oracle Provider for OLE DB installed, Microsoft OLE DB (MSDAORA) installed, Oracle ODBC driver 8.01.07 installed, Microsoft ODBC for Oracle 2.573 installed
My problem is when connecting to the Oracle database via any of the aforementioned drivers using the appropriate connection strings, it won't work. When I try loading the page, the only thing it does is hang, but never brings an error message nor resolves.
My IIS user has been given read/execute permissions on my ORACLE_HOME directory. And yes, I can connect to the database via SQL Plus. I can also test the service through Net8 Configuration Assistant (Easy Config), and it works. I can also connect to Oracle from Powerbuilder via ODBC.
A sample test ASP page is shown below, hopefully providing all I need to connect via OLE DB (datasource, username, and password modified):
<% Option Explicit %>
<HTML>
<HEAD>
<TITLE>Oracle Data Access</TITLE>
</HEAD>
<BODY>
<CENTER>
<H2>
Oracle Data Access<BR>
Using 'OLE DB Provider for Oracle'<BR>
SysDate and User Name Demo<BR>
</H2>
</CENTER>
<%
Dim objConnection
Dim objRecordset
Set objConnection = Server.CreateObject("ADODB.Connection")
With objConnection
.ConnectionString = "Provider=OraOLEDB.Oracle;" & _
"Data Source=<testdatasource>;" & _
"User Id=<userid>;" & _
"Password=<password>"
.Open
Response.Write "ADO Provider=" & .Provider & "<BR>"
Set objRecordset = .Execute("SELECT sysdate, user FROM dual")
End With
Response.Write "System Date=" & objRecordset.Fields("sysdate") & "<BR>" & _
"User=" & objRecordset("user")
Set objConnection = Nothing
Set objRecordset = Nothing
%>
</BODY>
</HTML>
----------
I hope someone can help me figure out the problem. I'm almost ready to use Powerbuilder to build my application, but I'd rather solve my ASP problem instead.
Thanks,
Willis