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:

Typhoon Rev. and PCS store problems (1999) Access Denied! But why? (1997) date format (another question) (2000) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Revisit: speed test (2002) Multiple condition showif's (2004) [WebDNA] How to code a 301 redirect (2008) Setting up the server (1997) Re:Has this happened to you? (was:Emailer Chokes on bad address) (1997) Converting order file to database (1998) Major Security Hole IIS NT (1998) WAS Strange non-display problem, now BAD MATH (2002) Accepting credit cards (1997) Email...Thanks (1997) Authenticate (1997) [WebDNA] [OT] hello (2012) HTTP header line is too long? (1997) Help! Strange happenings... (1997) Help name our technology! I found it (1997) RE: [WebDNA] [AddFields] Restrictions (2012)