Data Type Mismatch Error

[Alex]

help.

Deploying a .Net Application using ADO and MS Access (Jet
4.0) and MDAC 2.8.

Get error: OleDbError .... Data type mismatch in criteria
expression ...

The application works fine in the development machine:
- OS: Windows 2000 Pro
- Jet 4.0 (msjet40.dll Vers. 4.0.7328.0; odbcjt32.dll
Vers. 4.00.6200.0)
- MDAC 2.8

The error occurs in the test machine:
- OS: Windows XP
- Jet 4.0(msjet40.dll Vers. 4.0.4431.0; odbcjt32.dll
Vers. 4.00.6019.0)

Is the error caused by the XP machine older Jet engine??
or something else??

If because of older Jet version, how do i distribute the
newer Jet drivers since MDAC 2.6 and greater do not
contain Jet engine updates anylonger?? I don't believe i
can install/rollback to earlier MDAC's on XP (besides i
wouldn't want to).

I was looking for a Merge Module (.msm) to do this, but to
no avail.

Has anybody encountered this problem?? Am I missing
something?? Does anybody know a workaround?

I would really like for the deployment utility to handle
this. You know, check the version and if older update.

Thanks
Alex

 

[Cor]

Hi Alex,

They have made Ado.net for the Net.

Do you think they did that for fun?

If you think MDAC is better than I think that you have to investigate
yourself how to overcome all problems that are solved with ADO.NET,
otherwise take ADO.NET.

Just my thoughts about this.

Cor

 

[Guest]

-----Original Message-----
Hi Alex,

They have made Ado.net for the Net.

Do you think they did that for fun?

If you think MDAC is better than I think that you have to investigate
yourself how to overcome all problems that are solved with ADO.NET,
otherwise take ADO.NET.

Just my thoughts about this.

Cor

Cor,

Not sure i get your reply, but...

I'm using ADO.NET (was implied in the ".NET application",
but i guess i should have made that clear. apologies).

to quote from an MS article...

"MDAC ...is a collection of DLLs and associated component
resources to support a number of different APIs, including
Open Database Connectivity (ODBC), OLE DB, Microsoft®
ActiveX® Data Objects (ADO), and Microsoft Remote Data
Service (RDS). MDAC installation not only places a large
number of common shared files in various places across the
Microsoft Windows® system drive, MDAC is also responsible
for adding many registry keys to the registry."

....so it's part of my deployment.

Alex

 

[Jay B. Harlow [MVP - Outlook]]

Alex,
I suspect its the older version of Jet.

Do both versions have the same version of MDAC?

Here is the latest version of Jet:

http://support.microsoft.com/default.aspx?scid=kb;[LN];829558

Not sure where there is an MSM, as Windows Update can update Jet 4.0 if its
installed...

Hope this helps
Jay

 

[Alex Ramos]

Thanks Jay,

Yes I believe this too, and have downloaded the latest Jet
Service Packs for the different OS's. However, I was
hoping to have the VS.NET deployment utility be able to
check the machine's OS and Jet version, then do the
correct upgrade if needed.

PS. Was having the same problem distributing MDAC until i
found a wrapper for the SetUp program, but to my chagrin
MS removed the Jet upgrades after MDAC 2.5.

Alex