Groups | Blog | Home
all groups > sql server connect > july 2003 >

sql server connect : how to avoid SQL server login dialog box


Raj
7/3/2003 12:56:27 PM
I am using crystal reports. I have created crystal
dictionary using some odbc dsn name . when users use this
dictionary to create report . they get the login dialog
box prompting to enter database username / password. Is
there any way to avoid it. Such that all information is
embeded in the odbc dsn itself. so that when anybody uses
that dsn they directly connect to the database and get
output report.

Thank You
<nntp>
7/3/2003 1:16:33 PM
try changing the DSN to a trusted connection and granting the report users'
NT accounts the appropriate permissions on SQL

[quoted text, click to view]

raj
7/3/2003 2:01:06 PM
The users are on windows 95 / 98. So we cannot give
windows NT authentication. Is there any way to save
username / password info in the DSN. And use that dsn to
connect.



[quoted text, click to view]
AddThis Social Bookmark Button