SQL Server Login

[wzipp]

Dear all,
i'm trying to establish a connection to a SQL Server 7. Until that point my application works fine, even the vb errorhandling but as soon as i get an error from the server i've no clue how to handle it. For example a wrong password - then the server pops up with the login dialog and i want to prevent that. P.S. I'm using DAO and VB5

thanks

[Bigley]

I don't know much about DAO and VB5 but try using the UID "sa" and leave the password blank. In ADO you could include all this info in a connection string, but as I said I don't know about DAO.

[wzipp]

Dear Bigley and Clunietp,
thanx alot for your tips but i think they wouldn't fix the problem. My problem cames from the fact that the SQL-Server (not the VB engine) is sending me a login-dialog if i use the wrong password or wrong username. All i want to do is to prevent that and the user don't see that login-dialog.
dbDriverNoPrompt didn't worked because it is only worth if i don't want to see the ODBC-dialog with the diffrent DNS.