What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

WC2.0 Memory Requirements (1997) truncating email part II (1997) RE: Can a database get stomped by simultaneous access? (1997) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) [ShowNext] feature in 2.0 (1997) Cool new site (1996) Need help... (1997) Assigning new CART number (1997) Append is limiting the Number of Characters written to db (fwd) (1998) MacOS X 10.2.2 (2002) setitems, one more thing (1997) Internet Explorer and caching (2000) Search for value or blank? (2004) ShowNext (1997) [LOOKUP] (1997) SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) Emailer (1997) READFILE command? (1998) RE: Any limit to [include] (1997) Target wit redirect (1998)