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>
From: "John ccccc" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
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
From: "Arjan Hulshoff" <[EMAIL PROTECTED]>
To: "John ccccc" <[EMAIL PROTECTED]>
CC: <mysql@lists.mysql.com>
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-----
From: John ccccc [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 10, 2005 08:12 PM
To: mysql@lists.mysql.com
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:
http://lists.mysql.com/[EMAIL PROTECTED]
--
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:
http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
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: http://lists.mysql.com/[EMAIL PROTECTED]