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

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60992
interpreted = N
texte = Steve Craig wrote: > Is there any other way you can think of to accomplish this? The clients > system has a button which posts any records that have been marked as active > jobs. The machine then wants to make a connection with something and get a > valid reply accepting the records. I then need to search them using WebDNA. I can't tell from your description what is the producer of the data and what is the consumer. I think you mean that the data is keyed into the MS SQL system and then the data is transferred to the box with Filemaker. What I cannot tell is what performs that transfer and how. Does the Filemaker box pull the data via ODBC out of the MS SQL database? Does the client code connect to both the MS SQL database and the Filemaker database via ODBC and transfer the data? If the latter is the case, then there should be no problem loading the MySQL ODBC driver onto the client box and using the current scheme. It's the difference between push and pull; the latter is push (where the client does all the work) vs the former being pull (where the server is supposed to to the heavy lifting). 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: > Is there any other way you can think of to accomplish this? The clients > system has a button which posts any records that have been marked as active > jobs. The machine then wants to make a connection with something and get a > valid reply accepting the records. I then need to search them using WebDNA. I can't tell from your description what is the producer of the data and what is the consumer. I think you mean that the data is keyed into the MS SQL system and then the data is transferred to the box with Filemaker. What I cannot tell is what performs that transfer and how. Does the Filemaker box pull the data via ODBC out of the MS SQL database? Does the client code connect to both the MS SQL database and the Filemaker database via ODBC and transfer the data? If the latter is the case, then there should be no problem loading the MySQL ODBC driver onto the client box and using the current scheme. It's the difference between push and pull; the latter is push (where the client does all the work) vs the former being pull (where the server is supposed to to the heavy lifting). 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:

problem: search crashes webstar (1997) WebDNA Solutions ... sorry! (1997) WebDNA install - linux (permissions rehash?) (2002) Intermitent problem using [referrer] (1997) Solve the Problem, get the code! (2001) More on the email templates (1997) WC1.6 to WC2 date formatting -FIXED! (1997) Need some assistance. (1999) how to kill webcat ? (2002) weirdness in the error log (1998) shownext problems & formvariables (1998) Error -108 (1997) Re2: frames & carts (1997) Frames and WebCat (1997) code to phantom spacing (2001) WebCat2final1 crashes (1997) multi-paragraph fields (1997) WebCat 3.0 Serial Numbers (1999) Passing Variable (was How to add product size) (1997) WebCatalog/WebMerchant Manuals Available (1998)