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