Silent DSN For SQL

[LouieGrandie]

I have a Crystal report that uses SQL as the data source. I am going to use a business monitoring software to run and distribute the report. My problem is that I need a "silent" DSN so that when there is no log in prompt for SQL. How would I do that? The DSNs I have created don't see to hold the password when I save it.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[fredericofonseca]

see

http://www.connectionstrings.com/sql-server/

you just need to specify your full connection string on your connection object, not on a DSN

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886