Among the other ways of creating the DSN is through the code in your VB
application. So try setting up the DSN from the VB Code. You can check out
the existing system DSN you have created in the registry and use the
parameter and value within your VB Application along with the password
parameter.
Quote:
> Hi groups! I create one system DSN to access to SQL server 7.0, for some
of
> the reasons I have to use SQL server authentication and enter User ID and
> Password for this ODBC when I create it. The problem I have right now is
> every time I access to the database through that ODBC, it pop up a dialog
> box to ask for password. Does anyone know how to create a system DSN
using
> SQL server authentication but the user ID and password can saved so users
> don't have to enter it again?. Thank you for all responses!.
> Alan.
System DSN ???