Solved

ASP-Oracle9i COnnection Problem.

Posted on 2004-07-30
7
383 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
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video discusses moving either the default database or any database to a new volume.

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now