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:
[WebDNA] how can i grab the contents of a post? (2011)
Printing a final order (1997)
Re:listfiles-looking for slick solution (1997)
Starting from scratch (2002)
Displaying photo attached to first record (1997)
credit card authorization question (1997)
bug in listwords? (1998)
Search in 2 or more catalogs (1997)
Commitdatabase tag (1998)
RE: Signal Raised (1997)
japanese characters (1997)
Calendar (1997)
[FileInfo] strangeness (1998)
suffix mapping for NT? (1997)
Carts in Admin folder? (1999)
WebDNA 4.5.1 Now Available (2003)
$Replace with [founditems] (1997)
webcatalog 2.1.3 ACGI Weirdness? (1998)
No subject given (2000)
Any problem with using a g4 with WebCat (2000)