Re: problem with WHERE clause when using ADO and Microsoft.Jet.OLEDB.4
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Mon, 13 Nov 2006 21:43:29 -0500
JackChiou wrote:
Hi everyone,
I am using ADO with Microsoft.Jet.OLEDB.4.0 to connect to the Access97
database. The problem is every time when I use WHERE clause with
duplicated numerical value, it will fail....
For Example:
RecordSet.Open("SELECT * FROM xxxxx WHERE yyyyy = 1",
m_pConnection,
adOpenStatic,
adLockOptimistic,
adCmdUnknown);
(if field yyyyy is none primary, Index Yes with Duplicates OK, it
will catch error.)
The error message shows:
ADORecordset error, error code =80004005, code meaning = Unspecified
error
It's only happen on Microsoft.Jet.OLEDB.4.0, If I use other provider
like MSDASQL or Microsoft.Jet.OLEDB.3.51 then it's working fine. I
also had tried to convert the database from Access97 to Access2000
and upgrade the ADO and Microsoft.Jet.OLEDB.4.0 to the latest version
but still the same. It feels like Jet.OLEDB.4.0 doesn' like any field
with duplicated numerical value???!!
I have been working on this for 2 weeks already but still no luck,
getting so frustrated now so please help me!! Thanks!!!
-Jack
This usually means your query contains one or more reserved keywords. See
http://www.aspfaq.com/show.asp?id=2080
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Prev by Date: Re: ADO Recordset to SQLite
- Next by Date: Stored Procedure with Output Parameters
- Previous by thread: Re: how to find differences between production and test databases
- Next by thread: Stored Procedure with Output Parameters
- Index(es):
Relevant Pages
|
