Re: WebDNA and SQL

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50084
interpreted = N
texte = OK, 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/ 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)
OK, 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/ 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:

RE: Can a database get stomped by simultaneous access? (1997) Date search - yes or no (1997) More Applescript (1997) Simple Database close connection (2001) email bounce check (2002) Slow Server (2005) What would be sweet is (2003) New 4.5 installer (2002) Error 11 (1996) Template not found error messages (1997) Emailer choke (1997) [WebDNA] passing a variable in an include - precedence (2015) [WebDNA] can webdna set the email header (w/[sendmail]) that controls where bounced email goes? (2012) [WebDNA] listvariables (2014) [WebDNA] Append speed limits (2008) WebCat with WebTen (1998) nslookup (2000) That Flakey 'Brawl' thing (1997) emailer error -108 (1997) Help formatting search results w/ table (1997)