error when deploying

[xxentric]

I have a finished app that when built runs fine on my PC ... its when i try to use the app on another PC in the building here it doesnt seem to be working right at all and im also getting an error

Could not load type 'ADODB.FieldsToInternalFieldsMarshaler' from assembly 'FC APP, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'

[xxentric]

ok... the program only seems to run on a PC that has a version of vb.net studio on it... the version doesnt seem to matter though... why would that be?

[ForumAccount]

Check out the workaround here. The problem is basically that the application is unable to find and reference the ADODB.dll.

[xxentric]

I did actually see that post....
i guess im not exactly sure what it means.

I just declare it like this

    Public myRecSet As New ADODB.Recordset
    Public conn As ADODB.Connection
    Public comm As ADODB.Command

and then when i use it, it works.... im not sure how else to do it. and i haven't ever done anything with that .dll file

[ForumAccount]

Go to the Debug and Release folders. Is there an ADODB.dll file there?

[xxentric]

no... no dll file there

debug folder has 5 files
APP.exe
APP.pdb
APP.vshost.exe
APP.vshost.exe.manifest
APP.xml


and the release folder has 3
APP.exe
APP.pdb
APP.xml

[ForumAccount]

Ok, in your references, is there one that says ADODB?

[Hack]

Why are you using ADO in a VB.NET project instead of using ADO.NET?

[xxentric]

actually no.. there is no ADODB there either...

to HACK ... well... honestly... like it happens to other people at work as well im sure, out of the blue i was told "make us an app that can do this" ... and i thought, wow, i better learn a programming language. But really it was more like, make this program now and then learn later...

so unfortunately alot of my code is snippets and examples that may or may not be from .net code.... and i fudge it to work for what i need.

i am sure if any actual programmer would look at my ton of jumbled ridiculous code, he would just delete it and start me over from scratch.

im guessing it will end up being alot harder for me to learn the RIGHT way now.

[apuges]

I had the same problem and I have solved it just now!!

- I created a new installation project with visual Studio (see png attached)
- Then on the application folder I added an embedded .net component, adodb.
- Selecting the adodb.dll, on the properties tab I changed the property Register to vsdraCOMRelativePath.
- Now I generate again the exe and the msi
- Install the package on the other pc

And that just worked for me!
Hope this helps you! Good luck!!!

[Kuromuro]

Hi!

--- Could not load type 'ADODB.FieldsToInternalFieldsMarshaler' from assembly ---

Solution is quite simple:

You have to 'manually' modify your .vbproj file and

' change:

<Reference Include="adodb, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<SpecificVersion>False</SpecificVersion>
<EmbedInteropTypes>True</EmbedInteropTypes>
<HintPath>..\..\..\Program Files\Microsoft.NET\Primary Interop Assemblies\adodb.dll</HintPath>
</Reference>

' with:

<Reference Include="adodb, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
<SpecificVersion>False</SpecificVersion>
<HintPath>..\..\..\Program Files\Microsoft.NET\Primary Interop Assemblies\adodb.dll</HintPath>
<Private>True</Private>
</Reference>

Sincerely Yours, Kuromuro