Re: WebDNA and SQL
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50086
interpreted = N
texte = Perhaps provide reference for the built in ODBC manager in Osx as well - since it is easier that unixODBC ..Thanks for helping though Alain> > 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.html > > I 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 SQL > > OK, So now I am getting this in webdna: > > SQL Error: > 0 > > Any 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/ ------------------------------------------------------------- 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:
Perhaps provide reference for the built in ODBC manager in Osx as well - since it is easier that unixODBC ..Thanks for helping though Alain> > 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.html > > I 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 SQL > > OK, So now I am getting this in webdna: > > SQL Error: > 0 > > Any 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/ ------------------------------------------------------------- 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:
Gettting IPAddress (2001)
NT vs Mac (1997)
File Upload (1997)
[include file=filename.inc&strip=t] (2002)
Just a thought - WebCat classes (1998)
WC2b15 File Corruption (1997)
Pretty Easy I bet (2000)
A question on sub-categories (1997)
Weird bug, or is there something amiss? (1997)
Pipes instead of tabs (1998)
[WebDNA] Installing 6.0 onto Server 2008 (2011)
RE: [isfolder] and [filename] (1997)
Auction made in webcat (2000)
Re(2): MASTER_STORE revision (2002)
autosensing lanague selection (1997)
Price and Formula.db (2002)
BGcolor (1997)
Suggestions on best way to work with yyyy/mm/dd (1997)
Database Strategy - more... (1998)
Problems with SELECT MULTIPLE (1999)