OLE DB call from ASP on CE 9

[dmurray00]

Hi --

I have a developer who is trying to call an rpt using OLE DB through ASP on a CE 9 box. The call works on one server but not another. The error is :"Microsoft OLE DB Provider for Oracle error '80004005'". Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.

The code piece is : Dim oConn
Dim rs
Dim sConnString
dim sProcString
sConnString = "Provider=MSDAORA.1;Data Source=ffa_d;User ID=ffa_owner;Password=ffa_owner"
response.Write &quot;< br>< input type='text' size='120' value='&quot; & sConnString & &quot;' id='text'1 name='text'1>< br>
response.write &quot;Attempting to open connection.....< br>&quot;set oConn = Server.CreateObject(&quot;adodb.connection&quot
set rs = Server.CreateObject(&quot;adodb.recordset&quot
oConn.Open sConnString
response.write &quot;< br>Connection Succeeded< br>&quot;
End of source

We have tried to uninstall/install Oracle 8.17 client several times without luck.

Any thoughts ???

Thanks. Grant

 

[Turkbear]

Hi,
What happened when you:

'tried to uninstall/install Oracle 8.17 client several times without luck'

Were errors returned...
The Oracle client obviously needs to have been correctly installed in order for the OLE DB to work ( It needs to find the dlls and registry entries it expects).
When installing the 8.1.7 client, was there already another version on that server?


Try this test for the OLE DB connection:

On the server that is having problems, create a text file on the desktop named anything with a .udl extention ( like test.udl)then dbl-click and configure it to use the Oracle OLE data provider ( or the Microsoft one for Oracle) - after configuring it, and testing the connection, open that file in notepad and use the connection string it built.
If it fails to connect it may provide a better error message that will reveal exactly why not.

 

[dmurray00]

Thanks for the reply.

That test worked and generated the following : Provider=MSDAORA.1;User ID=coe_owner;Data Source=coeii_b;Persist Security Info=False.

We used that connect string in the asp and still get the same error.

The connection works locally (within CE and within this test), but does not work from IIS.

Short of testing on a clean server, we are at the end of the road on this box.

Thanks for any suggestions.

Grant

 

[Turkbear]

Hi, One more thought..Be sure the permissions on the Oracle directory structure are open enough so that the account running the pageserver, etc can read the files and execute the binaries.

( Be sure everyone has read access)