Hi Oracle Gurus!!
Before I proceed, as per the moderators request, I would like to mention that I have already taken a look at the other threads pertaining to a similar issue which I am having and have not found a feasible answer. I would like to apologize if there is an answer out there (I've looked at quite a few threads).
So here is the situation:
Currently, I have been using Oracle Toad from Quest Software to connect to the production database to run all my sql queries without a problem. My objective now is that I would like to query all the sql via an ASP page instead of Oracle Toad.
After creating my asp page in C:\Inetpub\wwwroot with the following code:
<html>
<head>
<title> Time Check </title>
</head>
<body>
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection") ' This line creates the ActiveX Database Object
objConn.ConnectionString = "Data Source=GTMSP;User Id=PLATEAU;Password=abcde;Integrated Security=no"
objConn.Open 'This commands the database to open
%>
</body>
</html>
I receive the following error when I run my page from http://localhost/asptestpa.asp -
------------------------------------------------------------------------------------------------------------------
Error Type:
Microsoft OLE DB Service Components (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/asptestpa.asp, line 20
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Guidant; .NET CLR 1.0.3705; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)
Page:
GET /asptestpa.asp
----------------------------------------------------------------------------------------------------------------
Here are the configurations I have made on my machine:
(1) I went to the Microsoft ODBC Administrator and added a DSN with the following attributes under the User DSN and System DSN tab :
DataSource Name: GTMSP
Description: GTMS Production
Username: PLATEAU
Server: GTMSP.world
(2) Under the file DSN tab in Microsoft ODBC Adminstrator, I included GTMSP.dsn
(3) I know I have Ora9 components because I am able to successfully connect via Oracle Toad (thats how I do all my queries ex. Select * from pa_student...) using the following properties in Oracle Toad:
Database: GTMSP.WORLD
User/Schema: PAGGARWA
PASSWORD: *******
Connect Using Ora9
Note: I am also able to successfully connect using SQL* Plus
Note2: Initially I had the windows components error message (Oracle 0x80004005) but after speaking to the developers on our team, they mentioned that I already have the windows components.
Note3: I did install IIS on my machine and our developers told me that you can easily connect using .asp pages to the database from my machine. I do not need to have access on the production database to connect (which makes sense)
Final note: From one of the other threads, I took a look at http://www.connectionstrings.com for assistance for which my asp code is coded/constructed the way it is.
Any assistance is GREATLY appreciated. I have a report for senior management to turn in very shortly and without being able to connect to the database I can't query!!
I look forward to hearing from you soon. I'll be checking this site often for responses. Thank you