This question is locked. New answers and comments are not allowed.
I have various projects in my solution that are using OA to get at my datastore, for example my "DAL" project. Also, my DAL_Tests project. Now what I want to be able to do is run the data access through a config file so that the user can change a server or password, etc., without me having to come in and recompile.
What's happening is that OA seems to bomb with "The assembly 'DAL' does not have a config file with an openaccess node" if I set the app.config in each of the projects to "None". I use this setting so that a nice clean XML ".config" file will be generated in the build and placed into the bin directory. If I change the BuildAction of the App.config files to "EmbeddedResource" then everything runs fine. But that doesn't work for me, since the server connection settings in that case are embedded inside the DLL's for each project (i.e. they're not changeable by the user).
Does OA have some requirement that the config info be embedded inside the backend DLL's? How can I configure this so that everything is inside one or more XML config files?
What's happening is that OA seems to bomb with "The assembly 'DAL' does not have a config file with an openaccess node" if I set the app.config in each of the projects to "None". I use this setting so that a nice clean XML ".config" file will be generated in the build and placed into the bin directory. If I change the BuildAction of the App.config files to "EmbeddedResource" then everything runs fine. But that doesn't work for me, since the server connection settings in that case are embedded inside the DLL's for each project (i.e. they're not changeable by the user).
Does OA have some requirement that the config info be embedded inside the backend DLL's? How can I configure this so that everything is inside one or more XML config files?