Re: Problem with MS Access Query & ODBC

Article View: borland.public.intrabuilder.data.sql

Article #89

Back to borland.public.intrabuilder.data.sql Previous Next

#89

From: Jeremy Burges
Date: Fri, 04 Sep 1998 00:00

10 lines
963 bytes

Have you tried using the native driver for Access rather than the ODBC one?
I found that I could do a 'LIKE' query using  ** with the native driver.
When I tried the ODBC driver I got the same error messages you report.


>Server Error: [Microsoft][ODBC Microsoft Access 97 Driver] Expression
>cannot be used with the LIKE predicate. in query
>expression'(VCHR_NUMBER= 'C001841' AND CUST_CODE>='2294000' AND
>CUST_CODE<='2294999' AND ('60188' alike left((DZIP),5) ))'.
>

Technical Details

Message-ID: <6so7oh$l992@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <35EF73AB.3943CD0B@sureway.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,5d76e7e24001dbeb
X-Google-Attributes: gid101d9a,public
From: "Jeremy Burges" <jburges@mktpoint.com>
Subject: Re: Problem with MS Access Query & ODBC
Date: 1998/09/04
Message-ID: <6so7oh$l992@forums.borland.com>
X-Deja-AN: 387772604
References: <35EF73AB.3943CD0B@sureway.net>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: Marketpoint
Newsgroups: borland.public.intrabuilder.data.sql

Reply to Parent Message