We have front end application which is developed in PB and resides on Citrix server. One of the module in PB application opens a screen which is developed in VBA.
When we upgraded the citrix server and Ms Office on the server to higher version, the module which is developed in VBA is not working and gives the following error.
Run time error – 3706: Provider cannot be found it may not be properly installed.
Here is the detail.
Server Citrix XP release 3
OS Windows 2003 server
MSoffice Excel 2003 (VBA code is developed in Ms Excel 2003 SP1)
Oracle client on server is oracle 9.2.0.4
Oracle oledb 9.2.0.4
MDAC version 2.4
JET version 4.0
Connect string in VBA code is ..
strProviderName = "OraOLEDB.Oracle"
strConnString = "Provider=" & strProviderName & ";" & _
"Data Source=" & strDatabaseName & ";" & _
"User ID=" & strUserName & ";" & _
"Password=" & strPassword
Cnn = strConnString
Cnn.Open
any help would be greatly appreciated.
Thanks.
Run-time error 3706:
silgenfritz
Here's some info from our support engineer:
The issue maybe came from the MDAC. As the office 2003 use MDAC 2.8, but on the client, our ISV use MDAC 2.4. Please try to install MDAC 2.8.
Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/details.aspx FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
-brenda (ISV Buddy Team)
TomG72
Hi,
http://www.orafaq.com/forum/ t=msg&th=38330/0/
Someone in that forum suggests it could be an authentication problem. They are working with ASP.NET but worth a try and see if it works for VBA.
Hope that helps.
http://forums.oracle.com/forums/thread.jspa threadID=313227&tstart=0&messageID=1025237
Earths
Here's the latest from our support engineer:
Now we know that the MDAC is not the cause of the issue. Would you please do some test to confirm that whether the issue is related to the office or the Oracle client
We can write a VB application or VBS script with the same function of the VBA code. If the VB application or VBS script works, we are going to focus on the Office system. Others, we shall focus on the operation system or the oracle database drivers.
-brenda (ISV Buddy Team)
blachmann
Hi ,
We installed MDAC 2.8, but no luck. Still gives the same error.
Thx.