From: Date: March 20 1999 12:16am
Subject: RE: Access <-> MyODBC <-> MySQL problem
List-Archive: http://lists.mysql.com/mysql/653
Message-Id: <001401be725e$90377b40$0200a8c0@ultracow>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I think that's MS Access.  There is a switch in Access called "SQL
Passthrough".  That tells MS to quit messing with your SQL.
-Rob

> -----Original Message-----
> From: Struan Bartlett [mailto:struanb@stripped]
> Sent: Thursday, March 18, 1999 5:20 AM
> To: mysql@stripped
> Subject: Access <-> MyODBC <-> MySQL problem
>
>
>
> Hi. I've an Access 97 database with MySQL (3.22.16a-gamma-log) tables
> linked via MyODBC 2.50.22.
>
> I've designed an Access Query such that the Access 'SQL View' says:
>
> SELECT RawM.Name, * FROM RawM WHERE (((RawM.Name) Like 'MYINFOBOX%'));
>
> However, the appropriate excerpt from the MyODBC log file says:
>
> MSACCESS        de:aa	ENTER SQLExecDirect
> 		HSTMT               0x008b24f0
> 		UCHAR *             0x086513d4 [      -3] "SELECT
> RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' ) "
> 		SDWORD                    -3
>
> MSACCESS        de:aa	EXIT  SQLExecDirect  with return code 0
> (SQL_SUCCESS)
> 		HSTMT               0x008b24f0
> 		UCHAR *             0x086513d4 [      -3] "SELECT
> RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' ) "
> 		SDWORD                    -3
>
> MSACCESS        de:aa	ENTER SQLFetch
> 		HSTMT               0x008b24f0
>
> MSACCESS        de:aa	EXIT  SQLFetch  with return code 100
> (SQL_NO_DATA_FOUND)
> 		HSTMT               0x008b24f0
>
> And here's the appropriate except from the MySQL log:
>
> 990318 11:01:52    2126 Connect    struanb@stripped on newsnow
>                    2126 Query      SELECT Config, nValue FROM MSysConf
>                    2126 Query      SELECT RawM.ID FROM RawM WHERE
> (Name = 'MYINFOBOX%' )
> 990318 11:02:35    2126 Query      SELECT RawM.ID FROM RawM WHERE
> (Name = 'MYINFOBOX%' )
>
> Umm?! Can anyone tell me how/why the SQL "Like" (in the original SQL
> statement) been changed to an "="? And by what? Or should I post this
> query to the MyODBC list?
>
> Thanks in advance.
>
> Kind regards,
>
> Struan Bartlett.
>
> ------------------------------------------------------------------
> Struan Bartlett         | The Premier UK News Aggregation Web site
> Managing Director       | http://www.newsnow.co.uk/
> NewsNow Publishing Ltd  | Your remote control for news on the Net
>                         |
> Tel.  : 0171 720 2727   | "The only straight lines found
> Mobile: 0958 686494     |  in nature are those drawn by us"
> ------------------------------------------------------------------
>
>
>