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 PROTECTED]
