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