Re: Slightly [OT] Trying to get clients SQL system going

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60988
interpreted = N
texte = Steve Craig wrote: > Does MS SQL speak to MySQL directly or do I need ODBC or something else? > If I need ODBC, any pointers to how to get it going would be very helpful. No, MS SQL and MySQL are two completely different systems; ODBC is a client to server connection, not a server to server one. You would have to have a process that connects to both databases in order to transfer data between them. Alternatively, if you don't need the data to be mirrored simultaneously, you can export from one and import to the other on an hourly schedule (or daily if that works for you instead). HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
  2. Re: Slightly [OT] Trying to get clients SQL system going ( John Peacock 2005)
  3. Re: Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
  4. Re: Slightly [OT] Trying to get clients SQL system going ( John Peacock 2005)
  5. Re: Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
  6. Re: Slightly [OT] Trying to get clients SQL system going ( John Peacock 2005)
  7. Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
Steve Craig wrote: > Does MS SQL speak to MySQL directly or do I need ODBC or something else? > If I need ODBC, any pointers to how to get it going would be very helpful. No, MS SQL and MySQL are two completely different systems; ODBC is a client to server connection, not a server to server one. You would have to have a process that connects to both databases in order to transfer data between them. Alternatively, if you don't need the data to be mirrored simultaneously, you can export from one and import to the other on an hourly schedule (or daily if that works for you instead). HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ John Peacock

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Formating found categories (1997) Initiating NewCart (1997) bug in [SendMail] (1997) ShoppingCart clearing code (2004) Re:Item options w/ price adjustment (1997) Multi-processor Mac info ... (1997) Post arguments problem mac? (1997) Summing fields (1997) WebCat2b12--[searchstring] bug (1997) Running _every_ page through WebCat-error.html (1997) [SHOWIF AND/OR] (1997) merchant accts. (1997) [OT] JS snippet needed (2006) OT - asp snippet similar to [!][/!] (2003) formulas.db ?? (1998) [WebDNA] png support in webDNA (2011) Referrer Problems (2000) Merging databases (1997) Sense/Disallow HTML tags during $Append (1997) :Programmer: Looking for work (2002)