Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ASP-Oracle9i COnnection Problem.

Posted on 2004-07-30
7
Medium Priority
?
394 Views
Last Modified: 2010-08-05
Hi People.

i have installed Oracle OLEDB Provider but i am unable to connect to the Oracle 9i DB.

My Page Looks like this

<%
     Set objConn = Server.CreateObject("ADODB.Connection")
     
     objConn.Open "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=scott;Password=tiger;Data Source=ned;"  
     
     Set objRs = objConn.Execute("SELECT * FROM EMPLOYEE")

     Response.Write "<table border=1 cellpadding=4>"
     Response.Write "<tr>"

     For I = 0 To objRS.Fields.Count - 1
       Response.Write "<td><b>" & objRS(I).Name & "</b></td>"
     Next

     Response.Write "</tr>"

     Do While Not objRS.EOF
       Response.Write "<tr>"

       For I = 0 To objRS.Fields.Count - 1
         Response.Write "<td>" & objRS(I) & "</td>"
       Next

       Response.Write "</tr>"

       objRS.MoveNext
     Loop

     Response.Write "</table>"

     objRs.Close
     objConn.Close
   %>

Error i get is :
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
0
Comment
Question by:mcse20002000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 2

Author Comment

by:mcse20002000
ID: 11681644
I have MDAC 2.7 Installed
0
 
LVL 1

Expert Comment

by:buff_butler
ID: 11682766
Do you have the orracle TNS names entry set up properly?  Looking at the code it would be called 'ned'?
0
 
LVL 14

Expert Comment

by:aelatik
ID: 11683352
Try changing the provider from OraOLEDB.Oracle.1 to MSDAORA
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 15

Accepted Solution

by:
joeposter649 earned 2000 total points
ID: 11685923
Make sure IUSER_computername has permissions for the folder where the Oracle provider is installed.  
To help troubleshoot this you could also set IIS to run under your id or convert your asp script to vbs and run from the command prompt.
0
 
LVL 15

Expert Comment

by:joeposter649
ID: 11685926
BTW, MSDAORA has limitations such as you can't acess clobs and blobs.
0
 
LVL 15

Expert Comment

by:joeposter649
ID: 11697187
Here's what I mean about the vbs script...

Create test.vbs with the following code then exucte it at the command prompt...

Set rs = CreateObject("ADODB.Recordset")
cnstr = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=scott;Password=tiger;Data Source=ned;"  rs.Open "select sysdate from dual", cnstr, 3, 3
WScript.echo rs("sysdate")
rs.Close
Set rs = Nothing
0
 
LVL 2

Expert Comment

by:cheyennejk
ID: 11898864
I use Oracle 9i and the code below works. (This assumes that Oracle is installed in the default  port. If not, then the port # must be included in the connection string)


Try something like this:


StrConnect="Provider=MSDAORA.1;Data Source=database_scheme;User Id=user_name;PASSWORD=database_password;"


set  objConnection=server.createobject("adodb.connection")
 objConnection.open StrConnect


varSQL = "SELECT DISTINCT USER_ID FROM EMPLOYEE"

set rstemp = objConnection.Execute(varSQL)  


Do While NOT temp_record_set .EOF
 
   Response.Write "<td><b>" &  rstemp (0)  & "</b></td>"
  rstemp.MoveNext
Loop

   rstemp.close
   set rstemp=nothing
         
  objConnection.close
   set objConnection=nothing

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question