Sam did you have trouble finding information about this on the MSDN site and other sources? Search MSDN for all words "VBScript error handling". Most VBScript errors occur in interaction with objects such as ADO, which like many well-constructed objects has an errors collection you can read. The MSDN site has much information and examples about how to do this.
-----Original Message----- From: Sam Thompson [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 4:12 AM To: ActiveServerPages Subject: Re: lame db errors Thanks for the replies, i know theres a problem with the code and i know how to fix it. What I really want tho is a full error message, not just error '80040e14' /Local.asp, line 122 ...so when other errors occur, at least i'll know why! does executing my query like this make a different to the type of error message? strQuery = "INSERT blah blah" Set objRS = objConn.Execute(strQuery) Cheers Sam Thompson ---------------------------------------------- 2cs Communications Ltd http://www.2cs.com [EMAIL PROTECTED] T: 01473 622263 F: 01473 622515 ----------------------------------------------- ----- Original Message ----- From: "Showbear" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, August 30, 2002 3:01 PM Subject: RE: lame db errors > > Sam, the current MSDN Library has 44 documents containing a reference > to 80040e14 and a quick scan suggests that at least 1/3 of them could > possibly apply to your problem, but we don't know enough about your > code to know which may offer the solution. It's always best to post > ALL related code. > > > > -----Original Message----- > From: Tim Fletcher [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 30, 2002 8:58 AM > To: ActiveServerPages > Subject: RE: lame db errors > > > just a thought :) > error '80040e14' is an INSERT statment error. > have you tried creating a view with the SQL statment in the SQL > console? it sometimes comes up with more precise answers. > > > -----Message d'origine----- > De : Sam Thompson [mailto:[EMAIL PROTECTED]] > Envoy� : vendredi 30 ao�t 2002 14:36 > � : ActiveServerPages > Objet : Re: lame db errors > > > Thanks Dave. I got rid of the driver line but the error message is > still the same. > > Line 122 is where the query gets executed. The reason i supplied the > connection string is because I thought the type of error messages > returned depended on the type of provider I used. Is that correct? > > Cheers > > Sam Thompson > ---------------------------------------------- > 2cs Communications Ltd > http://www.2cs.com > [EMAIL PROTECTED] > T: 01473 622263 > F: 01473 622515 > ----------------------------------------------- > ----- Original Message ----- > From: "David L. Penton" <[EMAIL PROTECTED]> > To: "ActiveServerPages" <[EMAIL PROTECTED]> > Sent: Friday, August 30, 2002 1:10 PM > Subject: RE: lame db errors > > > > Well, one thing you could switch from ODBC to OLE-DB (drop the > > driver > line) > > > > Also, what is line 122? I am pretty sure the connection string > > isn't line 122 :-) > > > > David L. Penton, Microsoft MVP > > JCPenney Technical Specialist / Lead > > "Mathematics is music for the mind, and Music is Mathematics for the > > Soul. - J.S. Bach" [EMAIL PROTECTED] > > > > Do you have the VBScript Docs or SQL BOL installed? If not, why > > not? VBScript Docs: http://www.davidpenton.com/vbscript > > SQL BOL: http://www.davidpenton.com/sqlbol > > > > -----Original Message----- > > From: Sam Thompson [mailto:[EMAIL PROTECTED]] > > > > Hi, > > Im using NT4 Server, SQL Server 7 and im getting very basic database > related > > error messages, like this: > > > > error '80040e14' > > /Local.asp, line 122 > > > > my connection string looks like this: > > > > strConn = "driver={SQL Server}; provider=sqloledb; Initial > > Catalog=DBNAME; server=SERVERNAME; user id=XXX; password=XXX;" > > > > Any ideas how I can get it to display a proper full error message? > > > > Thanks > > > > Sam Thompson > > ---------------------------------------------- > > 2cs Communications Ltd > > http://www.2cs.com > > [EMAIL PROTECTED] > > T: 01473 622263 > > F: 01473 622515 > > ----------------------------------------------- > > > > > > --- > > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To > > unsubscribe send a blank email to > %%email.unsub%% > > > > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > %%email.unsub%% > > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > %%email.unsub%% > > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To > unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
