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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

How to add a Database Connection on Sharepoint Designer 2007 to access SQL 2005 tables?

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

I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked out while listing the DB's.

I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.

I'm really desperate. Any help is very welcome.

Thanks,

____




View Complete Post


More Related Resource Links

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

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.

How to configure Sharepoint 2007 Reporting Services 2005 with NLB sharing same RS database

  
Hello, I'm trying to configure RS using two FE and a single SQL database in sharepoint integrated mode. At first i was getting an error about version of reporting server wouldnt support scale-out configuration, so i upgraded RS Instances in both FE's to 2005 Ent Ed. and re-installed sharepointRS_Addin in both FE servers and successfully initialized both with the reporting services configuration tool. after successfully granted database access to both FE's using CAS.  if i browse to                    http://WFE1:port/ReportServer/                    or                    http://WFE2:port/ReportServer/                    the database content is listed in browser.   if i browse to:                    http://NLB-sitename:port/ReportServer                    the database content gets listed also, tho it seams to list random conten

Configuring ODBC Database connection in Sharepoint Designer 2010

  

We are trying to connect the simple way from Sharepoint Designer 2010 to an external Pervasive SQL version 10 database.

Normally this is a trivial excercise in any other development tool, you supply an ODBC connection and away you go.

Using Sharepoint Designer 2010 (or the previous version) it is not possible to get a working connection that will get you past the "Configure Database Connection" dialog. We have to use the "Use custom connection string option" as that is the only place there appears to be a Provider for ODBC or OleDB.

No connection string works, I have tried connection strings that work fine in Visual Studio, no joy.

OleDbConnection

 

Access Database 2007 in Sharepoint 2007 connectivity

  

Hi  i have access 2007 database , in that D/B i have some really important information about employee stock purchase activity.

i want to put that database(Or Access That DataBase) in sharepoint so employee can check their activity but i want employee can see only their own data from access databse so what i have to do for this kind of scenario?

Arpit

 


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,
Tzach.

 


SharePoint 2007 Access Error

  

Hi everybody!

I´d like to verify if somebody see this scenario:

* I create a site, using te meeting site template;

* I give Full Control access to an user;

* When this user try to upload an item in a library, in this site, it was showed the message "Acces Denied".

* If the user press "back" in the Internet Explorer tool bar and press "F5" to refresh, the file is there.

* The same problem is ocurring, when he try to create a meeting.

Somebody ever see this error!?

Thanks a lot

Douglas!


Administrator and Developer Guide to Code Access Security in SharePoint Server 2007

  
Explore configuration options, get best practices for managing CAS in SharePoint environments, and walk through a complex CAS scenario.

SharePoint 2007 Expiration Policy Not working : Access denied for the site

  

I have a SharePoint 2007 List with Expiration Enabled in Information and Policy Management. I have a datatime column ExpiryDate which i used in Expiration. On Expiration I have chose to delete the item. Through Central Admin I run the expiration by clicking "Process Expired Items now" button. I got the following error in the Windows event viewer.

Expiration Service for site http://md-rmanimaran failed.

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

EventID: 5016

Category: Information Policy Management 

Where I need to specify the login details to get rid of this error? Anybody Please help..

Thanks

R.Manimaran

 


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?

Thanks


Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Cannot crawl sharepoint site and mysite after database attach upgrade form sharepoint 2007 to 2010.

  
After database attach upgrade site and mysite from sharepoint 2007 to 2010 , I have full crawl and get "The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. If the repository was temporarily unavailable, an incremental crawl will fix this error. ( Error from SharePoint site: HttpStatusCode ServiceUnavailable The request failed with HTTP status 503: Service Unavailable. )" for mysite and get "Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled." for sharepoint site. The content access account for search is "db_owner" of both of site and mysite. How do I solved this problem ?

SharePoint 2007 to Access 2007 - Issues grouping by "Person or Group" field type/column

  
We are on SharePoint 2007 and using Access 2007.  The SharePoint list contains a column called Assigned Person, column type: Person or Group, single selection, displaying only the name 1) When we Open with Access and Export a copy of the data, then create a report from that table, we do not have the option to group on Assigned Person.  2) When we Open with Access and Link to data on the SharePoint site, then create a report from that list, when we group by Assigned Person... The same person has 2 groups - there are is no other grouping or sorts on the list, and i can't locate a correlation to another field to show why they would have to collections for the same person The Person or Group column sorts "from smallest to largest" as though it is a number field. The list is a task/activity tracking system we created custom for our needs.  We want to pull a weekly report, grouped by Assigned Person, but cannot get access to work.  We do not want to resort to anything more complex, as it takes a much longer process to have reports pulled by Chrystal or one of those types of applications.  And we cannot change out the field for something like a Choice column as the list already has a very large amount of content.  Can anyone assist? Is there a setting hiding somewhere that is causing the problem? 

How to link SharePoint List with MS Access 2007 programmatically

  
Hi, can anybody tell me how to link SharePoint List with MS Access 2007 without opening Access environment. I want to do it programmatically through C#/VB.net doesn't matter. Your help will very much appreciated. Thank you so much! -Jarexs

Cannot access parent site list from subsite in XSLt List View webpart in sharepoint designer 2010

  
Hi    We are using sharepoint 2010  for internet facing sites for our big client in healthcare domain .  I am using XSLT list view webpart in sharepoint designer 2010 for retrieving contents from sharepoint list & displaying it by using XSLT List view webpart in publishing sites. We are having lot of list in rootsite collection, If i am creating pages by using XSLt list view webpart in root site collection I can access the list,View and Display in Pages by XSLT List view webpart. Now the requirement is i have to access the list in roosite collection(parent site) from subsites.  In Sharepoint designer 2010, while i am inserting XSLT list view webpart, i could not find datasource to access the list that exist in rootsite collection(Parent site) from subsite. Below is the the code i am using for accessing the list& view from parent site & creating the pages in parent site by using xslt list view webpart,now i wants to access parent site list from subsite by using XSLT list view webpat in subsite pages.  Pls let me know what i have to change in the code level <WebPartPages:XsltListViewWebPart runat="server" Description="The list for the conditions details" ListDisplayName="" PartOrder="2" Default="FALSE" HelpLink="" AllowRemove="True" IsVisible="True" All

Cannot access parent site list from subsite in XSLt List View webpart in sharepoint designer 2010

  
Hi    We are using sharepoint 2010  for internet facing sites for our big client in healthcare domain .  I am using XSLT list view webpart in sharepoint designer 2010 for retrieving contents from sharepoint list & displaying it by using XSLT List view webpart in publishing sites. We are having lot of list in rootsite collection, If i am creating pages by using XSLt list view webpart in root site collection I can access the list,View and Display in Pages by XSLT List view webpart. Now the requirement is i have to access the list in roosite collection(parent site) from subsites.  In Sharepoint designer 2010, while i am inserting XSLT list view webpart, i could not find datasource to access the list that exist in rootsite collection(Parent site) from subsite. Below is the the code i am using for accessing the list& view from parent site & creating the pages in parent site by using xslt list view webpart,now i wants to access parent site list from subsite by using XSLT list view webpat in subsite pages.  Pls let me know what i have to change in the code level <WebPartPages:XsltListViewWebPart runat="server" Description="The list for the conditions details" ListDisplayName="" PartOrder="2" Default="FALSE" HelpLink="" AllowRemove="True" IsVisible="True" All
Categories: 
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