Connection String trouble in .Net

[EddieBob]

Hi!

I hope someone can help me here. I have this line in my app.config file

<add key="GEN_DbDsn" value="Data Source=datafeeds;"/>

where datafeeds is a DSN that is setup and working (tested it when setting it up). When debugging the error I get is that the database is invalid or cannot be found. When I change the code in app.config to be

<add key="GEN_DbDsn" value="Address=server\instance;Trusted_Connection=True;Database=b2b;Connect Timeout=180;"/>

which accesses the same server and database that the DSN tries to access, it works. Due to security issues, I need to use a DSN and not have user id and password in the connection string.

Any ideas?

Thanks!

 

[cjard]

Would you not rather have your connection string as an application parameter, and encrypt that part of the config file? It means you can do away with the DSN, which is a very good thing!

http://www.velocityreviews.com/forums/t69285-database-connectivity-using-dsn.html

 

[Gruntie776]

Due to security issues, I need to use a DSN and not have user id and password in the connection string.

I am pretty sure anyone who can access a dsn can examine its properties and so defeats your security.

If your data is that sensitive you need to set up a proper security mechanism.