Re: WebDNA and SQL

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50089
interpreted = N
texte = With Sal D'anna help and Jim Lanford's word doc, I was able to get MySQL and WebDNA to communicate on the Windows platform. It's pretty simple actually.I think most folks are asking about a Unix or MacOS Server ODBC connection so I'll spare the list the details of what I did (I'm guessing the Windows folks had this figured out for some time now :) If someone does need a walk-through though, just email.GK > Nitai, > > Using the MacOS X ODBC Administrator app, I created a couple of DSNs like > this: > > User DSN Tab > Name: MySQL > Description: MySQL > Driver: MySQL-MyODBC > Server: localhost > Database: MyDatabaseName > > System DSN Tab > Name: MyDatabaseName > Description: MySQL > Driver: MySQL-MyODBC > Server: localhost > Database: MyDatabaseName > > Drivers Tab > Driver: MySQL-MyODBC > File: /Library/MyODBC/lib/libmyodbc3_r.bundle > > > MySQL 3.23.55 > This is not the Entropy version, but I don't remember how I installed it. > > > Sample WeDNA query: > [SQL dsn=MyDSN&username=MyUsername&password=MyPassword&statement=SELECT * > from contacts WHERE (first_name LIKE '%[dna_first_name]%') ORDER BY > last_name,first_name;] > > > Hope this help! > > > On 5/6/03 7:37 AM, Nitai @ ComputerOil wrote: > > > Thanks Clint, > > > > Would be cool to let me know some more infos. > > > > TIA. > > > > On 6.5.2003 14:33 Uhr, Clint Davis wrote: > > > >> Nitai, > >> > >> I'm running this combo under OSX 10.2.4, but I can't give you a step by step > >> procedure because it took me a couple of tries to get it working. > >> > >> I'm using MySQL 3.23.55 with the built-in OSX ODBC app. Make sure you setup > >> MySQL with a username and password for use by WebDNA. Also, make sure you > >> setup your DSNs in the ODBC app. > >> > >> I'll provide more info when I get into the office. > >> > >> > >> On 5/6/03 2:35 AM, Nitai @ ComputerOil wrote: > >> > >>> I somehow got stuck with ODBC and MySQL. I got MySQL running and all is > >>> working fine, just cant get ODBC talk to MySQL. Also MyODBC is installed, > >>> but unixODBC does only make with errors and alike. > >>> > >>> Would anybody be so kind and tell me in a step like way how to do it, or > >>> give me a URL so I can find it out? > > > --------------------------------------------------------------------- > Clint Davis > Webmaster / Interactive Media Specialist > Gray Loon Marketing Group, Inc. http://www.grayloon.com > 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 > --------------------------------------------------------------------- ------------------------------------------------------------- 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. WebDNA and SQL - encrypted passwords ( Larry Hewitt 2006)
  2. Re: WebDNA and SQL (Jay Van Vark 2003)
  3. Re: WebDNA and SQL (Dale's Stuff 2003)
  4. Re: WebDNA and SQL (Gary Krockover 2003)
  5. Re: WebDNA and SQL (Alain Russell 2003)
  6. Re: WebDNA and SQL (Phillip Bonesteele 2003)
  7. Re: WebDNA and SQL (Alain Russell 2003)
  8. Re: WebDNA and SQL (Alain Russell 2003)
  9. Re: WebDNA and SQL (Clint Davis 2003)
  10. Re: WebDNA and SQL (Alain Russell 2003)
  11. Re: WebDNA and SQL (Sal D'anna 2003)
  12. Re: WebDNA and SQL (Clint Davis 2003)
  13. Re: WebDNA and SQL (Jay Van Vark 2003)
  14. Re: WebDNA and SQL (Jay Van Vark 2003)
  15. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  16. Re: WebDNA and SQL (Alain Russell 2003)
  17. Re: WebDNA and SQL (Clint Davis 2003)
  18. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  19. Re: WebDNA and SQL (Gary Krockover 2003)
  20. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  21. Re: WebDNA and SQL (Alain Russell 2003)
  22. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  23. Re: WebDNA and SQL (Alain Russell 2003)
  24. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  25. Re: WebDNA and SQL (Alain Russell 2003)
  26. WebDNA and SQL (Nitai @ ComputerOil 2003)
With Sal D'anna help and Jim Lanford's word doc, I was able to get MySQL and WebDNA to communicate on the Windows platform. It's pretty simple actually.I think most folks are asking about a Unix or MacOS Server ODBC connection so I'll spare the list the details of what I did (I'm guessing the Windows folks had this figured out for some time now :) If someone does need a walk-through though, just email.GK > Nitai, > > Using the MacOS X ODBC Administrator app, I created a couple of DSNs like > this: > > User DSN Tab > Name: MySQL > Description: MySQL > Driver: MySQL-MyODBC > Server: localhost > Database: MyDatabaseName > > System DSN Tab > Name: MyDatabaseName > Description: MySQL > Driver: MySQL-MyODBC > Server: localhost > Database: MyDatabaseName > > Drivers Tab > Driver: MySQL-MyODBC > File: /Library/MyODBC/lib/libmyODBC3_r.bundle > > > MySQL 3.23.55 > This is not the Entropy version, but I don't remember how I installed it. > > > Sample WeDNA query: > [SQL dsn=MyDSN&username=MyUsername&password=MyPassword&statement=SELECT * > from contacts WHERE (first_name LIKE '%[dna_first_name]%') ORDER BY > last_name,first_name;] > > > Hope this help! > > > On 5/6/03 7:37 AM, Nitai @ ComputerOil wrote: > > > Thanks Clint, > > > > Would be cool to let me know some more infos. > > > > TIA. > > > > On 6.5.2003 14:33 Uhr, Clint Davis wrote: > > > >> Nitai, > >> > >> I'm running this combo under OSX 10.2.4, but I can't give you a step by step > >> procedure because it took me a couple of tries to get it working. > >> > >> I'm using MySQL 3.23.55 with the built-in OSX ODBC app. Make sure you setup > >> MySQL with a username and password for use by WebDNA. Also, make sure you > >> setup your DSNs in the ODBC app. > >> > >> I'll provide more info when I get into the office. > >> > >> > >> On 5/6/03 2:35 AM, Nitai @ ComputerOil wrote: > >> > >>> I somehow got stuck with ODBC and MySQL. I got MySQL running and all is > >>> working fine, just cant get ODBC talk to MySQL. Also MyODBC is installed, > >>> but unixODBC does only make with errors and alike. > >>> > >>> Would anybody be so kind and tell me in a step like way how to do it, or > >>> give me a URL so I can find it out? > > > --------------------------------------------------------------------- > Clint Davis > Webmaster / Interactive Media Specialist > Gray Loon Marketing Group, Inc. http://www.grayloon.com > 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 > --------------------------------------------------------------------- ------------------------------------------------------------- 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/ Gary Krockover

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:

WebCat2b12--[searchstring] bug (1997) About to give up (1998) WebCatalog f2 Installation (1997) Emailer (1997) Frames and WebCat (1997) Include from DB (2002) Max Record length restated as maybe bug (1997) PCS Emailer's role ? (1997) WriteFile and returns... (2000) Help with Shipping Costs (1997) [WebDNA] What file needs to be edited in apache to server html (2008) Size images (2002) Pithy questions on webcommerce & siteedit (1997) Banners (1997) Zip Codes (2003) Problems getting parameters passed into email. (1997) Am I going senile? (Price recalc based on quantity) (1997) Fixed: 2cd pair of eyes please. (2003) WebMerchant? (1998) [BoldWords] WebCat.acgib15Mac (1997)