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:

Limiting user access to .tmpl files (1997) refreshing IE with posted .tmpl (1997) Username for Admin Group (1997) Re2: frames & carts (1997) Order not created error (never mind) (1997) RE: [WebDNA] RE: tcp connect to check domain names (2009) Credit card types (1997) Updating a database once per day - An example (1998) [WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019) Sorting Numbers (1997) japanese characters (1997) A question on sub-categories (1997) type 2 errors with ssl server (1997) [ShowNext] feature in 2.0 (1997) Bug or syntax error on my part? (1997) Shipcost lookup? (1997) Opinion: [input] should be called [output] ... (1997) purchase.log file (1997) Umm...about those log files? (Off Topic) (1997) Emailer (1997)