.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

Accessing MySQL Data using ODBC w/ BDC Definition Editor

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#

Hello everyone.

Background: I'm a computer science student doing some work for a non-for-profit, and have minimal experience with SP 2007, ODBC, etc.

Overview: I'm trying to create a BDC definition file using the definition editor (found in the SDK), rather than editing a template XML manually. I found this thread to be fairly helpful in getting me started on what seems to be the right path: http://social.msdn.microsoft.com/Forums/en/sharepointbdc/thread/833a9583-5f4c-4ed9-b9c8-f5834b790375

In order to establish a connection to the remotely hosted MySQL database I must provide an ODBC source for the client user/system, correct?

 My questions are: 

  • How does using ODBC affect things once I upload the ADF to the Shared Services Provider (SSP)? Do I now need to provide a duplicate ODBC Source on the server hosting sharepoint for the BDC to connect to the database? Apologies if I am not understanding this correctly.
  • If the above process is correct, how might I expect this process to change for sharepoint 2010? The organization is looking to roll-out SP2010

    View Complete Post

More Related Resource Links

Business Data Catalog Definition Editor

Hi folks, I want to add a chart web part to my site getting data directly from a SQL-Server table. Can I add Business Data Catalog using SPD or do I need the Business Data Catalog Definition Editor. Where can i download it for Sharepint 2010 Enterprise Farm. You miss 100% of the shots you do not take!

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.

Saving textbox data to MySql database in asp.net


Hi dear coders

though a very simple question to ask, but please tell me how to save and retrieve data in/from my textboxes to/from database (MYSQL) on submit button click.

i know its a very simple task but i cant make it done, so i request you to please send me some working example link or post any helpful code here in asp.net

i will be highly thankful for any kind help from you geniuses.



MySql.Data assembly problem



I added refernece MySql.Data to my project. My web.config looks like that:

<?xml version="1.0"?>
                <add assembly="MySql.Data, Version=, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>

But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?

What the problem can be?

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010


SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010

Editor's Note: Flex Your Data


Filling in for Editor-in-Chief Howard Dierking, Ted Neward lends some insight into the state of data collection and manipulation.

Ted Neward

MSDN Magazine July 2008

Data Points: Accessing Data from a Mobile Application


This month John Papa takes a look at developing a mobile application that can access data on your application server.

John Papa

MSDN Magazine January 2008

Best practice? Accessing subset of data based on user


I have a DB and associated Asp.net 3.5 web app. The database holds information on our clients. We're adding client access functionality and I need to know how best to restrict user access to data only pertaining to their client.

The clients are stored in a hierarchy and each user can be associated with multiple clients. The user should only be able to access the data for their associated clients and any sub clients thereof.

My initial thought is to add a collection of clients to their profile, then use that to filter all queries; however, my gut instinct tells me that using the profile for such a security function is inadvisable.

Could anyone provide any insight on a best practice for this? I'm sure it must be a pretty common need.


Quick Note: Accessing Data in a SharePoint 2010 Web Part by using LINQ

In this exercise, you develop and deploy a visual Web Part that reads data from two lists by using a LINQ query and displays it in a DataGrid control.

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Sample: Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint

Download sample code as you learn to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Video: Accessing SharePoint 2010 List Data

In this video you will learn how to create strongly typed classes using a tool called SPMetal to do LINQ programming against a SharePoint 2010 list. (Length: 15:22)

Module 5: Accessing SharePoint 2010 Data with Client-Side APIs

SharePoint 2010 provides a new client object model that enables you to create SharePoint solutions that run remotely from the SharePoint server farm.

Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010

SharePoint 2010 provides a new set of technologies known as Business Connectivity Services for retrieving, editing, updating, and deleting data from external systems.

Video: Accessing SharePoint 2010 Data on the Server

This video provides an overview of approaches for accessing SharePoint 2010 data by using the server-side APIs. (Length: 3:32)

Video: Accessing SharePoint 2010 Data from a .NET Application

This demonstration shows how to use the client object model from a Windows Presentation Foundation application. (Length: 5:26)

Video: Accessing SharePoint 2010 Data in Silverlight by Using CAML

This demonstration shows how to use the client object model and CAML to access SharePoint data in Silverlight applications. (Length: 6:39)
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