Re: [SQL] & ODBC on Mac - Reposted

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28035
interpreted = N
texte = Found it on my FilemakerPro CD -- 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, Stuart Tremain wrote: >Thanks for that Mike, but where is this ODBC control panel available from? >-- >Stuart Tremain > >Digital Imaging Division >The Ad-Libitum Group >48 Victoria Street >North Sydney 2060 Australia >Phone: +612 9959 5633 Fax: +612 9929 4146 > >email: stuartt@adlib.com.au >http://www.adlib.com.au > >On 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 > >------------------------------------------------------------- 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)
Found it on my FilemakerPro CD -- 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, Stuart Tremain wrote: >Thanks for that Mike, but where is this ODBC control panel available from? >-- >Stuart Tremain > >Digital Imaging Division >The Ad-Libitum Group >48 Victoria Street >North Sydney 2060 Australia >Phone: +612 9959 5633 Fax: +612 9929 4146 > >email: stuartt@adlib.com.au >http://www.adlib.com.au > >On 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 > >------------------------------------------------------------- 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:

[OT] Browser's search via javascript? (2003) Verisigns SDK (pay flo pro) (2002) Bug Report, maybe (1997) Price Not Appearing (2000) WC2f3 (1997) WebCatalog can't find database (1997) [WebDNA] Mass email using WebDNA (2008) Virtual hosting and webcatNT (1997) Erotic Sites (1997) validatin on NT (sorry for the dups and etc) (1998) Bug Report, maybe (1997) Emailer and encryption (1997) Re2: AAgghh!! Help, please. SSL strikes again. (1997) Why doesn't it change? (1998) Different Tax levels (1998) WebCat2: Items xx to xx shown, etc. (1997) Problems with [Applescript] (1997) shipcost - fed up with the old way (1998) PCS Frames (1997) textarea inputs and returns (1999)