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:

[WebDNA] [announce] CICADA Gold Products (2009) quantity minimum problem (1997) case number with spaces. (2000) WebCat2 beta 11 - new prefs ... (1997) Parameter vs. Operator (1998) NT 4.0/IIS WebCat Installation (1998) RequiredFields template (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Opinion: [input] should be called [output] ... (1997) [ListFiles] from a remote host (2003) WebCat2 beta 11 - new prefs ... (1997) Encyption mail was Suggestions for Topics ... (1998) error -43 (1998) accented chars. Please help me! (1998) OT: How to get more traffic to a site? (2005) TcpConnect get files on ver. 5.x FIXED FIXED FIXED - (2004) question: Eudora 3.1.1 (1997) WebMerchant bomb (1998) Searching for foreign chars (2004) [Sum] function? (1997)