| provider cannot be found.It may not be installed properly [message #312618] |
Wed, 09 April 2008 07:53  |
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 #337009 is a reply to message #335752] |
Tue, 29 July 2008 11:22  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
