DevForce Community Forum : Connection String and Environments http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Connection String and Environments Thu, 11 Jun 2026 05:22:47 -700 Thu, 15 Nov 2007 11:49:50 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=549 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Connection String and Environments : To solve your problem go to the... http://www.ideablade.com/forum/forum_posts.asp?TID=549&PID=1948#1948 Author: davidklitzke
Subject: 549
Posted: 15-Nov-2007 at 11:49am

To solve your problem go to the documentation and read about Data Source Keys and the DataSourceKeyResolver.  Instead of using an embbeded (or loose) ibconfig file which contains a static string, you will define a method which will retrieve a connection string.  You can be as resourceful as you want in this method.  The connection string may be embedded in a file or be imported from a Web Service or database.  You can decide to use or not to use encryption.

Edited by davidklitzke - 15-Nov-2007 at 7:22pm]]> Thu, 15 Nov 2007 11:49:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=549&PID=1948#1948 Connection String and Environments : My application currently is two... http://www.ideablade.com/forum/forum_posts.asp?TID=549&PID=1946#1946 Author: Makani
Subject: 549
Posted: 15-Nov-2007 at 8:58am

My application currently is two tiers with a Windows client deployed through ClickOnce connecting directly to the database.  I am wondering how to manage connection strings during deployment to different environments and have a couple of questions.
 
Currently the connection string is an embedded resource within the AppHelper assembly.  Is it possible to extract embedded text file from a dll.  Should I encrypt that resource?
 
If I leave the file unencrypted and as an embedded resource how can I allow an administrator to modify the connection string to the appropriat environment.?  Custom config app that builds the AppHelper.dll or maybe just have the admin use the .net compiler, MSBuild? Anyone have code or an example.
 
Thanks,
Mike
 
 
 
]]> Thu, 15 Nov 2007 08:58:57 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=549&PID=1946#1946