| provider cannot be found.It may not be installed properly [message #312618] |
Wed, 09 April 2008 07:53  |
nishanizam
Messages: 2
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  |
anacedent
Messages: 5022
Registered: July 2005
Location: surf meets turf in 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 |
nishanizam
Messages: 2
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 |
anacedent
Messages: 5022
Registered: July 2005
Location: surf meets turf in SoCal |
Senior Member |
|
|
GOOGLE is your friend, but only if you use it.
IMO, it is a WINDOWS issue; pure & simple.
|
|
|
]
Members
Search
Help
Register
Login
Home
