A user goes into the ODBC Connection Manager and deletes the DSN. Hence, you app is broken.

Can't get much simpler than that.....



>>My suggestion is to NOT use a DSN. It is too easy for your application to break.
>
>
>Why would it be too easy to break? You set it up and its there. If the data moves then you would have to change your string also, right? Now if your saying that you don't have access to that PC or that the user is incapable of setting this one time DSN up, then I agree, use a string. But if I have easy access to the PC..? I have never had a problem using DSN. Am I just lucky?
>
>Jeff