Solved

ASP-Oracle9i COnnection Problem.

Posted on 2004-07-30
7
391 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 15

Accepted Solution

by:
joeposter649 earned 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ASP CDO - Limiting Connections 3 65
return false must be hit after calling certain command 10 43
send email part1 9 40
Can't select treeview node from iframe 2 37
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 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