Re: OT: Need (a tiny bit) of help setting up MySQL
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26857
interpreted = N
texte = At 10:45 AM 2/1/00 -0800, you wrote: > >Good catch. It probably should be. Unfortunately, that change didn't make > >a difference.... (here's my full log from a single SQL request) > >I still get the same problem.... > > >DBServer fff86397:fff87cfb EXIT SQLConnectW with return code > >-1 (SQL_ERROR) > >This part doesn't look good. What tool (other than WebCatalog) are >you using to test the DSN to make sure it's really working? Can you >get me a URL where I can grab mySQL and install it?mySQL is available (for win98) at : http://www.mysql.com/Downloads/Win32/mysql-shareware-3.22.30-win.zip myODBC is available (for win98) at: http://mysql.com/download_myodbc.htmlNow, here's the odd thing. To test it, I used Access. Access couldn't talk to the database unless I removed the username and password from the DSN (maybe I just didn't configure that right)....anyway, after removing the username and password, it grabbed the tables fine.With webcat, if I removed the username and password from the DSN, SQL worked fine, or if I said [SQL dsn=news&username=&password=&statement=SELECT * from table01] it worked fine.Even if I had a username and password defined in the DSN, but I just said username=&password=& in the context, the SQL still worked.However, if I had a username:password combo defined in the DSN to be howard:test, and then said [SQL dsn=news&username=howard&password=test&statement=SELECT * from table01] it would not work.Now, I don't know if this is a bug with webcat, or an error in my configuration, but at least for now I have the ability to play with the SQL....=============================================== Howard Wolosky Webcatalog Consultant+The Pubb - The best solution for your messageboard needs. Written in 100% Webcat. (www.thepubb.com) ===============================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
At 10:45 AM 2/1/00 -0800, you wrote: > >Good catch. It probably should be. Unfortunately, that change didn't make > >a difference.... (here's my full log from a single SQL request) > >I still get the same problem.... > > >DBServer fff86397:fff87cfb EXIT SQLConnectW with return code > >-1 (SQL_ERROR) > >This part doesn't look good. What tool (other than WebCatalog) are >you using to test the DSN to make sure it's really working? Can you >get me a URL where I can grab mySQL and install it?mySQL is available (for win98) at : http://www.mysql.com/Downloads/Win32/mysql-shareware-3.22.30-win.zip myODBC is available (for win98) at: http://mysql.com/download_myODBC.htmlNow, here's the odd thing. To test it, I used Access. Access couldn't talk to the database unless I removed the username and password from the DSN (maybe I just didn't configure that right)....anyway, after removing the username and password, it grabbed the tables fine.With webcat, if I removed the username and password from the DSN, SQL worked fine, or if I said [SQL dsn=news&username=&password=&statement=SELECT * from table01] it worked fine.Even if I had a username and password defined in the DSN, but I just said username=&password=& in the context, the SQL still worked.However, if I had a username:password combo defined in the DSN to be howard:test, and then said [SQL dsn=news&username=howard&password=test&statement=SELECT * from table01] it would not work.Now, I don't know if this is a bug with webcat, or an error in my configuration, but at least for now I have the ability to play with the SQL....=============================================== Howard Wolosky Webcatalog Consultant+The Pubb - The best solution for your messageboard needs. Written in 100% Webcat. (www.thepubb.com) ===============================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Howard Wolosky
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:
if/then/else in founditems (2001)
no global [username] or [password] displayed ... (1997)
Nested tags count question (1997)
large database (2000)
Updating checkboxes made easy !!! (1998)
Multiple prices (1997)
Location of Webcat site in folder hierarchy (1997)
email [title] (1997)
Strange intermittent WebDNA problems (2008)
oops private message leaked into talk list (1997)
protect tag on NT IIS (1997)
Virtual hosting and webcatNT (1997)
How to Display text in empty fields (1997)
Plugin or CGI or both (1997)
[convertchars] on potential malicious input even in a link? (2000)
looping through the headers of an orderfile (2000)
Setting up WebCatalog with Retail Pro data (1996)
emailer (1997)
WebCatalog for guestbook ? (1997)
No more misunderstanding ... yay! :) (1997)