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]

Reply via email to