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

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 60990
interpreted = N
texte = Thanks for the answer JohnIs there any other way you can think of to accomplish this? The clientssystem has a button which posts any records that have been marked as activejobs. The machine then wants to make a connection with something and get avalid reply accepting the records. I then need to search them using WebDNA.Cheers========================================Steve Craig - Asylum Interactive LtdTel +44 1224 642960 Fax +44 1224 642962========================================http://www.asylumweb.comEmail: steve@asylumweb.com========================================> From: John Peacock > Reply-To: WebDNA Talk > Date: Thu, 10 Feb 2005 09:30:38 -0500> To: WebDNA Talk > Subject: Re: Slightly [OT] Trying to get clients SQL system going> > 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/-------------------------------------------------------------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:

Re: Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
Re: Slightly [OT] Trying to get clients SQL system going ( John Peacock 2005)
Re: Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
Re: Slightly [OT] Trying to get clients SQL system going ( John Peacock 2005)
Re: Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)
Re: Slightly [OT] Trying to get clients SQL system going ( John Peacock 2005)
Slightly [OT] Trying to get clients SQL system going ( Steve Craig 2005)

Thanks for the answer JohnIs there any other way you can think of to accomplish this? The clientssystem has a button which posts any records that have been marked as activejobs. The machine then wants to make a connection with something and get avalid reply accepting the records. I then need to search them using WebDNA.Cheers========================================Steve Craig - Asylum Interactive LtdTel +44 1224 642960 Fax +44 1224 642962========================================http://www.asylumweb.comEmail: steve@asylumweb.com========================================> From: John Peacock > Reply-To: WebDNA Talk > Date: Thu, 10 Feb 2005 09:30:38 -0500> To: WebDNA Talk > Subject: Re: Slightly [OT] Trying to get clients SQL system going> > 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/-------------------------------------------------------------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/ Steve Craig

DOWNLOAD WEBDNA NOW!

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

2005

Top Articles:

Related Readings: