Re: SQL, ODBC and MySql
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 46125
interpreted = N
texte = Hi Le,On Monday, December 9, 2002, at 02:16 PM, Le Pham wrote:> Hi: > > Do you modify your WebCatalog Prefs file to add the path of your odbc > library ? > Some thing like this > SQLLibraryPath /usr/local/unixODBC/lib/libodbc.so > your problem happens because WebDNA could not find or open the share > library > odbc.I have added that line to the prefs.Initially I added: SQLLibraryPath /usr/lib/libodbc.so as that is where the unixodbc package showed the file was installled. But I also see the same library installed at /usr/local/lib/libodbc.so so I also tried pointing the path in the prefs there.Same result.> Try to add your odbc path into WebCatalog Prefs file and restart > WebDNA.Done and restarted about 10 times already :(Is there a way I can verify that Webcat is reading this new pref? I can reload that file and see the line still there.> LeThanks, any additional suggestions welcome. This is holding up a large new section of this site.Dale> ----- Original Message ----- > From: Dale-Lists
> To: WebCatalog Talk > Sent: Saturday, December 07, 2002 5:32 AM > Subject: SQL, ODBC and MySql > > >> WebCat 4.02 >> RH Linux 7.2 >> >> Hello, >> >> I followed the instructions on this page: >> http://webdna.smithmicro.com/forums/ >> Topic.html?membersku=&cart=103926636131586&MessageID2=40855047136163 >> >> And when I try the example (but using an existing sql db) I get the >> following error. >> Error: SQL not supported >> >> >> I did stop and restart WebCat before running the page. Any ideas? >> >> Thanks! >> >> Dale >> >> >> ------------------------------------------------------------- >> 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:
Hi Le,On Monday, December 9, 2002, at 02:16 PM, Le Pham wrote:> Hi: > > Do you modify your WebCatalog Prefs file to add the path of your ODBC > library ? > Some thing like this > SQLLibraryPath /usr/local/unixODBC/lib/libODBC.so > your problem happens because WebDNA could not find or open the share > library > ODBC.I have added that line to the prefs.Initially I added: SQLLibraryPath /usr/lib/libODBC.so as that is where the unixODBC package showed the file was installled. But I also see the same library installed at /usr/local/lib/libODBC.so so I also tried pointing the path in the prefs there.Same result.> Try to add your ODBC path into WebCatalog Prefs file and restart > WebDNA.Done and restarted about 10 times already :(Is there a way I can verify that Webcat is reading this new pref? I can reload that file and see the line still there.> LeThanks, any additional suggestions welcome. This is holding up a large new section of this site.Dale> ----- Original Message ----- > From: Dale-Lists > To: WebCatalog Talk > Sent: Saturday, December 07, 2002 5:32 AM > Subject: SQL, ODBC and MySql > > >> WebCat 4.02 >> RH Linux 7.2 >> >> Hello, >> >> I followed the instructions on this page: >> http://webdna.smithmicro.com/forums/ >> Topic.html?membersku=&cart=103926636131586&MessageID2=40855047136163 >> >> And when I try the example (but using an existing sql db) I get the >> following error. >> Error: SQL not supported >> >> >> I did stop and restart WebCat before running the page. Any ideas? >> >> Thanks! >> >> Dale >> >> >> ------------------------------------------------------------- >> 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/
Dale-Lists
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:
different show next (1997)
Getting Emailer to send mail (1997)
Opinion: [input] should be called [output] ... (1997)
[OT] Its the "post a pic of your work environment" thread (2006)
[shownext] and descending order (1997)
Re:WebCat for mass emailings (1997)
New Command prefs ... (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Vann's - nice new WebCatalog site (1998)
RE: Credit card processing - UK (1997)
WebCat2b12--[searchstring] bug (1997)
[lookup] is case-sensitive, [lookup] is case sensitive... (2003)
Bug or syntax error on my part? (1997)
$append (1998)
Help! WebCat2 bug (1997)
My slower response (1997)
grabbing xml data with webcat (was: Posting XML data to (2002)
Sku numbers (1997)
Redirect (2000)
Help with Repost Data msg from form (1997)