In the DTS engine you can write a VB script to handle the quotations during the transfer. I replicate from MS SQL to MySQL using Java and came across the same issue. Let me know if you need any help.
-----Original Message----- From: Jonathan Bedford [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 2:58 PM To: [EMAIL PROTECTED] Subject: MSSQL Transactional Replication to MySQL Hi � Has anyone managed to get Microsoft SQL Server (2000 (SP2)) to replicate data to MySQL (3.23.49) via Microsoft heterogeneous replication & MySQL ODBC Driver (3.51)? � Deletions at the MS end replicate to the MySQL Successfully, BUT � Insertions and updates fail, it seem to be a problem with quotes `'" � Both servers are running in ANSI mode and the MySQL tables are InnoDB. The trace from the MyODBC driver show that no quotes are been used around the values. � Any Ideas? � Jonathan � � --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
