Access shared data source inside custom assembly

• M Chabot

  SSCrazy

  Points: 2511

  More actions

  October 15, 2006 at 12:58 am

  #117210

  I have a database connection string hard-coded in a SQL Server 2005 Reporting Services custom assembly. Since the connection string is environment-specific (dev/prod), I would like to read the connections string from a settings file, like is typically done for web.config. Using the shared data source is also a good option.

   

  How do I accomplish this?

   

  I looked into trying to use DataSourceReference(), but that does not seem to be allowed inside of a custom assembly. Thank you.

• Lisa Slater Nicholls

  Hall of Fame

  Points: 3455

  More actions

  October 16, 2006 at 9:55 am

  #666040

  Any VB .NET DLL should be able to have a "Settings" file, not just a asp.net application.  They look similar to web.config.

  I don't know what environment you're developing in, but in Visual Studio, go to the project explorer.  Select My Project, look at the Settings tab.

  In code, check out the System.Configuration namespace in the .NET framework.

  >L<