Install ADO Problem

23 Feb 2006 4:56 PM

Vayse

I published my app in Visual Studio 2005. I'm getting a problem installing
on one PC. During the install, the following error appears:
"Unable to run or install the application. The application requires that
assembly ADODB 7.0.3300.0 be installed in the Global Assembly Cache (GAC)
first."

The VB6 install used to give you a choice of adding references. The VS 2005
Publish doesn't give any options to include references. What should I be do?

thanks
Vayse

24 Feb 2006 8:50 AM

Gary Chang[MSFT]

Hi Vayse,

>The VB6 install used to give you a choice of adding
>references. The VS 2005 Publish doesn't give any
>options to include references. What should I be do?

There is an option--"Application Files..." in your VS2005 project's Publish
property page used to configure the required assembly and prerequisite of
your Click Once project, but I am afraid it could not be used to install a
GAC utility(it should be configured as "Prerequisite(Auto)"), this is a
limitation of the ClickOnce Deployment.

In this point, one possible workaround is to specify that referenced GAC
assembly's "Copy Local" property to "True", then the that assembly should
be packed into your Click Once installation automatically.

But unfortunately, since ADODB.DLL is a Primary Interop Assembly (PIA), it
is a shared component. As such, it must be deployed into the Global
Assembly Cache (GAC). So even when it is present on the machine in some
other folder, any application that uses it will still not find it.

In this scenario, you may need your client to install the related PIA if
his/her system hasn't installed the ADODB.DLL in its GAC:

Office 2003 Update: Redistributable Primary Interop Assemblies is available
for download
http://support.microsoft.com/?scid=kb;en-us;897646&spid=2514&sid=global

By the way, you can use another approach to distribute your application to
workaround this issue:
Use a VS2005 setup project to generate an installation package for your
application with the VS2005 setup project you can install a GAC utility to
the target machine. If you have any problem about how to do this with
VS2005 setup project, please let me know, I will be happy to be of further
assistance.

Thanks!

Best regards,

Gary Chang
Microsoft Community Support
======================================================
PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
AM PST, February 14, 2006. Please complete a re-registration process by
entering the secure code mmpng06 when prompted. Once you have entered the
secure code mmpng06, you will be able to update your profile and access the
partner newsgroups.
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

27 Feb 2006 11:37 AM

Vayse

Can anyone help me out?

Show quoteHide quote

"Vayse" <vayse@nospam.nospam> wrote in message
news:e9NyXoJOGHA.2268@TK2MSFTNGP09.phx.gbl...
>I published my app in Visual Studio 2005. I'm getting a problem installing
>on one PC. During the install, the following error appears:
> "Unable to run or install the application. The application requires that
> assembly ADODB 7.0.3300.0 be installed in the Global Assembly Cache (GAC)
> first."
>
> The VB6 install used to give you a choice of adding references. The VS
> 2005 Publish doesn't give any options to include references. What should I
> be do?
>
> thanks
> Vayse
>
>