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

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

Getting error while retrieving data from sql server 2008 to infopath 2007 in sharepoint 2007

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :SharePoint
Hi, I have created an InfoPath form in InfoPath 2007. In this form I am getting data from SQL Server. To do this I have created data source for SQL Server 2008’s Tables. I have created 4 connections for 4 tables. When I am previewing this form from InfoPath Designer 2007, it is working. But when I am publishing this, it is giving me an error ‘Can not update content type’. If I skip this error then my form published but when I open this form from Share Point 2007. It gives me an error:   There has been an error while processing the form. Click Continue to resume filling out the form. You may want to check your form data for errors. Click Start Over to load a new copy of the form.   An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID: 6932 G. Goyal

View Complete Post

More Related Resource Links

error when installing sharepoint server 2007 on Windows server 2008 r2

I ve tried to install sharepoint server 2007 on server 64 bit with windows server 2008 r2,but it gave me compatibilty error

Sql error+sharepoint server 2007 installation on windows server 2008 r2


I am trying to install sharepoint server 2007 on windows server 2008 r2,I downloaded the version of sharepoint that contains service pack2,after the installation finished,message displayed that mssql\officeservers cant be found?

Must I install sql server 208 before installing sharepoint,is sql express that is already installed with sharepoint 2007 not compatible with windows server 2008 r2

SOAP Error 500 when query in Sql Server 2008 using for reporting a Sharepoint list 2007


I'm doing the reporting services for a SharePoint list, the datasource is configured as a connection with http://<Servername>/_vti_bin/lists.asmx and I add the parameters listName , rowLimit and viewName with the

Importing SharePoint List Data into Project Server 2007 Custom Fields

Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

Sharepoint 2003 + Windows Terminal Server 2008 + Office 2007 problem?

Hi, We have a customer where some users runs Windows Terminal Server 2008 with Office 2007. They open documents from a Sharepoint 2003 site. When they open an excel sheet they get a button in the document which says "Server workbook: Click edit workbook to edit this workbook" and there is a button: "edit workbook" The users clicks "edit workbook" but get an error message saying there is no connection to the server.  They are able to edit the document, but not save it back to the sharepoint site. Most other users work on their local computer with Office 2003. Here, everything works fine and there are no button/message stating its a server workbook.   Is this caused due to some compatability issues between Sharepoint 2003 and Office 2007?   Best regards, Thomas Hansen ErgoGroup AS

Submitting InfoPath data to a SharePoint 2007 List

Clayton, i sure hope you get this.  I would like to let the form get published to the form library and then workflow can create the new list item with all the required metadata mapped.  if data is updated i would like for the list item data to update as well.  currently i have an infopath form that is web-enabled.  i several views based on a status field as which view to open to.  this form have drop-down fields linked to list already on the sharepoint site.  i have tried using the "Submitting Data from Infopath 2007 to Sharepoint List" and it works as designed but unfortunately i cant customize the fields.  i need a dynamic user friendly form with drop downs etc.  any suggestions?

How to use SharePoint 2007 list data in Reporting Service (Visual Studio) 2008?

Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list). Here is what I've been doing: Created a simple SharePoint list in a test site - only one column (Title) with one record of data. Started Visual Studio 2008 and created a new Report Server Project Wizard project. I named the data source "dsTest". Type: "XML". As connection string I used: http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)". Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box: <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> Clicking Next I get this error: An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Now if I view the Details when trying it inside the Query Builder I get this: <errorstring xmlns="http://schemas.mi

The URL is not valid error while publishing InfoPath form to MOSS 2007 server

Hi All,   When I try to publish the form onto a SharePoint Team site it throws the error: The following URL is not valid : http://tcs037288:6543/sites/projectmanagement   I have checked the comaptibility, trust and everything looks fine. Also, I tried to upload this template from Central Admin but there it is failing with browser-compatibility errors.       Regards,

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

Win server 2003+ Sharepoint 2007+SQL Server 2008 ,reports view issue?


I hope someone may shed some light on a serious obstacle encountered on a client site:

We have implemented a SharePoint integrated report services solution for the client on a single server

Server = Windows 2003

SQL = 2008

MOSS 2007

Web application = servername:8888 (default) - windows auth

Web application extension 1 servername:8889 (extranet) forms auth

Web application extension 2 servername:8887 (intranet) forms auth

Reports are visible and can be run (renders) on internal sites

However, there is an external site which allows users to access the reports - the issue is, the reports then dont run and I get this:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

Though I have not actually seen the firewall config of the AAM, the client assures me it has been setup properly.

If the AAM is setup correctly, what could be the problem? The server is clearly available and confgured in SharePoint integrated mode.


has anyone experienced the scenario where clients want to publish their reports on an external site? What can one do to see any errors other than the one line message (tried enabling custom errors, but no good)

Error when running configuration wizard for sharepoint 2007 on windows 2008 r2

I am trying to install sharepoint 2007 on windows 2008 r2,the setup file ran ok but when I ran the configuration wizard I received this error "Failed to start the database service MSSQL$OfficeServers. Repair this product
by selecting it from the Add/Remove Programs menu."

How to integrate SQL Reporting Server 2008 R2 With SharePoint 2007


Hi All,

I am facing issue in configuring SQL Reporting 2008 R2 With SharePoint 2007, my enviorment details is i have already MOSS Farm and i create new SQL Server 2008 R2 for reporting services. When i brows my reporting server URL its gives me error

  • The report server has encountered a configuration error. If the report server is configured to use SharePoint integrated mode, verify that the server is joined to a SharePoint farm and that the Report Server service account has been granted access to the SharePoint farm. (rsServerConfigurationError)

my question is how to join my Reporting server with existing MOSS server?

Note: My SharePoint environment is consist of 2 Web Front End Servers and 1 Indexing Server.



Installing Microsoft Office SharePoint Server 2007 on Windows 7, getting error please help

Hi all Installing Microsoft Office SharePoint Server 2007 on Windows 7 Ultimate 32-bit, getting error "Windows Server 2003 sp1" is required for this product, any help please.

Synchronize group calendar from Sharepoint 2007 (SBS Server 2008) using ActiveSync for mobile device


I've created a Public Folder Calendar on my Exchange Server that our Office Manager uses to inform all our partners and staff (small medical practice) of vacations, group meetings, etc.

I'd like to make this calendar available to mobile devices (1 Windows Mobile, 1 Blackberry, 3 iPhones). I know that individual user Exchange Calendars can sync, but I'm told Microsoft isn't making any effort to make this happen for Public Folder calendars because they're being deemphasized and will disappear in either the next or subsequent version of Exchange. There's a third party product that claims to do this (Outlook AddIn). Since the Public Folder Calendars are being de-emphasized in favor of the Sharepoint calendar, one would think that Activesync would be able to work with the SharePoint group calendar, but apparently that's not the case. Is my best bet still the Add to Outlook product from diditbetter.com?

unable to save data in SQL Server database through Sharepoint 2007


Hi All,

I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.

Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.

Can some one have idea on this. Please help me to get it done

Thanks in Advance.

Sharepoint server 2007 Implement SSl Error


Hi ,

i am trying SSl implement Sharepoint server 2007 server existing web application after create certifiacre . IIS 6.0 .i got below error

The page must be viewed over a secure channel

The page you are trying to access is secured with Secure Sockets Layer (SSL).

Please try the following:

  • Type https:// at the beginning of the address you are attempting to reach and press ENTER.

HTTP Error 403.4 - Forbidden: SSL is required to view this resource.
Internet Information Services (IIS)

Technical Information (for support personnel)

  • Go to Microsoft Product Support Services and perform a title search for the words HTTP and 403.
  • Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled About Security, Secure Sockets Layer (SSL), and About Custom Error Messages.


Surendra Singh


Surendra Singh

"Error in PortalCrawl Web Service." error while crawling People on MOSS 2007 from Sharepoint Server


Hi All,

I am getting "Error in PortalCrawl Web Service. " error while crawling people [SSP] on MOSS 2007 box from Sharepoint 2010 box.

NOTE: I am able to crawl People i.e SSP application on other MOSS 2007 box successfully by following same steps which i am using to crawl above mentioned SSP which is giving error.

If anyone has faced similar error ,please suggest.



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