Windows XP, IE6 (friendly errors turned off), Server is NT4, SP6a, SQL Server 7.
Cheers Sam Thompson ---------------------------------------------- 2cs Communications Ltd http://www.2cs.com [EMAIL PROTECTED] T: 01473 622263 F: 01473 622515 ----------------------------------------------- ----- Original Message ----- From: "Alex Elger" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, September 02, 2002 10:07 AM Subject: RE: lame db errors > So..... what browser are you running? > > Alex Elger > Micronage Ltd > [EMAIL PROTECTED] > > > -----Original Message----- > From: Sam Thompson [mailto:[EMAIL PROTECTED]] > Sent: 02 September 2002 9: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.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
