Question Could not load type 'ADODB...

[koklimabc]

As per topic, I try run my owned created VB.NET 2010 application on winXP PC and ended up with this error message...

Error:::
"Could not load type 'ADODB.Fields.ToInternalFieldsMarshaler' from Assembly Windowsapplication version=1.0.0.0,Public key Token=null"

Therefore, I try fix this problem by modifying project.vbproj as below

From :
<COMReference Include="ADODB">
<Guid>{EF53050B-882E-4776-B643-EDA472E8E3F2}</Guid>
<VersionMajor>2</VersionMajor>
<VersionMinor>7</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
<Private>True</Private>
</COMReference>

To:

<COMReference Include="ADODB">
<Guid>{EF53050B-882E-4776-B643-EDA472E8E3F2}</Guid>
<VersionMajor>2</VersionMajor>
<VersionMinor>7</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
</COMReference>

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



Then, it will ended up error message as "Could not load file of assembly 'ADODB, version=7.0.3300.0, Culture = neutral, PublicKeyToken=b03f5f7f11d50a3a or
one of its dependencies, cannot find the file specified".

Appreciate thanks to anyone could solve my problems here.

 

[jmcilhinney]

You really shouldn't be using ADO in VB.NET anyway. Unless you must do so for some reason, use ADO.NET instead.

 

[koklimabc]

You are rights, I m still using ADO ver 2.7 which is only working to pass caller's parameters to MSSQL stored procedures.

 

[jmcilhinney]

You are rights, I m still using ADO ver 2.7 which is only working to pass caller's parameters to MSSQL stored procedures.

You should be using the System.Data.SqlClient ADO.NET provider.