ODBC Connection to SQL Server 7

[MrMystery]

Hi.
I use SQL authentication on my SQL Server installation, and I need to distribute a Crystal Report to multiple users. I don't want them to have to enter the SQL user id and password each time they run the report. Is there any way I can store the user id and password somewhere either in the report itself or the ODBC connection?
Any help appreciated!

 

[MaffewW]

I dont think you can save the password in the connection if using SQL authentication you need to use a trusted connection and windows authentication unless anyone else knows another way

Matt

Brighton, UK