Hi Thanks for the information, my Microsoft SQL DBA is looking the DTS VB Script stuff.
I will post the information if it works Cheers -- Jonathan Bedford Quoting Victor Pendleton <[EMAIL PROTECTED]>: > 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 > ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ --------------------------------------------------------------------- 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
