I don't think there's anything wrong with your nsd.tcl config.
NSINT is the return code AOLserver uses to indicate a SQL error occurred.
It's defined in dbutil.c:
#define NS_SQLERRORCODE "NSINT" /* SQL error code for AOLserver exceptions.
*/
I think you're giving Sybase a SQL statement that is either not understood
or causes an error in Sybase, which then filters back to AOLserver and the
log file.
You have logsqlerrors set to true; I guess that's why you're seeing the
NSINT in the log file. You'll want to figure out how to identify which SQL
statement causes this error. With nspostgres, I turn on verbose mode. I
don't know if the sybase db module uses the verbose param, but it's worth a
shot:
ns_param verbose true ;# Verbose error
logging
Anyone else here who has some real experience with Sybase and can help
/s.
-+-+-+-+-+-+-+-+-+-+-+-+-
If to err is human, I must be more human than most.
Scott S. Goodwin
u: http://scottg.net
e: [EMAIL PROTECTED]
aim: scottgnet
----- Original Message -----
From: "oetjoen" <[EMAIL PROTECTED]>
To: "AOLserver Discussion" <[EMAIL PROTECTED]>
Sent: Sunday, February 24, 2002 10:06 PM
Subject: Re: Re: [AOLSERVER] Error: nsd.tcl: Database operation "0or1row"
failed (exception NSINT)
> Thanks Scott.. :-)
> Actually I'm using 2 database, Sybase and Oracle. And the problem came
from
> my Sybase not from Oracle (see on dbase1 section).
>
> ********
> ns_section "ns/db/pool/dbase1"
> ns_param driver nssybpd ;# From "ns/db/drivers" list
> ns_param datasource "datasource_name"
> ns_param user "xxxxxx"
> ns_param password "xxxxxx"
> ns_param connections 3 ;# No. of connections to open
> ns_param logsqlerrors true ;# Verbose SQL query error logging
> ns_param maxidle 600 ;# Max time to keep idle db conn open
> ns_param maxopen 3600 ;# Max time to keep active db conn
open
> ********
>
> Do you think there is something wrong on dbase1 section?
> Any way could you explain to me what it does mean with "exception NISNT"
> from email subject?
> Thanks... GBU Cheers...
>
> ----- Original Message -----
> From: Scott S. Goodwin <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, February 21, 2002 10:37 PM
> Subject: Re: [AOLSERVER] Error: nsd.tcl: Database operation "0or1row"
failed
> (exception NSINT)
>
>
> > I'm no Oracle expert, but I suspect you either have a problem in your
SQL
> or
> > there's a bug somewhere.
> >
> > Turn on verbose in the dbase2 section; this should output all of the SQL
> > activity into your log, and you should be able to see which SQL code it
> > breaks on, and any error messages that come from Oracle.
> >
> > /s.
> >
> >
> > -+-+-+-+-+-+-+-+-+-+-+-+-
> > If to err is human, I must be more human than most.
> >
> > Scott S. Goodwin
> > u: http://scottg.net
> > e: [EMAIL PROTECTED]
> > p: 850.897.6830
> > aim: scottgnet
>
