Re: [SQL] & ODBC on Mac - Reposted

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28031
interpreted = N
texte = Thanks for that Mike, but where is this ODBC control panel available from? -- Stuart TremainDigital Imaging Division The Ad-Libitum Group 48 Victoria Street North Sydney 2060 Australia Phone: +612 9959 5633 Fax: +612 9929 4146email: stuartt@adlib.com.au http://www.adlib.com.auOn Saturday, 15 April 1939, Mike Davis wrote: >on 2/24/2000 1:03 PM, Stuart Tremain at stuartt@adlib.com.au >wrote: > >> Sorry, I am reposting this but I haven't had a single reply and it is >> something that I am interested in achieving. >> >> Can someone please explain how this is setup. Especially the ODBC control >> panel noted in the manual. >> >> As I am looking at the possibilities of WC3.x and searching other dBases. >> >> Am I reading the PR on v4.0 correctly that I can contact say an Oracle dB on >> another computer and perform a search, if so can the connection be made via >> TCP/IP to another physical location across town? >This is a function of your odbc drivers. Set up a Data Source in your ODBC >Control Panel, give it a name, password, etc. Then use the SQL context in >webcat to perform database operations on the ODBC compliant database. You >don't need version 4 to do this. Version 3 works just fine. You can do >remote ODBC connections, but you run more risk of failure or performance >degradation. I would only do this if you know that the connection between >server and remote database is very fast and reliable. And remember that >page rendering speed will be affected by the speed of that connection. >Don't expect your web pages to stay as speedy as they are using Webcat's >internal database. > >Mike > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to >. > >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 > >------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 2009)
  2. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Palle Bo Nielsen 2009)
  3. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Palle Bo Nielsen 2009)
  4. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  5. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Palle Bo Nielsen 2009)
  6. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  7. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 2009)
  8. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 2009)
  9. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  10. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Patrick McCormick 2009)
  11. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  12. [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  13. [SQL] context OT question (Pedro Rivera 2002)
  14. Re: Fw: [SQL] and [index] mystery solved (Bob McPeak 2001)
  15. Re: Fw: [SQL] and [index] mystery solved (John Peacock 2001)
  16. Fw: [SQL] and [index] mystery solved (Bob McPeak 2001)
  17. Re: [SQL] - COUNT, SUM retrieval (Matt 2000)
  18. Re: [SQL] - COUNT, SUM retrieval (Anup Setty 2000)
  19. [SQL] - COUNT, SUM retrieval (Matt 2000)
  20. Re: [sql] problems in WebCat 4.0 (Matt 2000)
  21. Re: [sql] problems in WebCat 4.0 (Matt 2000)
  22. Re: [sql] problems in WebCat 4.0 (Grant Hulbert 2000)
  23. [sql] problems in WebCat 4.0 (Matt 2000)
  24. Re: [SQL] on MacOs to SQL Server ... HOW TO? (Nicolas Verhaeghe 2000)
  25. Re: [SQL] on MacOs to SQL Server ... HOW TO? (WebDNA Support 2000)
  26. Re: [SQL] on MacOs to SQL Server ... HOW TO? (Nicolas Verhaeghe 2000)
  27. Re: [SQL] on MacOs to SQL Server ... HOW TO? (WebDNA Support 2000)
  28. Re: [SQL] on MacOs to SQL Server ... HOW TO? (Nicolas Verhaeghe 2000)
  29. [SQL] on MacOs to SQL Server ... HOW TO? (Nicolas Verhaeghe 2000)
  30. Re: [SQL] & ODBC on Mac - Reposted (Stuart Tremain 2000)
  31. Re: [SQL] & ODBC on Mac - Reposted (Stuart Tremain 2000)
  32. Re: [SQL] & ODBC on Mac - Reposted (Mike Davis 2000)
  33. [SQL] & ODBC on Mac - Reposted (Stuart Tremain 2000)
  34. [SQL] & ODBC on Mac (Stuart Tremain 2000)
Thanks for that Mike, but where is this ODBC control panel available from? -- Stuart TremainDigital Imaging Division The Ad-Libitum Group 48 Victoria Street North Sydney 2060 Australia Phone: +612 9959 5633 Fax: +612 9929 4146email: stuartt@adlib.com.au http://www.adlib.com.auOn Saturday, 15 April 1939, Mike Davis wrote: >on 2/24/2000 1:03 PM, Stuart Tremain at stuartt@adlib.com.au >wrote: > >> Sorry, I am reposting this but I haven't had a single reply and it is >> something that I am interested in achieving. >> >> Can someone please explain how this is setup. Especially the ODBC control >> panel noted in the manual. >> >> As I am looking at the possibilities of WC3.x and searching other dBases. >> >> Am I reading the PR on v4.0 correctly that I can contact say an Oracle dB on >> another computer and perform a search, if so can the connection be made via >> TCP/IP to another physical location across town? >This is a function of your ODBC drivers. Set up a Data Source in your ODBC >Control Panel, give it a name, password, etc. Then use the SQL context in >webcat to perform database operations on the ODBC compliant database. You >don't need version 4 to do this. Version 3 works just fine. You can do >remote ODBC connections, but you run more risk of failure or performance >degradation. I would only do this if you know that the connection between >server and remote database is very fast and reliable. And remember that >page rendering speed will be affected by the speed of that connection. >Don't expect your web pages to stay as speedy as they are using Webcat's >internal database. > >Mike > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to >. > >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 > >------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Stuart Tremain

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:

webcat- multiple selection in input field (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) GD Spam (2003) two part electronic product (1998) form data submission gets truncated (1997) New [math] variable not working... (2001) Ongoing group search problems ... (1997) tcpconnect feature request .. (2003) Not reading code (1997) [OT] javascript field validation with encoded forms (2004) RE: [WebDNA] Ubuntu and WebDNA (2019) Reversing [ipaddress] normalization (1998) Formatting Email (2000) Dynamic Weather for my website - XML? (1999) Re:Authenticate (1998) form data submission gets truncated (1997) Re:no [search] with NT (1997) Running 2 two WebCatalog.acgi's (1996) Multiple prices (1997) Email check problems -1 (1999)