Unspecified Error on Using MS Jet 4.0 OleDB provider

Article View: borland.public.cppbuilder.database.ado

Article #2546

Back to borland.public.cppbuilder.database.ado Previous Next

#2546

From: Bulent COSKUN
Date: Sat, 24 May 2003 10:44

25 lines
1662 bytes

Hello,

I write smiple code with using ADO Components in BCB6.
I was designed my DB with ACCESS 2002.
When I use Jet4.0 OleDB provider on ADOConnection Component,
I getting "Unspecified Error".

The Case:
Set ADOConnection Conponent's ConnectionString with Jet4.0 OleDB Provider
and Select .MDB file
Than,
Uset ADOQuery with SELECT * FROM TableName WHERE TableName.FiledName =
"Value"  Statement
Than,
Execute to Query.
"Unspecifed Error" appear.

In Fact, When use "SELECT * FROM TableName" Statement in ADOQuery Object,
Everything normal, and when I use ODBC provider everthing normal too.

I didn't understand this case.

Do you have any advice?

Bulent C.

Technical Details

Message-ID: <3ecf4d1a@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d126ce79b40b3bca,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-05-24 03:58:07 PST
From: "Bulent COSKUN" <bulent.coskun@e-kolay.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Unspecified Error on Using MS Jet 4.0 OleDB provider
Date: Sat, 24 May 2003 13:44:26 +0300
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.29.76.75
Message-ID: <3ecf4d1a@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1053773082 62.29.76.75 (24 May 2003 03:44:42 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail