Re: WebDNA and SQL

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50074
interpreted = N
texte = Hi Clint - Sounds like you have Complete MySQL from Aaron Faby .. Can you let me know the value of 'SQLLibraryPath' in WebCatalog Prefs file ?Thanks Alain> 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/ ------------------------------------------------------------- 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)
Hi Clint - Sounds like you have Complete MySQL from Aaron Faby .. Can you let me know the value of 'SQLLibraryPath' in WebCatalog Prefs file ?Thanks Alain> 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/ ------------------------------------------------------------- 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/ Alain Russell

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:

WebCat editing, SiteGuard & SiteEdit (1997) [WebDNA] Mass email using WebDNA (2008) Mondo amounts of Mail [long] (1999) Physical Security for WebCatalog Directories (1997) Refering page (1998) bannerads example idiot (1997) Newbie search question (between two dates) (2001) Locking up with WebCatalog... (1997) expired beta (1997) [WebDNA] Base 64 (2010) emailer (1997) I'm new (2001) DON'T use old cart file! (1997) Webcat no longer supported? (2006) All of a Sudden Type 2 errors (1999) Here we go again... (2006) [WebDNA] Passing a text variable via copyfile (2019) [ELSEIF] was hideif [x]=1,2,3..: (2003) More on the email templates (1997) Switching from merge to tab delimited..(v 2.x) (2000)