.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

unable to save data in SQL Server database through Sharepoint 2007

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

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.

View Complete Post

More Related Resource Links

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.

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

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

Unable To Connect Database Error:Sharepoint 2007 Internet Site.

Hi Techies,  we are running 4farm Sharepoint internet site. now a days we are getting the below error very regularly. Event Viewer :The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SPPREPROD02VMDK\SPPREDPROD.  Check the database connection information and make sure that the database server is running.. Sharepoint Logs:#50071 :#50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. Please Advice . Regards, raju.  Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

Save/Update/Delete Sql Server data base table using Sharepoint Designer


Can some one help me to achieve below task

Save/Update/Delete Sql Server data base table using Sharepoint Designer.

Unable to connect to the SQL content database from sharepoint web front server.



SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

when ever these errors occur in eventvwr sharepoint will not work.

Please suggest on this issue.

waiting for MS replies..






Database server migration - renaming database server in SharePoint 2007


We are migrating our SharePoint databases to a new database server.  This new database server will have a new name for SharePoint to reference.  How do I go about pointing SharePoint 2007 from the old database server name to the new name?

It seems like there should be a simple solution, but I have yet to find a solid procedure.

Thank you,

- Tom


SharePoint Server 2007 Database


Hi Guys,

I'm done with the installation of our new SharePoint Server 2007 but i was not able to find its config database. Can you please help me locate it? We are running SQL Server 2005.

Best Regards,

Albie Bokingkito
Systems Administrator

SQL Server database permission problem in SharePoint 2007


Hi All,

I created few users from "Computer Management" --> "Local Users and Groups" --> "Users" --> "New User" as my login user in SharePoint 2007

Then I having a custom page where store the data into SQL Server Database.

below is how my connectionstring look like:

<add name="XXConnectionString" connectonString="Data Source=XXX;Initial Catalog=YYY;Integrated Security=True" providerName="System.Data.SqlClient"/>

however I hit error when browse to the custom page by the users.


Cannot open database "XXX" requested by the login. The login failed. 

Login failed for user 'xx\user1'.   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 

It was fine if I login as System Account.
Can anyone help me in this? thank you in advance.

Unable to save Office 2007 document to SharePoint My Site Personal Documents document library


...also when Office documents are saved to document library they open as Read-only and cannot be saved back to the same document library.

This only happens in my production SharePoint 2007 environment from client XP and IE7 machine.  It does not happen in developement environment (which mirrors production) from client XP/IE7 machines.

Save works fine to SharePoint document libraries from client Win 7 and IE8 machines in both production and development environments.

This only happens when attempting to save to a My Site Personal Documents document library.  Any other document library this behavior does not exist from XP or Win 7 machine.

What settings controls ones ability to save to a personal My site document library.  What setting could be different between prod and dev installations?  It only happens

How to Backup Single Server (Database on same server )Extra-net SharePoint Site MOSS 2007 SP1? and H



I have to create Test Server (Single server with Database on Same Server).

What Kind of Backup should i be asking  to Hosting Company,SharePoint MOSS 2007 SP1 Extra net site Hosted by 3rd Party.

How to restore it to Test Server and Has any one documented this process and has anyone had sucess in doing similar work ?

I do not have any access to Production server.How to make sure i have same server setup & configuration as Production Server.


I have to customize this site and do some development work so i thought this would be best approach ?


Please let me know..thanks..



Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

server side does not save data when using POST data to another URL using WebRequest


 I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).

  1.  The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line

   response.StatusDescription; // this has value of "OK"
2. How can I debug the server code side where to receive the request from client side who posts the data ?

The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.

Client side codes: // also run on my local computer

public string PostIntegrationXml(XmlDocument xmlSubmitDoc)




Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000


SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003

SharePoint Portal Server 2001: Search and Access Disparate Data Repositories in Your Enterprise


The knowledge worker is greatly empowered if she is able to access information across the enterprise from a central access point. With the SharePoint Portal Server 2001 Search Service you can catalogue information stored in Exchange public folders, on the Web, in the file system, and even in Lotus Notes databases. This article discusses the use of ActiveX Data Objects and the Web-based Distributed Authoring and Versioning protocol for creating search solutions based on SharePoint Portal Server 2001.

Kayode Dada

MSDN Magazine April 2002

Deploying custom Web Parts on SharePoint 2007 production server

I would like to develop a custom SharePoint 2007 Web Part for a client. Currently I'm using Visual Studio to deploy my solution to a test environment (since it's a SharePoint Project I choose just Build -> Deploy from the menu). What are the appropriate steps to deploy it to the production server?

I'd like keep it simple and safe (i.e. use the principle of least privilege). Therefore (if possible) avoid using stsadm, achieve this through web interface, or avoid using administrative rights.

Also, can I specify the scope of my Web Part, i.e. choose on which Web Application or Site Collection will it be installed?

sharepoint 2007 server needs to be restarted twice a day???



our sharepoint server needs to be restarted twice a day now - always around 9.30am and 14.30pm.  this has only started in the last 2 weeks.  its working along fine then all of a sudden it goes to a dead page.

i have spent the last week trying to identify what it is.  i have set the logging to verbose and put plenty of the messages in there into google but can not see anything relevant.  the event viewer shows nothing.

i have sp2 installed but no cumalitve updates.  i am wary of installing these at the mo and wreaking the whole thing.  if noone has any suggestions ill install them.  ill list soem details about the problem below. 

it doesnt happen on weekends so it must have something to do with users using the system so im thinking something to do with the database (SQL Server 2000).  NB users dont use our sp2007 on weekends. 
if i restart iis, the layout of the page comes back but some of the webparts are dead so that doesnt work. 
if i resart sql server, that doesnt work either. 
there is plenty of room on drives and the task manager is at 20-30% when i check it when the site is down.
only a server resart seems to work.

there are just so many messages in the sp logs that i cant identify what it could be.  is there any other loggi

Sample: SharePoint Server 2010: Aggregating Data Using BCS and .NET Assemblies

Use the BCS Data Aggregation sample with BCS in SharePoint Server 2010 and to aggregate data from two external systems.
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