Re: [SQL] & ODBC on Mac - Reposted

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28029
interpreted = N
texte = 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 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)
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 Mike Davis

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:

WC2.0 Memory Requirements (1997) performans tests... (2001) WebCommerce: Folder organization ? (1997) categories (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) Still trying to email... (1998) policies, slightly OT (2004) Emailer to include Human Name with email Address (2000) groupfields, popups, etc. (2000) html delivery (1997) emailer (1997) sorry (1997) WebCatalog seems to choke on large (2meg) html files. (1998) WebCat hosting providers? (1997) Almost a there but..bye bye NetCloak (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) if else problem (2003) Search in 2 or more catalogs (1997) Out of the woodwork (2007) 3.0 [TEXT] variables (1998)