Re: SQL Error: 00000

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59871
interpreted = N
texte = The error code isn't coming out of SQL (it doesn't appear). Also, the = query is definitely failing, so it's not a 'no error' code.=20 I think the error code coming back is really a 'false message' being = generated by the WebDNA engine.=20 > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf = Of > Gary Krockover > Sent: Thursday, November 04, 2004 12:00 AM > To: WebDNA Talk > Subject: Re: SQL Error: 00000 >=20 > I believe it's a "ready" state: >=20 > Returns a null-terminated string containing the SQLSTATE error code = for > the > last error. The error code consists of five characters. '00000' means = ``no > error''. The values are specified by ANSI SQL and ODBC. For a list of > possible values, see section 10.1 Error Returns. >=20 > http://ific.uv.es/informatica/manuales/MySQL-4.1.1/manual_Error- > handling.html#Error-returns >=20 > Could be wrong though, of course. >=20 > GK >=20 > At 10:28 PM 11/3/2004, you wrote: > >Does anyone from SmithMicro monitor this list? > > > >I need some help in determining what generates this error. My best = guess > >is that the WebDNA is having problems making an ODBC connection. > > > >I can run the same exact query repeatedly, and this error will only = occur > >a few times out of every 100 tries. So, it is completely sporadic, = and > >appears to be a BUG of some sort. HELP! >=20 >=20 > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ >=20 > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.786 / Virus Database: 532 - Release Date: 10/29/2004 >=20 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.786 / Virus Database: 532 - Release Date: 10/29/2004 =20 ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL Error: 00000 ( "Doug Deck" 2004)
  2. Re: SQL Error: 00000 ( "Crist, Trevor" 2004)
  3. Re: SQL Error: 00000 ( Gary Krockover 2004)
  4. Re: SQL Error: 00000 ( "Crist, Trevor" 2004)
  5. FW: SQL Error: 00000 ( "Crist, Trevor" 2004)
  6. SQL Error: 00000 ( "Crist, Trevor" 2004)
The error code isn't coming out of SQL (it doesn't appear). Also, the = query is definitely failing, so it's not a 'no error' code.=20 I think the error code coming back is really a 'false message' being = generated by the WebDNA engine.=20 > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf = Of > Gary Krockover > Sent: Thursday, November 04, 2004 12:00 AM > To: WebDNA Talk > Subject: Re: SQL Error: 00000 >=20 > I believe it's a "ready" state: >=20 > Returns a null-terminated string containing the SQLSTATE error code = for > the > last error. The error code consists of five characters. '00000' means = ``no > error''. The values are specified by ANSI SQL and ODBC. For a list of > possible values, see section 10.1 Error Returns. >=20 > http://ific.uv.es/informatica/manuales/MySQL-4.1.1/manual_Error- > handling.html#Error-returns >=20 > Could be wrong though, of course. >=20 > GK >=20 > At 10:28 PM 11/3/2004, you wrote: > >Does anyone from SmithMicro monitor this list? > > > >I need some help in determining what generates this error. My best = guess > >is that the WebDNA is having problems making an ODBC connection. > > > >I can run the same exact query repeatedly, and this error will only = occur > >a few times out of every 100 tries. So, it is completely sporadic, = and > >appears to be a BUG of some sort. HELP! >=20 >=20 > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ >=20 > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.786 / Virus Database: 532 - Release Date: 10/29/2004 >=20 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.786 / Virus Database: 532 - Release Date: 10/29/2004 =20 ------------------------------------------------------------- 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://webdna.smithmicro.com/ "Crist, Trevor"

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:

Nesting format tags (1997) New Command prefs ... (1997) WebCatalog 4.0.1b1 is now available (2000) Cart date/time (2006) NetForms for mail, sorry (1998) Postprocessing CCs (2000) Cancel Subscription (1996) WCS Newbie question (1997) WebMerchant Only reads 1.4 order files error (1997) syntax question, not in online refernce (1997) Trouble with formula.db + more explanation (1997) Extended [ConvertChars] (1997) PIXO Support (1997) If Empty ? (1997) Multipart/form-data and video (2005) Database Options (1997) (no subject) (1997) Re2: Calculating multiple shipping... (1997) [subtotal] and others (1997) WebCommerce: Folder organization ? (1997)