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:

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)