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:
Lost Serial Number (2004)
Problems getting parameters passed into email. (1997)
[isfile] ? (1997)
Webstar 1.3.1 PPC (1997)
Mozilla/4. and Browser Info.txt (1997)
Setting up shop (1997)
AOL and referrers on target=_blank (2000)
WebCat2b15MacPlugin - showing [math] (1997)
[shownext max=?] armed (1997)
Passing Variable (was How to add product size) (1997)
Database Fields (1997)
Separate SSL Server (1997)
Discounting prices across a site (1997)
[WebDNA] TCPconnect and Bitcoin rate (2019)
WebCatalog Affiliates Program Announced -- Share the revenue for promoting WebCatalog (2000)
Email within tmpl ? (1997)
Make sure I understand this??? (1997)
Conditional searching & displaying (1997)
Snake Bites (1997)
Rendering out a page (1997)