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 iscase sensitive, or the username or Password was incorrect. . .Some ODBC drivers require that you specify that the Username & Password areabbreviated:[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 thespecifics.> Hey Smith Micro, how about returning more verbose SQL errors.Webcatalog will return any error that the ODBC driver feeds it. . .it isvery cool in that manner. . .Rob----------------------------------------------------------------Rob BlairManager of Web TechnologyICSDNA, LLC.Post Office Box 75501Colorado Springs, Colorado 80970-5501rblair@icsdna.com Home 719.579.9442AIM- roblair1 Cell 719.930.9571WAP & HTTP: www.icsdna.com FAX 208.485.0397Lat: 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:
Hello,I got that message when I had the wrong declaration for the dsn-which iscase sensitive, or the username or Password was incorrect. . .Some ODBC drivers require that you specify that the Username & Password areabbreviated:[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 thespecifics.> Hey Smith Micro, how about returning more verbose SQL errors.Webcatalog will return any error that the ODBC driver feeds it. . .it isvery cool in that manner. . .Rob----------------------------------------------------------------Rob BlairManager of Web TechnologyICSDNA, LLC.Post Office Box 75501Colorado Springs, Colorado 80970-5501rblair@icsdna.com Home 719.579.9442AIM- roblair1 Cell 719.930.9571WAP & HTTP: www.icsdna.com FAX 208.485.0397Lat: 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)