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 andWebDNA to communicate on the Windows platform. It's pretty simple actually.I think most folks are asking about a Unix or MacOS Server ODBC connectionso I'll spare the list the details of what I did (I'm guessing the Windowsfolks had this figured out for some time now :) If someone does need awalk-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 bystep> >> 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 yousetup> >> MySQL with a username and password for use by WebDNA. Also, make sureyou> >> 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 allis> >>> working fine, just cant get ODBC talk to MySQL. Also MyODBC isinstalled,> >>> but unixODBC does only make with errors and alike.> >>>> >>> Would anybody be so kind and tell me in a step like way how to doit, 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:
With Sal D'anna help and Jim Lanford's word doc, I was able to get MySQL andWebDNA to communicate on the Windows platform. It's pretty simple actually.I think most folks are asking about a Unix or MacOS Server ODBC connectionso I'll spare the list the details of what I did (I'm guessing the Windowsfolks had this figured out for some time now :) If someone does need awalk-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 bystep> >> 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 yousetup> >> MySQL with a username and password for use by WebDNA. Also, make sureyou> >> 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 allis> >>> working fine, just cant get ODBC talk to MySQL. Also MyODBC isinstalled,> >>> but unixODBC does only make with errors and alike.> >>>> >>> Would anybody be so kind and tell me in a step like way how to doit, 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)