December 12, 2003 at 12:15 pm
Hi,
I have to servers running IIS 5.0 and using ADO OLE DB connections against a SQL2K DB (the same). The first server returns ADO errors this way:
ADO error message when using the first server:
error '80040e14'
/contratos/MudaEndEspItemContrato_Dados.asp, line 65
ADO error message in the second server:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Cliente de instalação 99999 não encontrado! Operaçao Cancelada!
/contratos/MudaEndEspItemContrato_Dados.asp, line 64
Why do the first server don't return the description of the error?
PS: The message displayed above is result of a RAISEERROR command (it's in portuguese). But the regular error messages descriptions of SQL Server doesn't appear too.
Tks,
Alexandre Vianna
December 15, 2003 at 2:57 am
The trappable error generated by ADO is more of a general error. The specific SQL error message (and number) is contained in the Connection.Errors collection.
--
Chris Hedgate @ Extralives (http://www.extralives.com/)
Co-author of Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)
Articles: http://www.sqlservercentral.com/columnists/chedgate/
December 16, 2003 at 7:34 am
Chris,
Thanks for your answer but I know that the specific SQL error message is in the Connection.Errors. What i don't know is why the two servers running ASP pages in IIS 5.0 have different behaviors. Since both are testing servers, it's important to me that both returns the complete error messages without any additional programming.
Tks,
Alexandre Vianna
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply