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 & MySQL see 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 error which is returned for all other SQL problems SQL Error: 00000isql works on all 6 server talking to all 6 MySQL db's this 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 mode the 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:

    
  1. Re: Q: Linux WebCat to ODBC (Rob Blair 2001)
  2. Q: Linux WebCat to ODBC (Jim Lanford 2001)
Hi, I've set up 6 RH linux servers with ODBC & MySQL see 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 error which is returned for all other SQL problems SQL Error: 00000isql works on all 6 server talking to all 6 MySQL db's this 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 mode the 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)