I have a 'ClickOnce' Windows Forms application that i am trying to deploy. I am getting the message;

the application requires that assembly ADODB Version 7.0.3300.0 be installed in the Global Cache (GAC) first

I have included adoDB.dll into the Application Files for deployment and set it to Publish Status = 'Include'. The deployment includes an file adodb.dll.deploy - but this file says that it is version 7.10.3077.0

Anyone got any thoughts on how to fix this?

regards

Paul

What are you deploying that requires ADODB 7.0...?

My guess is that ADODB has to be installed in the GAC, and can't be included locally. Some things, like the PIA's, are just like that.

If you want to try it and have the versions match just to make sure, you need to find the dll that you want to use. Add it to your project and set "build action" = "none" and "copy to output directory" = "never". Then delete the current reference to adodb and add a new one, pointing not at the one provided in your GAC, but to the one you just added to your project. Set "copy local" to true.

This will ensure that your project is using that version, and that's the one that gets deployed.

If that doesn't work, you're going to need to write a setup & deployment package for it and deploy it as a prerequisite. Let me know; I'd be interested.

RobinDotNet

---

Click here to visit my ClickOnce blog!

Hello Paul,

Thanks Paul for your post and thanks Robin for your effort.

TheADODB Version 7.0.3300.0 is the interop assembly for Microsoft ActiveX Data Objects. It comes with the .NET Fromework SDK, and not the Framework redistributable. To make it installed into GAC, as Robin suggested, we need to use a windows installer package(MSI) to install that assembly to GAC since ClickOnce does not support to install assembly to GAC.

You might also try to specify the assembly's loaction by setting the codebase or theprobing section in the application configuration file.
http://msdn.microsoft.com/en-us/library/yx7xezcf.aspx
http://msdn.microsoft.com/en-us/library/4191fzwb.aspx

Let me know if it helps, if you have any additional question, welcome to post here.

Thanks,
Rong-Chun Zhang
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg@microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hello Paul,

Thanks for your feedback and I am glad the you made it work.

When working with the ReportViewer control, we need to install the distribute reports and the ReportViewer controls as part of your application(by selecting the ReportViewer control prerequisite). See this page for details
http://msdn.microsoft.com/en-us/library/ms251723.aspx

7.0.3300.0 is the version number for the interop assembly for Microsoft ActiveX Data Objects, and 7.10.6070 is the file version for ADODB.dll.

>Why does ClickOnce require ADODB in the GAC?

ClickOnce doesn't require ADODB in the GAC installed in GAC. However, if the application itself use this assembly and is configured to load the assembly from GAC, ADODB needs to be installed into GAC.

Thanks,
Rong-Chun Zhang
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg@microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

What are you deploying that requires ADODB 7.0...?

My guess is that ADODB has to be installed in the GAC, and can't be included locally. Some things, like the PIA's, are just like that.

If you want to try it and have the versions match just to make sure, you need to find the dll that you want to use. Add it to your project and set "build action" = "none" and "copy to output directory" = "never". Then delete the current reference to adodb and add a new one, pointing not at the one provided in your GAC, but to the one you just added to your project. Set "copy local" to true.

This will ensure that your project is using that version, and that's the one that gets deployed.

If that doesn't work, you're going to need to write a setup & deployment package for it and deploy it as a prerequisite. Let me know; I'd be interested.

RobinDotNet

---

Click here to visit my ClickOnce blog!

I am using the ReportViewer module.


Paul

Hello Paul,

Thanks Paul for your post and thanks Robin for your effort.

TheADODB Version 7.0.3300.0 is the interop assembly for Microsoft ActiveX Data Objects. It comes with the .NET Fromework SDK, and not the Framework redistributable. To make it installed into GAC, as Robin suggested, we need to use a windows installer package(MSI) to install that assembly to GAC since ClickOnce does not support to install assembly to GAC.

You might also try to specify the assembly's loaction by setting the codebase or theprobing section in the application configuration file.
http://msdn.microsoft.com/en-us/library/yx7xezcf.aspx
http://msdn.microsoft.com/en-us/library/4191fzwb.aspx

Let me know if it helps, if you have any additional question, welcome to post here.

Thanks,
Rong-Chun Zhang
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg@microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

I'm not sure about this approach - I only have 7.10.3077.0 and 7.10.6070.0 files on my machine.

The deployment manifest states 7.0.3300.0.

The GAC on my development machine states 7.0.3300.0 �although the Product version is 7.10.6070 (in the GAC) �that’s got me confused

Why does ClickOnce require ADODB in the GAC - i thought that ClickOnce got round a lot of this stuff - or are there 'system' essential that must be installed.

regards

Paul

The problem seems to be resolved - after some fiddling i found that the prerequisites included the VS 2008 Report Viewer - i'm guessing that this means that the ReportViewer must be previsously installed before the ClickOnce install starts. I removed this setting, but have the ADODB.DLL set to Publish Status= Include, Download Group = Required, Hash = Include (in the Application files).

regards

Paul

Hello Paul,

Thanks for your feedback and I am glad the you made it work.

When working with the ReportViewer control, we need to install the distribute reports and the ReportViewer controls as part of your application(by selecting the ReportViewer control prerequisite). See this page for details
http://msdn.microsoft.com/en-us/library/ms251723.aspx

7.0.3300.0 is the version number for the interop assembly for Microsoft ActiveX Data Objects, and 7.10.6070 is the file version for ADODB.dll.

>Why does ClickOnce require ADODB in the GAC?

ClickOnce doesn't require ADODB in the GAC installed in GAC. However, if the application itself use this assembly and is configured to load the assembly from GAC, ADODB needs to be installed into GAC.

Thanks,
Rong-Chun Zhang
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg@microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.