.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Web.config and Sharepoint Designer 2007 aspx datasource

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint

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

More Related Resource Links

SharePoint Designer 2007 - Customize List View - Error when saving view ASPX page


We have a custom list definition that includes custom site columns.  When we try to open one of the list view aspx pages in SharePoint to update the view query we get an error when trying to save the page in SharePoint Designer 2007.  We receive a warning that the operation will customize the page from the site definition, which is fine.  And then get a general "Server error: ServiceRequestorID" alert.  ServiceRequestorID is a custom site column used by the list definition.

ServiceRequestorID field definition:

<Field ID="{FA39D24D-AB40-4b1d-BD80-94ABE34A7578}" Name="ServiceRequestorID" DisplayName="Service Requestor ID" StaticName="

Trying to send email using Sharepoint Designer 2007 workflow and email enabled list


I have a a list that recieves email. I have few fields that shows me the originator: "E-Mail From" and "E-Mail Sender".

I am trying to create a workflow that will generate an auto reply to the originator but the SPD fails to recognize the email address in these two fields. It's either truncating part of it or uses the html ( href=mailto:Demo@DemoSomething.com) in the To field.

Thank you,


How to Establish a Remote Web Site Connection in SharePoint Designer 2007


I am modifying a SharePoint site and so far so good.  Some of the objects were created using Visual Studio 2008 (C#).  I was able to modify these objects and implement them on the targete machine without issue.  The final step is to implement the ASPX pages that were modified using SharePoint Designer 2007.  These are aspx pages that are used to modify items in lists.  All the pages involved in this upgrade are customized.  I need to upgrade the target site with the modified version of these pages.  My intent is to copy the code from the page in the source site and past it into the same page on the target site.  I tried using the Remote Web Site connection tool in SharePoint Designer 2007 but received the following error message:

"Unable to open 'https://(site address)'.  Server Error:  Could not find a Web server at 'website'.  Please check to make sure that the Web server name is valid and your proxy settings are set correctly.  If you are sure that everything is correct, the Web server may be temporarily out of service."

I am not sure how to first check to see if the Web Server is temporarily out of service.  I would appreciate your input on how to verify this.

Background information of target machine:  WinServer 2008, IIS 7, Sharepoint (MOSS2007), site on port 80

Custom Editform.aspx crashes Sharepoint Designer

Hi there,

I've recently designed a sharepoint list and customised newform.aspx and editform.aspx. I made copies of the originals then customised the copies.
On both forms I simply:

* Closed original List Form web part
* Added Custom List Form
* Added some section breaks (<tr>) to the form to break it into sections
* Added a new css style to change the background colour on the section breaks (table rows)

Now NewForm.aspx works fine. However after making above changes in EditForm.aspx, I saved it. However whenever I try to reopen EditForm.aspx in Sharepoint Designer (SD), SD crashes! I can only open it in Text view. The error details reported by SD are:

Problem signature:
  Problem Event Name:    APPCRASH
  Application Name:    SPDESIGN.EXE
  Application Version:    12.0.6423.1000
  Application Timestamp:    49b09947
  Fault Module Name:    FPEDITAX.DLL
  Fault Module Version:    12.0.6423.1000
  Fault Module Timestamp:    49b098d3
  Exception Code:    c0000005
  Exception Offset:    0010b35c
  OS Version:    6.0.6002.
  Locale ID:    3081

Additional information about the problem:
  LCID:    1033
  Brand:    Office12Crash
  skulcid:    1033

I really don't know why SD is crashing. As a test I made a new

Problem with SharePoint Designer 2007 and Custom List Forms


I created several forms (Create/Edit/View) for a SharePoint list, using Custom List Forms.  I'm using Content Types in the list to ensure that each item only has the necessary fields.  When I created the ASPX forms, and inserted the Custom List Forms, I selected the correct Content Type, and I got the right fields inserted in the form.

Now, for some reason I can't identify, every time I create a new form, and insert a Custom List Form, SPD is bringing ALL fields from the list, instead of just bringing the fields included in the selected Content Type.

I have tried many different things to solve the problem, including creating new lists/content types/forms, etc. but SPD is doing the same thing all the time.

Can somebody tell me what may have gone wrong in SPD or MOSS?


SharePoint Designer can't open defaul.aspx page

I tried to edit the default.aspx page of a WSS 3.0 site using SharePoint Designer and I get the following error:"The server could not complete your request.  Contact your Internet service provider or Web server administrator to make sure that the server has the FrontPage Server Extensions or SharePoint Service installed."When I click on the 'Details' button I get:"soaperverServer was unable to process request. ---> A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered as safe on this site. You may not be able to open this page in an HTML editor that is compatible with Microsoft Windows SharePoint Services, such as Microsoft Office SharePoint Designer. To fix this page, contact the site administrator to have the Web Part or Web Form Control configured as safe. "I don't have any custom built Web Parts installed and I checked the web.config file to make sure that other parts are marked as safe.The weird thing is that I can successfully edit other default.aspx files on sub-sites  Thanks for any help

SharePoint 2007, Modify Tooltip Text in SharePoint forms: EditForm.aspx and NewForm.aspx

I have a list in SharePoint that was created awhile back.  The names assigned to some of the columns in the list are no longer relevant.  Due to existing code, the column names cannot be modified to reflect the preferred names.  I was able to change the lables assiciated with these fields within forms NewForm.aspx and EditForm.aspx.  All looks and works just fine except for when the curser lingers in one of these fields, the tooltip that appears contains the underlining (original...no longer relevant) column names.  This is confusing to the user since the name within the lable and the tooltip are different.  I would like a way to either disable the tooltip from displaying or to modify it to display a custom value.  Below is the code from behind the form as it appears in Sharepoint Designer.  I would appreciate some input on this. <SharePoint:FormField runat="server" id="ff11{$Pos}" ControlMode="Edit" FieldName="My_x0020_Field_x0020_Name" __designer:bind="{ddwrt:DataBind('u',concat('ff11',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@My_x0020_Field_x0020_Name')}"/> <SharePoint:FieldDescription runat="server" id="ff11description{$Pos}" FieldName="My_x0020_Field_x0020_Name" ControlMode="Edit"/>

Attaching the Config Database in SharePoint 2007 with STSADM

Hello, We've moved our MOSS 2007 dev environment SQL database to a new server and we're having trouble attaching the config database to SharePoint using stsadm so we can access central admin. Here is the command we're running: stsadm -o setconfigdb -connect -databaseserver kraspsqltest\mosstest -databasename wss_config -farmuser "farmaccountname" -farmpassword "farmpassword" When I run this command (obviously with the correct username and password), the only message I see is: Access denied. I've checked with our DBA and nothing on his end is blocking the command. I do see the following in the event log where the command is being run: "Unknown SQL Exception 10061 occured. Additional error information from SQL Server is included below. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)" I've also noticed the folder containing the web.config file in IIS is no longer present on the MOSS server. Is this deleted when the config database is detached and added back when reattached? This server was working just fine prior to the database move

Access Denied while using Sharepoint designer 2007 to create a work flow

I am using Sharepoint Designer 2007 to create a work flow that sends emails to different people in a group depending on status of a record. For example, when some one reports a problem, an email is posted to concerned person and as soon as he/she checks the problem and updates the status an email is sent to next department and so on. Starting the work flow creation wizard is no problem but as soon as I press 'Finish' to create workflow I get 'Access Denied' message box. Any Ideas? I am using WSS 3.0 on 2003 Server.

SharePoint Designer 2007 Workflow needs to initialize lookup field value and store it

This is for a governance tracking list. I have two tables: Roadmap and Roadmap Status In Roadmap, there are two fields of interest that are lookup fields to Roadmap Status:Title they are Status and OldStatus When an item is entered in Roadmap, I want to force the initial Status to "Submit" from Roadmap Status. I don't see any way in my workflow to to lookup that item in Roadmap Status and place the pointer (I'm assuming it is a GUID) into the field. The value is also stored in OldStatus to catch changes as I'm trying to force order of status in a few cases but not all. I'm doing it with a Lookup instead of Choice because the business tends to change the terminology they like and this way I don't change it in several places plus it allows them to change it in the list instead of someone changing the list field values. I've seen several places on the forum where people have a similar problem and Lambert Qin has given an answer but it never fits this scenario exactly. Do I have to go back to Choice columns? I only have Designer and would rather not have to learn another tool for a simple SharePoint implementation. Thanks for any help!

Sharepoint Designer 2007 Variable Data on a form

I am a lifetime COBOL programmer trying to make a new career in a Sharepoint world. I am working on a project where I have created a list of Employees.  Almost all of the employees on the list must update their status on a day-to-day basis. A view was created on this list using [ME] as the search criteria to only return the employee who is updating his own info. With Sharepoint Designer 2007 I created a custom form. I cut and pasted the code for the view that I described above and then created a series of buttons to allow the employee to choose a status. For each button, I built a workflow to do the specific updates to the employee's list line. I was able to set up an onclick event for each button to execute a Javascript function that would go to the webpage and start the workflow.  I got the actual workflow URLs from the Sharepoint Intranet webpage after I completed each one. Here is my problem (and it is probably my inexperience that has got me stumped); The URL that is fed to the Javascript function has a hard-coded number representing the ID field of the Employee list (that is what probably sets the "Current Item" in the workflow.  I can see that the listview from above the buttons has the ID field as one of its Fieldrefs.  How can I substitute some kind of ID variable in the set of parameters that is fed to the Javascript? 

Conditional formatting on a joined subview using SharePoint Designer 2007 does not work

I have 2 SharePoint lists, one is a parent task list and the other a child task lists.  In SharePoint Designer 2007 I have created a combined datasource from these 2 lists.  From there I created a new ASPX page inserting the parent list as a dataview and the child as a subview.  So far so good, all is functioning as you would expect.    Now I need to apply conditional formatting to cells and rows in both the parent and child lists.  I can create a very simple condition on a row or cell of the parent list such as "If ID Equals '2988' format the background color as green" but no conditional formatting appears for the row where ID = 2988.  Incidentally, if I change the condition to "not equals 2988" the background changes to green. The line in the code view of Designer appears as follows:  <xsl:if test="../../../Rows/Row/@ID = '2988'">background-color: #00FF00;</xsl:if> I've seen this question asked here and in blogs but never answered.  If anyone has a solution, I would love to know what it is. Thanks; Dave  UPDATE:  it doesn't seem to matter if you add the additional fields as a joined subview or not.  If I add 2 data views, both using the linked data source which is configured to JOIN the contents of the data sources the conditional formatt

How to implement a Postback Enabled aspx page in SharePoint 2007

Hi, I create a webpart with aspx page and in aspx page i used autopostback true in dropdown list control.but this is not work in sharepint site. please let me know how to work postback enabled and autopostback true aspx page in sharepoint server Thanks Sanjeev Tiwari  

MOSS 2007 - SharePoint Designer Workflow failing when using group vs individual user

I am creating a simple workflow in SharePoint designer that will email a selected user when a list is modified.  I am applying the condition "if modified by" in Designer.  This condition works fine and the email is sent when I select a specific user myDomain\username.  It does not work when I attempt to associate a SharePoint group with the "if modified by" filter. In my example the list has only one SharePoint group associated with it, this is the only group with permissions for the list.  The group contains multiple users. The workflow is successful with the following scenario: if modified by myDomain\user1 or if modified by myDomain\user2 The workflow fails with the follwoing scenario: if modified by mySharePointGroupName  (which includes myDomain\user1 and myDomain\user2) This would be an ungodly if statement with a large membership SharePoint group.  This would also be a nightmare as people leave the organization and their account credentials are left in the large if statement in the workflow.  Looking for the modified condition when associated with a group seems like the logical way of doing this. I also tried "myDomain\domain users" which accounts for all user in my domain, this failed as well. Any advice would be greatly appreciated.

how to deploy a workflow design in SharePoint Designer 2007 in a list from development server to pro


how to deploy a workflow design in SharePoint Designer 2007 in a list from development server to production server. 

 i create a workflow in a list with SPD 2007 . I want to deploy it to production server who i can do this.

Thanks and Regards Er.Pradipta Nayak

No permission to open a list pages in Sharepoint Designer 2007


We have a sharepoint site with two main lists.

List 1: I could open the pages, make changes BUT cannot create workflows (for the site).
List 2: I could not even open it. I get the message
"You do not have permission to do this operation. Ask your web site administrator to change your permission and try again, or log on with user account that has this permission ...."

I am secondary server administrator and also have 'full control' of the site.

Any ideas?

Thank you

Sharepoint Designer 2007 shows Server timed out



When i try to open a sharepoint site (WSS 3.0) in Sharepoint Designer 2007. It shows a message "Server Timed out". Does anybody know why is it happening. Please help me.

Thanks in advance.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend