Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » provider cannot be found.It may not be installed properly (Oracle 10g)
provider cannot be found.It may not be installed properly [message #312618] Wed, 09 April 2008 07:53 Go to next message
nishanizam
Messages: 3
Registered: April 2008
Junior Member
Hi All,

I am running into this error "Provider cannot be found.It may not be installed properly" while I am trying to connect to Oracle from Excel VBA.

I had installed both Oracle 10.1 and Oracle 10.2 in the same machine and is working with .NET applications.My .NET applications works fine.But when I try to connect from within the EXCEL VBA,it gives me this error.

This is my oracle client folder structure

Oracle 10.1 -> C:\Program Files\Oracle\product\10.1.0\Client_1
Oracle 10.2 client -> C:\Program Files\Oracle\product\10.2.0\Client_2
Oracle 10.2 ODAC -> C:\Program Files\Oracle\product\10.2.0\Client_1

As part of working around this error,I have uninstalled my 10.2 and now I just have 10.1 in my local machine.

This is the code snippet where the error occurs in VBA

Set Conn = New ADODB.Connection
Conn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=datasource;User ID=userid;Password=pwd;CacheType=Memory"
Conn.ConnectionTimeout = 60
Conn.Open

I would really appreciate any help !!

Thanks much!
N
Re: provider cannot be found.It may not be installed properly [message #312734 is a reply to message #312618] Wed, 09 April 2008 12:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am running into this error "Provider cannot be found.It may not be installed properly"
If this is an error response from Windows, then the fix is a change to Windows & this is likely the wrong forum.

We could assist if/when you get Oracle error(s) [ORA-?????]
Re: provider cannot be found.It may not be installed properly [message #312777 is a reply to message #312734] Wed, 09 April 2008 13:51 Go to previous messageGo to next message
nishanizam
Messages: 3
Registered: April 2008
Junior Member
I am trying to connect to Oracle database through Excel VBA and I get this error.So this is an oracle error and not a Windows error I believe.
Re: provider cannot be found.It may not be installed properly [message #312800 is a reply to message #312618] Wed, 09 April 2008 15:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
GOOGLE is your friend, but only if you use it.
IMO, it is a WINDOWS issue; pure & simple.
Re: provider cannot be found.It may not be installed properly [message #335752 is a reply to message #312618] Wed, 23 July 2008 09:51 Go to previous messageGo to next message
nishanizam
Messages: 3
Registered: April 2008
Junior Member
Hi anacedent

May I know why u said the "provider error" is Windows issue?

Thanks
N
Re: provider cannot be found.It may not be installed properly [message #337009 is a reply to message #335752] Tue, 29 July 2008 11:22 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Is "datasource" and Oracle TNSnames database alias - or an ODBC connection name?

Try searching metalink (login required).

ODBC is sensitive to your registry settings (HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\...) and last time I had something like this - the order of your Oracle homes in your PATH too. My 10.2 client has a bunch of OraOLEDB related info in the readme files.

Previous Topic: How to access pdf file from server
Next Topic: Probkem With Different jsp
Goto Forum:
  


Current Time: Fri Mar 29 03:37:31 CDT 2024