Q: Linux WebCat to ODBC
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37612
interpreted = N
texte = Hi, I've set up 6 RH linux servers with ODBC & MySQLsee my other post:'fyi: getting ODBC MySQL ready for WebCat'-- WebCatalog / Apache works fine and will give 'Error: SQL not supported' if 'WebCatalog Prefs' does not contain the correct path to unixODBC## - - - - -Edit - WebCatalog Prefs - - - - - - - - - -SQLLibraryPath /usr/local/unixODBC/lib/libodbc.so## - - - - - - - - - - - - - - - - - - - - -I don't get the 'SQL not supported' error, I get the other SQL errorwhich is returned for all other SQL problemsSQL Error: 00000isql works on all 6 server talking to all 6 MySQL db'sthis means that everything including odbc.ini is correct.WebCatalog SQL only works on 2 of the servers. One full license and one runs in developer modethe other 4 WebCatalog servers work fine except for SQL calls two are full license and two run in developer modeQ: where should I start looking? Permissions? Ownership? Bad Install? (WC works fine and returns the SQL Error: 00000) Apache config?Any Ideas anyone?Hey Smith Micro, how about returning more verbose SQL errors.TIA- Jim-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi, I've set up 6 RH linux servers with ODBC & MySQLsee my other post:'fyi: getting ODBC MySQL ready for WebCat'-- WebCatalog / Apache works fine and will give 'Error: SQL not supported' if 'WebCatalog Prefs' does not contain the correct path to unixODBC## - - - - -Edit - WebCatalog Prefs - - - - - - - - - -SQLLibraryPath /usr/local/unixODBC/lib/libODBC.so## - - - - - - - - - - - - - - - - - - - - -I don't get the 'SQL not supported' error, I get the other SQL errorwhich is returned for all other SQL problemsSQL Error: 00000isql works on all 6 server talking to all 6 MySQL db'sthis means that everything including ODBC.ini is correct.WebCatalog SQL only works on 2 of the servers. One full license and one runs in developer modethe other 4 WebCatalog servers work fine except for SQL calls two are full license and two run in developer modeQ: where should I start looking? Permissions? Ownership? Bad Install? (WC works fine and returns the SQL Error: 00000) Apache config?Any Ideas anyone?Hey Smith Micro, how about returning more verbose SQL errors.TIA- Jim-------------------------------------------------------------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://search.smithmicro.com/
Jim Lanford
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:
searching by part of the date information (1999)
Disappearing Databases (2000)
i'm dumb today (2004)
mass mailing (1998)
Is this google friendly? (2003)
WebCat 4.5 and Windows Server 2003 (2006)
PROBLEM (1997)
SiteGuard Use Question (1997)
NT - Thanks and Taxes (1997)
Add a Blog to your site. (2002)
[OT] : Chat Room on OSX (2003)
Search Question (2000)
Nested tags count question (1997)
Checking for WebCatalog Version (2000)
Max Record length restated as maybe bug (1997)
Globals in 3.x (2002)
Store Builder, technical infos (1998)
Passing Variables.. yikes, I'm dumb (2000)
WebCat Contest Please Clarify (1998)
[sendmail] questions... (1997)