Relink ODBC via code with passwords

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about 150 users on an Novell network that I need to link into a SQL server. If I create a user name for each person on the SQL server I can connect to it. But I would rather use one generic account as all of the users are 'Read Only'. Right now everytime a user opens the database the ODBC connection asks for a password.

Is it possible to open the database and supply the user id and password automatically? or do I need to create the accounts?

Any help would be greatly appreciated.

Thanks
Steve
 
Back
Top