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 ?ThanksAlain> 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:
OK, So now I am getting this in webdna:SQL Error: 0Any idea where to start looking ?ThanksAlain> 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)