How to display SQLServer error messages?

Simply put

This is the error message that I get when I use the wrong credentials to log in to my sql server 2000 database, via ASP login page.

Code: Technical Information (for support personnel) Error Type: (0x80040E14) /baselogin.asp, line 11 What I need it was something like this:

Code: Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E14) Column 'tblCustomers.cust_id' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause. /baselogin.asp, line 11 Why can't I get a full error message

I'm using Win2k Advanced Server, and MS SQL 2000.

I've tried disabeling: "Friedly HTTP error messages" in internet explorer
I've tried enabeling: "Send detailed ASP error message to client" in iss default web site properties

Can someone help me

Posted On: Monday 26th of November 2012 01:40:04 AM Total Views:  291
View Complete with Replies

Related Messages:

Syntax error converting datetime from character string   (335 Views)
hi I'm having problem with sql query i'll explain u what i'm trying to do when a user sends enquiry for a product it goes to table propertyhittable where hitid the index. if the receiver replies to the enquiry, his reply goes to table mailbox and all subsequent mail correspondence goes to mailbox. now on my Inbox Page i have to dispaly all the enquiries like gmail (each mail clustered with all past correspondence) I used the following query: select HitId,hitid as mailid,Login_Id,Star,Subject,Prop_Code,visitdate, replydate,mailread from propertyhittable where login_id'71727' and deleted=0 and prop_code in (select prop_code from resi_sell where login_id='71727' union select prop_code from comm_sell where login_id='71727' union select prop_code from land_sell where login_id='71727') union (select mb1.Login_Id,mb1.Star,mb1.Subject,mb1.Prop_Code,mb 1.maildate as visitdate, mb1.maildate as replydate,mb1.mailread,mb2.hitid,mb2.mailid from (select hitid,max(mailid) as mailid from mailbox group by hitid) as mb2 inner join mailbox as mb1 on mb1.hitid = mb2.hitid and mb2.mailid = mb1.mailid where login_id71727 and deleted=0 and mb2.hitid in (select hitid from propertyhittable where login_id='71727') ) order by replydate desc i got Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string.
Advance features of sqlserver2005 over SQL server 2000?   (298 Views)
Can any one list the features .. Thankx..
Microsoft OLE DB Provider for ODBC Drivers error '80004005'   (349 Views)
I received an error message that I can't seem to resolve. The following: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Text Driver] Query must have at least one destination field. /process1.asp, line 16 Any assistance with the above will be greatly appreciated.
Incorrect Syntax error   (271 Views)
I amgetting this error in SQL. Error in SELECT clause: expression near '='. Missing FROM clause. Missing or incomplete SELECT clause. Unable to parse query text. Code: SELECT dbo.TestResult.RunId, dbo.TestResult.TestName AS Project, dbo.TestResult.IsRunnable, dbo.TestResult.Owner, dbo.TestResult.CategoryFullName, dbo.TestResult.CategoryId, dbo.TestResult.StartTime, dbo.TestResult.EndTime, dbo.TestResult.SubTestCount, dbo.TestResult.SubTestPass, dbo.TestRun.Name, dbo.TestRun.FileStorage, dbo.TestRun.TestsTotal, dbo.TestRun.TestsExecuted, dbo.TestRun.TestsPassed, dbo.TestRun.TestsCompleted, dbo.TestRun.TestsFailed, dbo.TestRun.TestsNotRun, dbo.TestRun.TestsInconclusive, dbo.TestRun.TestsAborted, dbo.TestRun.RunUser, dbo.TestRun.PublishUser, dbo.TestRun.DateCreated, dbo.TestRun.DateQueued, dbo.TestRun.DateStarted, dbo.TestRun.DateFinished, dbo.TestRun.RunHasCoverage, dbo.TestRun.RunPassed, dbo.TestRun.BuildUri, dbo.TestRun.TeamProject, NSEQAEngine.dbo.TestProducts.Product AS Product, NSEQAEngine.dbo.TestProducts.Script AS Script, NSEQAEngine.dbo.TestProducts.Component, NSEQAEngine.dbo.TestProducts.Description, NSEQAEngine.dbo.TestProducts.Responsible, NSEQAEngine.dbo.TestProducts.ResponsibleEmail, NSEQAEngine.dbo.TestProducts.Manual, NSEQAEngine.dbo.TestProducts.Comment, dbo.TestResult.TestOutcome As Status = CASE WHEN dbo.TestResult.TestOutcome = 'Completed' THEN 'Passed' WHEN dbo.TestResult.TestOutcome = 'Failed' THEN 'Failed' WHEN dbo.TestResult.TestOutcome = 'Incomplete' THEN 'Debatable' WHEN dbo.TestResult.TestOutcome Is null THEN 'Debatable' END, dbo.TestResult.TestType = CASE WHEN dbo.TestResult.Testtype = 'Unknown' THEN 'TestComplete' WHEN dbo.TestResult.Testtype = 'other' THEN 'NSE QA Portal Test Type' WHEN dbo.TestResult.Testtype Is null THEN 'Invalid' END, FROM dbo.TestResult INNER JOIN dbo.TestRun ON dbo.TestResult.RunId = dbo.TestRun.RunId LEFT OUTER JOIN NSEQAEngine.dbo.TestProducts ON dbo.TestResult.RunId = NSEQAEngine.dbo.TestProducts.RunID WHERE (NSEQAEngine.dbo.TestProducts.Component '')
UPDATE: worked around the code = 3001 error   (228 Views)
I replaced the recordset command line with adCmdTableDirect and it fixed that error right up. I have another error now.. I'm a SQL noob any help is appriciated. -- Database error Procedure = usp_Childs_Name The database could not retrieve the Birth record(s) because of the following unexpected error: Procedure 'usp_Childs_Name' expects parameter '@ChildsLast', which was not supplied. Microsoft OLE DB Provider for SQL Server Return code = -2147217904
what's the error in my mssql statement? :(   (237 Views)
hi i always used this type of command PHP Code: response.write("") response.write("") response.write("") response.write("") response.write("") to send out my data to mssql.. but problems will occur when the users fill in the CommonName fields with values with whitespaces and/or ' how should i fix this in java there's some method called preparedstatement.. how about in asp any help is greatly appreciated.
Syntax error near keyword 'BEGIN'   (196 Views)
never mind
error checking in ASP   (244 Views)
hi !! i have another problem in my coding... how can i add an error checking in my page because i have a customer registration page where a customer will input items the page... how can i have an error checking in the page, just like having an error like "username should not be more than 12 characters" or to have an error checking account like "the password you have entered is not the same" because there will be a field with "password" and "re-type password..."
Timeout expired error on SQL Server query with subquery   (380 Views)
hi, i have an ASP page that is querying an SQL database, and a SQL timeout expired '80040e31' error occurs on the line. The query is resonably standard, except there is a correlated subquery to do a COUNT of 'other users' who registered lately against the same school. Is there a way to make the query more efficient, (uncorrelate the subquery or something) so that the timeout error does not occur I could take out the subquery, and then do a seperate query on each userID to see if there are 'other users' for that user, but i think that might be less efficient than using the subquery (only about 1 in 10 users has 'other users'). The users table has about 40000 records, and no field is very large, varchar 300 would be about the biggest.
ORA-12560: TNS:protocol adapter error   (221 Views)
hi ppl, i tried to connect oracle server installed in a remote machine located in the same network and oracle client is installed in my local machine. when i try to execute the SQL statements from my client machine i am experiencing the following problem :- ERROR: ORA-12560: TNSrotocol adapter error i had given the oracle server machine's IP address correctly in the "Net Configuration Assistant". kindly reply me at the earliest, regards, Ramamoorthy
How to trap error for duplicate key   (246 Views)
With VFP, I have created a Form based on remote view of a table in MS SQL Database, that have a primary key. If the record is new, after I have enter the primary key, I need to control if the code exist already. I have not problem with the dbf file, but I have some difficulty with SQL database. Someone can help me, in order to resolve this problem Thank you. Best
Timeout error   (209 Views)
I have an excel program that runs every 10 minutes that gets data from files and inserts it in a table in the SQL server. Most of the time it runs ok. However when the network has heavy use, it generates a "Timeout" error. How do I prevent this