Oracle OleDb problem
Shawn Emery
I am getting the follow error in an ASP page IIS 5 WIN 2K SP3:
The version of Oracle Client is 8.1.7.
The version of MDAC is 2.7.
Provider=OraOLEDB.Oracle;Data Source=...;User ID=...;Password=...;
VBScript Errors Occured:
Error Number=3706
Error Descr.=Provider cannot be found. It may not be properly installed.
Help Context=1240655
Source=Microsoft VBScript runtime error
Roy Fine
i see this message quite often -- but it is when i mispelled the name of the
provider or forgot to install the client software on the machine running where
the connection.open method is running.
the provider=OraOLEDB.Oracle is correct for the Oracle OLEDB provider. can you
make sure that the Oracle client software is really installed on the web
server - and that the spelling of the Provider= text is exact...
if all that fails, include the asp code where you do the open, and we'll look
further into the situation...
regards
roy fine
"Shawn Emery" <Cecil....@Seagate.com> wrote in message
news:uGSMZnLYCHA.2384@tkmsftngp10...
Steve
Provider=MSDAORA
>.
>
Shawn Emery
I've tried re-installing the Oracle 8.1.7 client. All the OLE Dlls appear
to be there, but I still get the same error. I also installed the .Net SDK
because it is on our development server which works.
Here's the script that fails;
Set Oracon = CreateObject("ADODB.Connection")
Oracon.ConnectionString = "Provider=OraOLEDB.Oracle;" & _
"Data Source=...;" & _
"User ID=...;" & _
"Password=...;"
'Response.Write(Oracon.ConnectionString)
' Response.end
on error resume next
Oracon.Open
If err.number > 0 Then
Response.write("<p>" & "VBScript Errors Occured:" & "<P>")
Response.write("Error Number=" & err.number & "<P>")
Response.write("Error Descr.=" & err.description & "<P>")
Response.write("Help Context=" & err.helpcontext & "<P>")
Response.write("Help Path=" & err.helppath & "<P>")
Response.write("Native Error=" & err.nativeerror & "<P>")
Response.write("Source=" & err.source & "<P>")
Response.write("SQLState=" & err.sqlstate & "<P>")
Else
Response.write("No VBScript Errors Occured" & "<P>")
End If
response.end
"Roy Fine" <rlf...@sfa2000.com> wrote in message
news:urMxIFYYCHA.2440@tkmsftngp08...
Roy Fine
The code below that you provided LOOKS GOOD to me..
'********************************
Set Oracon = CreateObject("ADODB.Connection")
Oracon.ConnectionString = "Provider=OraOLEDB.Oracle;" & _
"Data Source=...;" & _
"User ID=...;" & _
"Password=...;"
Oracon.Open
'********************************
It looks like this is running on a IIS Web Server. Just to be sure -- did you
install and configure Oracle 8i client software on the IIS Web Server machine
(it doesn't help if its on the client workstation)..
Just to be sure, can you get access to the Web Server? If so, put the above
snip in a notepad and save it as test.txt on the desktop. then rename the file
to test.vbs. then double click it and see if it runs. if it does, then Oracle
is installed and configured - and we can move on from there.
If you have the Oracle client installed and configured and you are still
experiencing problems, have a look at the permissions on the directory where you
installed the Oracle Client software - usually ORACLE_HOME environment variable
and registry key - and typically "C:\Oracle\Ora8i". if you anonymous web user
client account does not have at least read/execute permissions there, you will
need to make some adjustments...
regards
roy fine
"Shawn Emery" <Cecil....@Seagate.com> wrote in message
news:OUx1nM$aCHA.2492@tkmsftngp12...
Shawn Emery
You were right. The anonymous web user client account did not have
read/execute permissions on C:\Oracle\Ora8i. I made the change, and
everything started to work.
Thanks for all you help,
Shawn
"Roy Fine" <rlf...@sfa2000.com> wrote in message
news:#DeIwtCbCHA.460@tkmsftngp10...
Roy Fine
my pleasure.
all the best
roy
"Shawn Emery" <Cecil....@Seagate.com> wrote in message
news:ecE7E#gbCHA.2384@tkmsftngp08...
simpson
Having same problem. Tried to follow suggestion didn't work.
I'm a running web server running:
W2K/SP3 with IIS5
MDAC 2.7
I also installed on the web server the following Oracle components:
Oracle 9i Client 9.2.0.1.0
Oracle Provider OLE DB 9.2.0.2.0
Oracle Objects for OLE 9.2.0.4.5
However, I am getting error below:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/scripts/sec.asp, line 21
Have given anonymous web user account on the server read/execute
permissions to the following directories and subdirectories:
C:\Program Files\Common Files
C:\Program Files\Oracle
D:\Oracle\Ora92
Here's where I try to make the connection in my code:
Set OraConn = Server.CreateObject("ADODB.Connection")
Oraconn.ConnectionString = "Provider=OraOLEDB.Oracle;Data
Source=oraDB;User ID=user1;Password=password;"
OraConn.Open
oraCommandStr = "SELECT GUID FROM SECURITY_TABLE WHERE GUID = 'user2'"
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS = OraConn.Execute(OraCommandStr)
Response.Write objRS.Fields("GUID")
Does anyone know what I may be doing wrong or have not checked?
thanks
simpson
--
Posted via http://dbforums.com
Bob Beauchemin
1. Make a new text document on the desktop. Rename it so that the suffix is
not ".txt" but ".udl". The icon should change. This only works when "hide
suffixes for known file types" is turned off from the Options in Windows
Explorer.
2. Double-click the icon and a message box with a list of OLE DB providers
should come up. If the Oracle Provider for OLE DB does not appear in the
list (the Provider tab), its not correctly installed.
3. If it does appear in the list, select it, then click on the Connection
tab. Key in the name of an Oracle instance (from your TNSNAMES.ORA), a user
id and a password and hit the "Test Connection" button.
4. If "Test Connection" works, click OK, which will dismiss the dialog. Then
right-click, open the .UDL file with Notepad. (It must be Notepad or an
editor that understands Unicode). Everything after line 1 is the connection
string, which you can cut and paste into your program.
Bob Beauchemin
http://staff.develop.com/bobb
"simpson" <mem...@dbforums.com> wrote in message
news:2049258.1...@dbforums.com...
simpson
Bob-
I tried your suggestion. The test connection was successful. But it
still gives provider error.
Bob Beauchemin
program? Are you attempting to access the database while running as a
different user that you are using on the desktop? An NT Service or ASP.NET
perhaps? If so, make sure the user running the service or the ASP.NET user
has appropriate access to $ORACLE_HOME directory and the directory where the
provider is installed.
Bob Beauchemin
http://staff.develop.com/bobb
"simpson" <mem...@dbforums.com> wrote in message
news:2051852.1...@dbforums.com...
simpson
Yes, i cut and pasted the connection string into the code.
I am logged on the web server as admininistrator. That account has full
access to all directories.
The web site security is set as follows:
Allow Anonymous and Integrate NT Authentication are both checked.
The IUSR account for the web server has read/execute, list access to all
oracle directories and subdirectories.
And I am not using ASP.NET.
Could there be a compatibility issue with the oracle database version
and the oracle client version?
The oracle database is version 9.0.1.3.0
The oracle client is 9.2.0.1.0
Bob Beauchemin
I'd bet on your IUSR account not having the same privileges that
administrator has. As a (very temporary) test, you might try running the
anonymous account as the desktop user, rather than IUSR account. If it
works, you have a handle on the problem.
Bob Beauchemin
http://staff.develop.com/bobb
"simpson" <mem...@dbforums.com> wrote in message
news:2052314.1...@dbforums.com...
simpson
Ok, what i did was to uncheck Allow Anonymous Access for the web site.
Now I'm getting a pass provider error. So I think it is definitely
linked to directory permissions.
thanks for the help.