Re: WebDNA and SQL
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50085
interpreted = N
texte = Le and Scott are looking into this. There is an existing page of the WebDNA reference guide that discusses this general area at (linked through via the [SQL] context page): http://webdna.smithmicro.com/ref/UNIXODBCSetup.htmlI don't know that this will address the discussed issues 100% ... we will update this section with any changes based upon what Le and Scott find, or any recommendations/comments provided by the members here. We're also going to break it out as a separate 'appendix' in the reference guide so it's easier to find ...Phil B.-----Original Message----- From: Alain Russell [mailto:alain.russell@blackpepper.co.nz] Sent: Tuesday, May 06, 2003 3:37 PM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: WebDNA and SQLOK, So now I am getting this in webdna:SQL Error: 0Any idea where to start looking ?Thanks Alain> Is it /usr/lib/libodbc.so or libiodbc.so ?? > Can you email me the file ? What Os are you using ? > > Alain > >> Alain, >> >> I might be using Aaron's version, but I don't remember. I did look at his >> site and download the installer. >> >> The pref file is as follows: >> >> SQLLibraryPath /usr/lib/libodbc.so >> >> HTH! >> >> >> On 5/6/03 3:13 PM, Alain Russell
wrote: >> >>> 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/ >> >> >> --------------------------------------------------------------------- >> 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/ ------------------------------------------------------------- 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:
Le and Scott are looking into this. There is an existing page of the WebDNA reference guide that discusses this general area at (linked through via the [SQL] context page): http://webdna.smithmicro.com/ref/UNIXODBCSetup.htmlI don't know that this will address the discussed issues 100% ... we will update this section with any changes based upon what Le and Scott find, or any recommendations/comments provided by the members here. We're also going to break it out as a separate 'appendix' in the reference guide so it's easier to find ...Phil B.-----Original Message----- From: Alain Russell [mailto:alain.russell@blackpepper.co.nz] Sent: Tuesday, May 06, 2003 3:37 PM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: WebDNA and SQLOK, So now I am getting this in webdna:SQL Error: 0Any idea where to start looking ?Thanks Alain> Is it /usr/lib/libODBC.so or libiODBC.so ?? > Can you email me the file ? What Os are you using ? > > Alain > >> Alain, >> >> I might be using Aaron's version, but I don't remember. I did look at his >> site and download the installer. >> >> The pref file is as follows: >> >> SQLLibraryPath /usr/lib/libODBC.so >> >> HTH! >> >> >> On 5/6/03 3:13 PM, Alain Russell wrote: >> >>> 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/ >> >> >> --------------------------------------------------------------------- >> 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/ ------------------------------------------------------------- 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/
Phillip Bonesteele
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:
Press Release hit the NewsWire!!! (1997)
Authorize.net, SIM, tcpconnect and applescript (2003)
expired beta (1997)
Who needs Yoda! (2002)
E-Mail (1998)
Mixing and/or in searches (1998)
WILDWEBCAT encrypt.tpl submission (1998)
Frames and WebCat (1997)
using listfiles to build a database? more (2000)
Summ (1998)
errormessages.db (1997)
Prevent multiple appends with Reload Button (1997)
Re1000001: Setting up shop (1997)
Protecting webdelivery (1997)
shipping costs (2000)
Calculating Age from DB fields (2003)
Hiding usernames and passwords in URL (1998)
[ShowNext] feature in 2.0 (1997)
Getting total number of items ordered (1997)
webcat- multiple selection in input field (1997)