Re: Q: Linux WebCat to ODBC

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37622
interpreted = N
texte = Hello,I got that message when I had the wrong declaration for the dsn-which is case sensitive, or the username or Password was incorrect. . .Some ODBC drivers require that you specify that the Username & Password are abbreviated:[SQL dsn=PubDB&user=user1&pass=mypass&statement=SELECT * from...Or[SQL dsn=PubDB&usr=user1&pw=mypass&statement=SELECT * from...I would check the Docs for the ODBC driver that you are using for the specifics.> Hey Smith Micro, how about returning more verbose SQL errors.Webcatalog will return any error that the ODBC driver feeds it. . .it is very cool in that manner. . . Rob ---------------------------------------------------------------- Rob Blair Manager of Web Technology ICSDNA, LLC. Post Office Box 75501 Colorado Springs, Colorado 80970-5501 rblair@icsdna.com Home 719.579.9442 AIM- roblair1 Cell 719.930.9571 WAP & HTTP: www.icsdna.com FAX 208.485.0397 Lat: 38.769719 Lon: -104.799829 --------------------------------------------------------------- > 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: 00000 > > isql 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 mode > > Q: 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/ ------------------------------------------------------------- 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)
Hello,I got that message when I had the wrong declaration for the dsn-which is case sensitive, or the username or Password was incorrect. . .Some ODBC drivers require that you specify that the Username & Password are abbreviated:[SQL dsn=PubDB&user=user1&pass=mypass&statement=SELECT * from...Or[SQL dsn=PubDB&usr=user1&pw=mypass&statement=SELECT * from...I would check the Docs for the ODBC driver that you are using for the specifics.> Hey Smith Micro, how about returning more verbose SQL errors.Webcatalog will return any error that the ODBC driver feeds it. . .it is very cool in that manner. . . Rob ---------------------------------------------------------------- Rob Blair Manager of Web Technology ICSDNA, LLC. Post Office Box 75501 Colorado Springs, Colorado 80970-5501 rblair@icsdna.com Home 719.579.9442 AIM- roblair1 Cell 719.930.9571 WAP & HTTP: www.icsdna.com FAX 208.485.0397 Lat: 38.769719 Lon: -104.799829 --------------------------------------------------------------- > 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: 00000 > > isql 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 mode > > Q: 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/ ------------------------------------------------------------- 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/ Rob Blair

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:

carriage returns in data (1997) HELP WITH DATES (1997) Document Contains No Data msg (1997) Sorting by date (1997) carriage returns in data (1997) WebCat2: Found Items syntax, etc. (1997) [WebDNA] [MATH] strangeness (2013) Loss in form (1998) [WebDNA] Chrome 56 character encoding (2017) WCS Newbie question (1997) RE: shrink-wrapped version out yet? (1997) Pop-up Menu (1998) Help name our technology! (1997) WebCat2 several catalogs? (1997) Field names beginning with Reg.. (2002) DataBaseHelper Flawed (1997) security (1997) ImageMagick and [shell] (2003) Fun with Dates - revisited (1997) referrer usage (1997)