Accessing MSAccess Database using BDC
Hi,
Does anyone knows how to access MSAccess database using BDC (Business Access Database) with MOSS 2007.
[119 byte] By [SumitKute] at [2008-2-14] 
«« Refence Book reccomendations?
»» Can ContentControl automatically apply data template (nameless) based on type of it's Content p
»» Can ContentControl automatically apply data template (nameless) based on type of it's Content p
I got the BDC working with Access 2007. Here is the LobSystemInstance I used to get this working:
<LobSystemInstance Name="MyInstanceName" DefaultDisplayName="MyDisplayName">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">English Display Name</LocalizedDisplayName>
</LocalizedDisplayNames>
<Properties>
<Property Name="AuthenticationMode" Type="System.String">RevertToSelf</Property>
<Property Name="DatabaseAccessProvider" Type="System.String">Odbc</Property>
<Property Name="RdbConnection Data Source" Type="System.String">Data Source='';Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=\\server\share\database.accdb;Trusted_Connection=true;</Property>
<Property Name="RdbConnection Integrated Security" Type="System.String">False</Property>
</Properties>
</LobSystemInstance>
I hope this helps!
PLiebrand at 2007-9-7 >
SharePoint Products and Technologies Hot Topic
- 'Loans and Reservations' template bug?
- Missing "Upload Multiple Files" tap
- 'Room and Equipment Reservations' template bug?
- Alerts not being sent
- Deploying custom Asp.net application on to the Sharepoint site
- Adding a column to custom list
- Manage BDC Permissions in Internet Situation
- Issue deploying scorecard
SharePoint Products and Technologies New Topic
- Problem in Current Navigation display for the links ( links to any document which are stored in
- Retrieving Data from xml for drop-down list or checkbox
- Cannot insert duplicate key in object 'dbo.DataServicePropMap' Upgrade Error in MOSS 2007
- Hybrid Upgrade Method?
- page viewer web part and 'security validation for this page is invalid' exception
- Customization of Newform.aspx.
- Variations and Versioning - Exception
- passing data from wss workflow to aspx task form
SharePoint Products and Technologies
- SharePoint - General Question and Answers and Discussion
- SharePoint - Setup, Upgrade, Administration and Operation
- SharePoint - Design and Customization
- SharePoint - Development and Programming
- SharePoint - Business Data Catalog
- SharePoint - Business Intelligence
- SharePoint - InfoPath Forms Services
- SharePoint - Workflow
- SharePoint - Excel Services
- SharePoint - Search
- SharePoint - Knowledge Network
- SharePoint - Enterprise Content Management
- SharePoint - Accessibility
- SharePoint - Social Computing
Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech
Site Classified
- SQL Server
- Windows Forms
- .NET Development
- Visual Basic
- Visual Studio
- Visual Studio Team System
- Visual Studio Orcas
- Visual Studio Express Editions
- Software Development for Windows Vista
- Visual C#
- Visual C++
- Smart Device Development
- SharePoint Products and Technologies
- Feedback for forums and MSDN websites
- Game Technologies: DirectX, XNA, XACT, etc.
- Visual Studio Tools for Office
- Windows Live Developer Forums
- Microsoft ISV Community Center Forums
- Internet Explorer Development
- Visual FoxPro
- Windows Search Technologies
- Audio and Video Development
- Architecture
- Commerce Server
- Gadgets
- Microsoft Robotics Studio
- Community Chat
- BizTalk Server
- Visual J#
- Windows Networking Development
- Silverlight (formerly WPF/E)
- Popfly
- SQL Server Katmai
- Connected Services Framework
- Office Live Development
- Customer Care Framework
- Incubation Technologies
- Software Engineering Discussion
- System Center
- Software Licensing and Protection Services
- Visual Studio Rosario
- Small Business Application Development
- Office
- Windows Server 2008
- JScript
- Storage Platform – Core
- Misc