Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 708
  • Last Modified:

ODBC - Invalid Argument

I am using several recordsets in an application using VC++ and Access7 ODBC.  Each one is filtered according to user input from a dialog box.  The data is then retrieved and processed.  For example I preform a filtered query on recordset X.  For each record in X a filtered query is executed on Y.  Sometimes I get an Invalid Arguement message as a result of a  the following exceptions

Invalid argument.
First-chance exception in Mrgis.exe (ODBCCR32.DLL): 0xE06D7363: Microsoft C++ Exception.
State:S1093,Native:-1003,Origin:[Microsoft][ODBC Microsoft Access 7.0 Driver]

First-chance exception in Mrgis.exe (MFCD42D.DLL): 0xE06D7363: Microsoft C++ Exception.
First-chance exception in Mrgis.exe (MFCD42D.DLL): 0xE06D7363: Microsoft C++ Exception.

This only happens occassionaly even when I'm using the same input.

In addition I always get the following exceptions , even when the query works.

Warning: ODBC Success With Info, Driver's SQLSetConnectOption failed
State:IM006,Native:0,Origin:[Microsoft][ODBC Driver Manager]

Driver not capable
State:S1C00,Native:84,Origin:[Microsoft][ODBC Driver pack 2.0 Driver]

DBMS: ACCESS
, Version: 3.0

The error occurs when I try to Open the recordset

What could be happening?

Thanks ,
Rick
0
Ricky031497
Asked:
Ricky031497
1 Solution
 
Ricky031497Author Commented:
Edited text of question
0
 
rhgaracciCommented:
I suspect that the number of ?'s in your m_strFilter string does not match the value of m_nParams.  If you use different filter strings, you need to change the value of m_nParams accordingly.

With regard to the second set of messages, it is difficult to tell what is going on without seeing the code (options on Open() etc.)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now