RE: Access <-> MyODBC <-> MySQL problem - Robert J Greene - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRE: Access <-> MyODBC <-> MySQL problem

From	Sent On	Attachments
Struan Bartlett	18 Mar 1999 03:19
Michael Widenius	18 Mar 1999 05:19
Robert J Greene	19 Mar 1999 15:16

Subject:	RE: Access <-> MyODBC <-> MySQL problem
From:	Robert J Greene (rgre...@pcpros.net)
Date:	03/19/1999 03:16:26 PM
List:	com.mysql.lists.mysql

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:stru...@newsnow.co.uk] Sent: Thursday, March 18, 1999 5:20 AM To: mys...@lists.mysql.com 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 stru...@blur.dwpub.inet 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,

------------------------------------------------------------------