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:
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)