OT: Need (a tiny bit) of help setting up MySQL

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26801
interpreted = N
texte = I realize this a little off topic, but I thought I'd try you guys first before heading over to the MySQL list (since my trouble seems to be with webcat)... I'm trying to set up MySQL on my home machine (Win 98) so I can start doing some SQL webcat stuff, but I'm running into a problem...I have MySQL properly installed, and I installed MyODBC to get the MySQL ODBC driver installed. I configured a user DSN according to the manual and everything on that end seems fine. My databases and tables are all good, and I have the MySQL process started (since I can't have a service on 98).The User DSN looks like this: ------------------------------------------- Windows DSN Name: news MySQL Host (name or IP) : MySQL database: database01 user: admin password: admin Port (if not 3306): SQL command on connect: When running an SQL query through webcat, I get: ------------------------------------------------------------------------- SQL Error: 00000 Found 0 items This is the code on the page: --------------------------------------------- [SQL dsn=news&username=admin&password=admin&statement=SELECT * from table01] Found [NumFound] items
[FoundItems] [field01], [field02], [field03]
[/FoundItems] [/SQL](i also tried the statement with a ; semicolon at the end, but that made no difference)I turned logging on, and here's a snippet of the log showing where the first error occurs: ---------------------------------------------------------------------------- -------------------------------------------------- DBServer fff5f1f1:fff5f3a1 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 0x00ccff1c HDBC * 0x006af798 ( 0x00bd0194)DBServer fff5f1f1:fff5f3a1 ENTER SQLSetConnectOption HDBC 0x00bd0194 UWORD 103 UDWORD 5DBServer fff5f1f1:fff5f3a1 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 0x00bd0194 UWORD 103 UDWORD 5DBServer fff5f1f1:fff5f3a1 ENTER SQLConnectW HDBC 0x00bd0194 WCHAR * 0x00ccfc2c [ -3] news\ 0 SWORD -3 WCHAR * 0x1f4be068 [ -3] ******\ 0 SWORD -3 WCHAR * 0x1f4be068 [ -3] ******\ 0 SWORD -3DBServer fff5f1f1:fff5f3a1 EXIT SQLConnectW with return code -1 (SQL_ERROR) HDBC 0x00bd0194 WCHAR * 0x00ccfc2c [ -3] news\ 0 SWORD -3 WCHAR * 0x1f4be068 [ -3] ******\ 0 SWORD -3 WCHAR * 0x1f4be068 [ -3] ******\ 0 SWORD -3DBServer fff5f1f1:fff5f3a1 ENTER SQLDisconnect HDBC 0x00bd0194I'm just looking for anyone who has had a similar problem (or never had this problem but got it up and running immediately) to give me a little help here in getting this up and running. Off list is perfectly fine. I feel that I'm just *so close* but I must be missing something. Thanks, (and sorry for the long message)=============================================== 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:

    
  1. Re: OT: Need (a tiny bit) of help setting up MySQL (Howard Wolosky 2000)
  2. Re: OT: Need (a tiny bit) of help setting up MySQL (WebDNA Support 2000)
  3. Re: OT: Need (a tiny bit) of help setting up MySQL (Howard Wolosky 2000)
  4. Re: OT: Need (a tiny bit) of help setting up MySQL (PCS Technical Support 2000)
  5. OT: Need (a tiny bit) of help setting up MySQL (Howard Wolosky 2000)
I realize this a little off topic, but I thought I'd try you guys first before heading over to the MySQL list (since my trouble seems to be with webcat)... I'm trying to set up MySQL on my home machine (Win 98) so I can start doing some SQL webcat stuff, but I'm running into a problem...I have MySQL properly installed, and I installed MyODBC to get the MySQL ODBC driver installed. I configured a user DSN according to the manual and everything on that end seems fine. My databases and tables are all good, and I have the MySQL process started (since I can't have a service on 98).The User DSN looks like this: ------------------------------------------- Windows DSN Name: news MySQL Host (name or IP) : MySQL database: database01 user: admin password: admin Port (if not 3306): SQL command on connect: When running an SQL query through webcat, I get: ------------------------------------------------------------------------- SQL Error: 00000 Found 0 items This is the code on the page: --------------------------------------------- [SQL dsn=news&username=admin&password=admin&statement=SELECT * from table01] Found [NumFound] items
[founditems] [field01], [field02], [field03]
[/FoundItems] [/SQL](i also tried the statement with a ; semicolon at the end, but that made no difference)I turned logging on, and here's a snippet of the log showing where the first error occurs: ---------------------------------------------------------------------------- -------------------------------------------------- DBServer fff5f1f1:fff5f3a1 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 0x00ccff1c HDBC * 0x006af798 ( 0x00bd0194)DBServer fff5f1f1:fff5f3a1 ENTER SQLSetConnectOption HDBC 0x00bd0194 UWORD 103 UDWORD 5DBServer fff5f1f1:fff5f3a1 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 0x00bd0194 UWORD 103 UDWORD 5DBServer fff5f1f1:fff5f3a1 ENTER SQLConnectW HDBC 0x00bd0194 WCHAR * 0x00ccfc2c [ -3] news\ 0 SWORD -3 WCHAR * 0x1f4be068 [ -3] ******\ 0 SWORD -3 WCHAR * 0x1f4be068 [ -3] ******\ 0 SWORD -3DBServer fff5f1f1:fff5f3a1 EXIT SQLConnectW with return code -1 (SQL_ERROR) HDBC 0x00bd0194 WCHAR * 0x00ccfc2c [ -3] news\ 0 SWORD -3 WCHAR * 0x1f4be068 [ -3] ******\ 0 SWORD -3 WCHAR * 0x1f4be068 [ -3] ******\ 0 SWORD -3DBServer fff5f1f1:fff5f3a1 ENTER SQLDisconnect HDBC 0x00bd0194I'm just looking for anyone who has had a similar problem (or never had this problem but got it up and running immediately) to give me a little help here in getting this up and running. Off list is perfectly fine. I feel that I'm just *so close* but I must be missing something. Thanks, (and sorry for the long message)=============================================== 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:

requiredfields (2002) [addlineitems] display (1997) [WebDNA] remove preceding zero (2016) RE: Can a database get stomped by simultaneous access? (1997) Error:Too many nested [xxx] contexts (1997) [OT] Certs (2002) WebCat2b13MacPlugIn - syntax to convert date (1997) Long/Lat (2002) japanese characters (1997) semi OT: EditPlus2 WebDNA Keywords and syntax coloring (2002) formula.db problems (1999) RE: Subtotal help (1997) searching problem (1998) Help! WebCat2 bug (1997) Using Cookie for client specific info? (1997) JavaScript (1998) Deleteing Based On Dates (2002) Using [sendmail] for mass mailings (2001) iTools and 3.0.8 (2000) base16 (2005)