Very Computer

by **John cccc** » Tue, 23 Aug 2005 22:18:57

I am trying to adjust sql_mode but with no success. I use MySQL Query
Browser from a remote mashine, login as root and I run set global
sql_mode='ansi';

Then I run MySQLCommand line client from the MySQL server and the sql_mode
is unchanged.

I also tried to set the sql_mode in the My.ini file but it does not seem to
have any effect. We have a web application that connects to MySQL. The
applicatio written to communicate to SQL Server and the MySQL default mode
cannot interpret the sql queries.

How do I set the sql_mode, with what tool, how do I ensure what sql mode is
currently set?

Thank you for your help
John C

>Subject: RE: MSSQL to MySQL mapping
>Date: Thu, 11 Aug 2005 09:20:08 +0200

>Have you adjusted your queries? MSSQL uses a different dialect (T-SQL),
>then MySQL uses. There are quite some difference, although some queries
>still might work.

>Arjan.

>-----Original Message-----

>Sent: Wednesday, August 10, 2005 08:12 PM

>Subject: MSSQL to MySQL mapping

>We have a web based application running on IIS 5.0 using MS SQL Server
>2000 as the DBMS; we use ODBC to connect to the DB. We migrated our DB
>to MySQL and used the MySQL ODBC driver. It appears that some of the SQL
>statements that are accepted by SQL Server 2000 are not accepted by
>MySQL. Is there a mapping from MSSQL to MySQL statements?

>Thank you
>John C.

>_________________________________________________________________
>Express yourself instantly with MSN Messenger! Download today - it's
>FREE!
>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:

>--
>The information contained in this communication and any attachments is
>confidential and may be privileged, and is for the sole use of the intended
>recipient(s). Any unauthorized review, use, disclosure or distribution is
>prohibited. If you are not the intended recipient, please notify the sender
>immediately by replying to this message and destroy all copies of this
>message and any attachments. ASML is neither liable for the proper and
>complete transmission of the information contained in this communication,
>nor for any delay in its receipt.

>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql

_________________________________________________________________
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

by **John cccc** » Tue, 23 Aug 2005 22:48:01

Also mysql complaints when I use the *= syntax:

select a.userID from USers a, UserGroups b where
a.UserGroupID*=b.UserGroupID;

Any ideas? What is the equivalent syntax for MySQL.

Thank you
John C>

>Subject: FW: RE: MSSQL to MySQL mapping
>Date: Mon, 22 Aug 2005 13:18:43 +0000

>I am trying to adjust sql_mode but with no success. I use MySQL Query
>Browser from a remote mashine, login as root and I run set global
>sql_mode='ansi';

>Then I run MySQLCommand line client from the MySQL server and the sql_mode
>is unchanged.

>I also tried to set the sql_mode in the My.ini file but it does not seem to
>have any effect. We have a web application that connects to MySQL. The
>applicatio written to communicate to SQL Server and the MySQL default mode
>cannot interpret the sql queries.

>How do I set the sql_mode, with what tool, how do I ensure what sql mode is
>currently set?

>Thank you for your help
>John C

>>Subject: RE: MSSQL to MySQL mapping
>>Date: Thu, 11 Aug 2005 09:20:08 +0200

>>Have you adjusted your queries? MSSQL uses a different dialect (T-SQL),
>>then MySQL uses. There are quite some difference, although some queries
>>still might work.

>>Arjan.

>>-----Original Message-----

>>Sent: Wednesday, August 10, 2005 08:12 PM

>>Subject: MSSQL to MySQL mapping

>>We have a web based application running on IIS 5.0 using MS SQL Server
>>2000 as the DBMS; we use ODBC to connect to the DB. We migrated our DB
>>to MySQL and used the MySQL ODBC driver. It appears that some of the SQL
>>statements that are accepted by SQL Server 2000 are not accepted by
>>MySQL. Is there a mapping from MSSQL to MySQL statements?

>>Thank you
>>John C.

>>_________________________________________________________________
>>Express yourself instantly with MSN Messenger! Download today - it's
>>FREE!
>>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:

>>--
>>The information contained in this communication and any attachments is
>>confidential and may be privileged, and is for the sole use of the
>>intended recipient(s). Any unauthorized review, use, disclosure or
>>distribution is prohibited. If you are not the intended recipient, please
>>notify the sender immediately by replying to this message and destroy all
>>copies of this message and any attachments. ASML is neither liable for the
>>proper and complete transmission of the information contained in this
>>communication, nor for any delay in its receipt.

>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:

>_________________________________________________________________
>Dont just search. Find. Check out the new MSN Search!
>http://search.msn.click-url.com/go/onm00200636ave/direct/01/

>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql