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).HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 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:
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).HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 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:
[WebDNA] Snow Leoopard and v7 (2011)
WC2.0 Memory Requirements (1997)
search for all (1998)
[OT] Shining Examples (2007)
A little help on e-mail (HELP!!! :-) ) (1998)
A matter of time (1997)
show all problem (1997)
WebMerchant setup (1998)
Search Order? (2000)
Keep away (1997)
b12 cannot limit records returned and more. (1997)
RE: New WebCatalog Version !!! (1997)
hidden databases (2000)
Max Record length restated as maybe bug (1997)
system crashes, event log (1997)
Calculating Shipping (1997)
storing javascript variables (2005)
WebCatalog for Postcards ? (1997)
Merging databases (1997)
Location of Webcat site in folder hierarchy (1997)