.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

Connecting BCS to ODBC / MySQL sources in SharePoint Designer 2010

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

Internally we are trying to migrate our MOSS 2007 solution to SP2010 in readiness for RTM.  So far, minus a few tweaks everything has been successful.

However we have a requirement to connect to a MySQL database.  It would be great to do this within SPD 2010 rather than via Visual Studio (which I suspect is the only way).

Does any body have any ideas or suggestions regarding this?

View Complete Post

More Related Resource Links

Creating SOAP or REST Data Sources in SharePoint 2010 Designer while using Forefront Server


When I create a REST data source to access a sharepoint list, I have permission issues because of the Forefront sever in front of my SharePoint 2010 server.  I've tested in an environment without the Forefront server and it works as expected.

1.  Tested in browser and works fine againsted forefront server (https://myforefrontserver.com/site/sub/_vti_bin/ListData.svc/MyList)

2.  Added this to web.config

      <proxy autoDetect="true" />

3. Created Rest Data Source in SharePoinbt designer pointing to https://myforefrontserver.com/site/sub/_vti_bin/ListData.svc/MyList and tried all logon options with no sucess.

Out of ideas

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.



How to use display Text in Hyperlink For SharePoint 2010 Designer Workflow


In SharePoint 2007 Designer, I have used the Hyperlink column to store the link "http://www.sharepoint.com/Default.aspx, Details". The details text will be shown in the Hyperlink column. Everything works fine in sharepoint 2007 Designer workflow.

In SharePoint Designer 2010 Workflow, I used the same method but the hyperlink column is displaying the full text "http://www.sharepoint.com/Default.aspx, Details" instead of only Details


Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Quick Note: Using SharePoint Designer 2010 to Work with Web Parts

Learn to create an XSLT List View Web Part within SharePoint Designer 2010 that displays a list of employees on the Home page of local web site.

Microsoft SharePoint Designer 2010 Beta (32-bit) - Now Available!

Using SharePoint 2010 Designer, advanced users and developers alike can rapidly create SharePoint solutions in response to business needs. In addition, developers can use SharePoint Designer 2010 to get a quick start on SharePoint development projects.

Microsoft SharePoint Designer 2010 Beta (64-bit) - Now Available!

Using SharePoint 2010 Designer, advanced users and developers alike can rapidly create SharePoint solutions in response to business needs. In addition, developers can use SharePoint Designer 2010 to get a quick start on SharePoint development projects.

Video: Microsoft Visio 2010 and Microsoft SharePoint Designer 2010 Workflow

Learn the specific roles Visio 2010 and SharePoint Designer 2010 play in the development process and how these tools can be used in concert to create a workflow. (Length: 13:22)

Video: Creating Workflows in SharePoint Designer 2010

This demonstration shows how to create a powerful list workflow with code-style logic by using SharePoint Designer 2010. (Length: 8:15)

SQL Server doesn't exist or access denied while connecting with Access 2010 ODBC

Hello all. I am using Access 2010 and SQL Server 2008 (locally). I can easily connect to server using SSMS and it works excellent. But when I want to import a table to Access 2010 using ODBC, it says that "SQL Server doesn't exist or access denied". It worked previously - almost 3 days ago, but now, it doesn't! Please help! Thanks Mohammad Javahery

Use Dashboard designer in Sharepoint Foundation 2010

Hi, I want to Install Dashboard Designer in Sharepoint Foundation 2010(WSS 4). I can only find articles on insatllation in Sharepoint Server 2010..like this one.. http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx?wa=wsignin1.0 Can you please let me know how I can use Performance Point in Sharepoint Foundation?   Thanks  

How to get User group in SharePoint Designer 2010 within workflow?

Hi, How to get user group in sharepoint designer within workflow? Basically I have to compair that current user is belongs to particular group or not.  How can I get check user group in workflow's if condition? G. Goyal

SharePoint Designer 2010

I installed SharePoint Designer 2010, no problem.  I started it up and I was unsuccessful in attempting to create a blank site.  I received the message "The web site must be created on a server that is running Microsoft SharePoint foundation".  I would have thought that if it gave you the option to create the SharePoint site that it would generate it.  Do I need to install Microsoft Server on my PC?  I would prefer not to do that....

Error creating Read Item or Read List operation in Sharepoint Designer 2010

In terms of high-level requirements, I need to pull in lists from a couple of different web apps.  To do this, I’m using SPD 2010 to create an External Content Type for the list of interest.  I’m able to create a SOAP Service or WCF Service connection just fine.  However, when I try to create the external content type and create a Read Item Operation on one of the GetList or any other Get* (or other Update methods for that matter) methods, I get the following error:"The method that your operation is based on has parameters with complex types that do not have default parameterless constructor.  This kind of data source methods cannot be used in Business Data Catalog."I tried defining an operation on the “AddAttachment” method, and that worked just fine.  I also tried providing default values to the listName and viewName parameters when creating the SOAP Service connection, but still get the error.  Same issue with a WCF Service connection as well. Does anyone know if this is a 2010 issue, or am I approaching this requirement incorrectly?  What are other approaches for connecting to lists that reside in a different web app than yours? 

Problem With SharePoint Designer 2010 and the Search.asmx Web Service

I've created a web service datasource on a 2010 site using SharePoint Designer. When I try to make use of the datasource on a page I get the "The server returned a non-specific error when trying to get data from the data source..." message. The datasource connects to _vti_bin/search.asmx. I am using the QueryServiceSoap port and operation QueryX. I've tried various queryXml strings, including site & people searches using both SQL and keyword syntax. eg <?xml version="1.0" encoding="utf-8" ?><QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1000"><Query domain="QDomain"> <SupportedFormats><Format>urn:Microsoft.Search.Response.Document.Document</Format></SupportedFormats> <Context>   <QueryText language="en-US" type="MSSQLFT"><![CDATA[ SELECT Size, Rank, Path, Title, Description, Write, Filename, Description, Author FROM scope() WHERE CONTAINS ('"Lorum"') AND  ( ("SCOPE" = 'All Sites') )   ORDER BY "Rank" DESC ]]></QueryText> </Context> <Range><StartAt>1</StartAt><Count>20</Count></Range> <EnableStemming>false</EnableStemming> <TrimDuplicates>true</TrimDuplicates> <IgnoreAllNoiseQuery>true&l

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

How to start a workflow programmatically that was created in Sharepoint designer 2010?

Trying to start a workflow from code.  The workflow itself has been created in SPD 2010, which from what I understand, means that there is no assembly until the first time it's ran.  However, when I try to find the association record, that doesnt exist.  Is this becuase the 'code' hasnt been compiled yet?  If so, how can I have sharepoint start the just-in-time compiler for a declarative based workflow, so that can kick it off with in code? tia Rocky SandersRocky Sanders
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