Re: WebDNA and SQL
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50083
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
[WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (2020)
[OT] Form Check java problem (2003)
[listfields] on Mac OS w/WC 3.x (2001)
Database search in JavaScript with passed values (2002)
[ShowNext] (1997)
international time (1997)
Requiring that certain fields be completed (1997)
Alternating colors (1997)
[LOOKUP] (1997)
multi-paragraph fields (1997)
Can I do these? (1997)
PCS Frames (1997)
StoreBuilder v4.0.2 Question (2001)
WebMerchant? (1998)
Test (2003)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
includes and cart numbers (1997)
Merging databases (1997)
WebCat2 beta 11 - new prefs ... (1997)
Location of Webcat site in folder hierarchy (1997)