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:

TCPConnect & TCPSend (2003) RequiredFields template (1997) [WebDNA] Connect to MS SQL (2013) Stay on Products page (2003) Non-technical messages ... (1997) [WebDNA] Search question (2012) ANother SHOWIF problem (1997) BGcolor (1997) [carts] and databases (1997) shipCost formula (1997) taxRate is fine but taxTotal isn't (1997) db protection on NT (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) [OT] Kerio Mailserver (2003) dollar $ signs in database (2000) RE: Re:Signal Raised (1997) Nested tags count question (1997) WebCat2 - storing unformatted date data? (1997) more on quicktime test stuff (1997) webcat- multiple selection in input field (1997)