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:

HMAC-MD5 hash -- what the... (2003) Weird error/limit - something amiss? (1997) [Announce]: Web server security and password protection (1997) Sort Order on a page search (1997) WebCatalog 4.0.2b5 available (2000) quantity minimum problem (1997) WebDNA Promo Sound Bite (2003) Tech question about web dna actions (1998) WCS Newbie question (1997) Orderfile context problem (1998) osx or redhat and / or other (2005) Bug Report, maybe (1997) Search repost: (2000) PCS Frames (1997) Secure Server basic question... (1997) different show next (1997) flushdatabases (1997) Typhoon/Pro do SQL? (2001) PC site chck pls (2003) Shownext never shows next...still (1997)