Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / Interop / July 2004

Tip: Looking for answers? Try searching our database.

Help with PIA's and Office 2000

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Frank Bacon - 28 Jul 2004 02:26 GMT
I wrote an app that transferred data from Excel to Access (Office 2000 on XP
Professional).
I had it in release form and it was working fine.  I installed PIA's to
develop another
App and now I get an error on the first App informing me of an unhandled
Exception of the
type "System.InvalidCastException" in the line where the Excel application
is created.

I've deleted the PIA's according to MS's instructions however I'm still
getting the error.
I need to somehow  correct the system so it can run the first App. Is there
something
else that the PIA install program does? Once PIA's are installed, is Visual
Studio prevented
from creating interop assemblies for Office 2000?
jwallison - 29 Jul 2004 15:23 GMT
> I wrote an app that transferred data from Excel to Access (Office 2000 on XP
> Professional).
[quoted text clipped - 12 lines]
> Studio prevented
> from creating interop assemblies for Office 2000?

===========================================

Was "first app" using the Office XP PIAs? If it was, why would you
(re)install the Microsoft's PIAs for "second app"? Or did you uninstall the
XP PIAs and install the Office 2003 PIAs for "second app"?

What MS instructions for deleting the PIAs were you using? If the PIAs were
"uninstalled", did you verify that they no longer exist in the GAC? If they
were really uninstalled, NEITHER app should work because the assemblies
couldn't be found.

The PIAs ARE the relevant Interop assembly in this case. Why are you asking
if "VS.Net is prevented from creating interop assemblies..." when you should
be using (and your project should be referencing) the MS PIAs in the GAC?

Try using fuslogvw.exe (or debugging) to determine the location that the PIA
is loaded from - if you uninstalled, it shouldn't BE loaded, and if it IS
loaded, fuslogvw will give you the info on location and version.

Rate this thread:







Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.