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
