uot;John c" <[EMAIL PROTECTED]> wrote on 08/22/2005 04:04:58 PM:
>
> Thank you for your e-mail, but it did not work. In any case it does not
make
> a lot of sense to go back to a 1000 page application and identify every
> single T-SQL syntax and convert it to a MySQL sy
Thank you for your e-mail, but it did not work. In any case it does not make
a lot of sense to go back to a 1000 page application and identify every
single T-SQL syntax and convert it to a MySQL syntax especially without an
MSSQL to MySQL mapping. Isn't there a mode to support
ccc; mysql@lists.mysql.com
Subject: RE: RE: MSSQL to MySQL mapping
User % instead of *
-Original Message-
From: John c [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 9:48 AM
To: mysql@lists.mysql.com
Subject: FW: RE: MSSQL to MySQL mapping
Also mysql complaints when I use the
User % instead of *
-Original Message-
From: John c [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 9:48 AM
To: mysql@lists.mysql.com
Subject: FW: RE: MSSQL to MySQL mapping
Also mysql complaints when I use the *= syntax:
select a.userID from USers a, UserGroups b where
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:
Subject: RE: MSSQL to MySQL mapping
Date: Thu, 11 Aug 2005
currently set?
Thank you for your help
John C
From: "Arjan Hulshoff" <[EMAIL PROTECTED]>
To: "John c" <[EMAIL PROTECTED]>
CC:
Subject: RE: MSSQL to MySQL mapping
Date: Thu, 11 Aug 2005 09:20:08 +0200
Have you adjusted your queries? MSSQL uses a differe
@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
John c wrote:
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 accep
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 the
