Re: ADO q

Hello,

This looks very strange.
The only thing I can think of is language.
Are both servers using the same regional settings?

Other question: are both servers accessing the same type of dabase? (I
presume they do.)
Are both servers accessed by and ASP, and VB6?

That said, I think it is a bad idea to show the end user the error
message(description).
These messages are very cryptic, most end users will not understand. And
those users that do understand, will not like the message.
I find it better to give a nice (localized)message, that also explains
them how they can prevend this from happening.

Even better; try to fix it (in the errorhandler) and re-insert the
record, so they don't even see the message (if that is possible.)


Greetings,
Yves Hanoulle, IT-Guide, MCSD, MCP C#
www.ObjectSoft.be


-----Original Message-----
From: Technical discussion of VBCOM [mailto:[email protected]]
On Behalf Of Pradeep Jayanna
Sent: Wednesday, June 19, 2002 3:29 PM
To: [email protected]
Subject: [VBCOM]


HI,
We are having a problem with the ADO object. We have written a code
(both in ASP and also VB) that accesses a database and tries to insert a
duplicate record into a table that has a primary key constraint. In the
error handler part, we thought of displaying the error number and the
error description to the user. We executed the same code in two servers
(both of them are WIN2k Advanced Servers, IIS 5.0, having the same
configuration and the same version (2.6) of MDAC).  In one server we are
getting both the error number and the error description and in another
we get only the error number and not the error description.

Not only for this, for all the operations that raises the error we are
able to get the error number and not the description. Can you please
tell me why we didn't get the error description in the other server?

Waiting for your reply
- Ayyappan/Pradeep

You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.

You can read messages from the VBCOM archive, unsubscribe from VBCOM, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.