I have taken over a project that was developed in Sharepoint Designer 2007 with about 10 .aspx pages. The problem is that these pages have data sources embedded in them(inline). The datasources have explicit server/username/password information in them.
So, when we want to move this from dev to test to prod I have to create the backup .cmp file from dev and restore it to test. However test is using a different database along with different login credentials so I have to manually change the datasource info.
So my question is, how can I create a variable in the web.config file to specify this datasource connection so it is not hard coded in the inline aspx page.
Remember these pages do NOT have code behind. They were developed in Sharepoint designer 2007 using the GUI.
I have tried adding a <key> or a <connectionStrings> item in the web.config file in hopes that the .aspx page would recognize it and problem solved. When I reference the item in the .aspx page as <%$ ConnectionStrings:dbname %> it
just does not recognize it.
Please help, under some pressure here.
View Complete Post