[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Microsoft Application Blocks - Where can I find the AccessHelper.vb?

Posted on 2004-09-16
5
Medium Priority
?
474 Views
Last Modified: 2008-01-09
I just found out about this new class Microsoft is providing and it seems like a great idea. I know it was the building blocks for the DAL in DotNetNuke but their implementation is specific for DNN.

My question is where can I find an official ACCESS or OLEdb version of the SQLHelper.vb provided with the Microsoft Application Blocks Samples?

thanks.
0
Comment
Question by:brian2k1
5 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 12075492
Is such a thing exist?
0
 
LVL 20

Accepted Solution

by:
ihenry earned 1200 total points
ID: 12075762
Nope, it's meant only for SQL Server database. If you want DAL that supports multiple database providers get the DAAB version 3.
    Data Access Application Blocks version 3
    http://www.gotdotnet.com/Community/Workspaces/Workspace.aspx?id=c20d12b0-af52-402b-9b7c-aaeb21d1f431
0
 
LVL 7

Assisted Solution

by:mdamico
mdamico earned 800 total points
ID: 12076899
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/manprooracperf.asp

There is an OleDB version of the data access layer included with the Nile 3.0 sample application.  I have used this against access without any issues so far.
0
 
LVL 1

Author Comment

by:brian2k1
ID: 12077105
Thanks for the great posts. I'm looking into both suggestions and will most likely split the points if that is acceptable with both jhenry (300) and mdamico (200).
0
 
LVL 1

Author Comment

by:brian2k1
ID: 12077478
Also for anyone who might ready this thread there is an AccessHelper.vb and OleDBHelper.vb module in the DotNetNuke project

\\DotNetNuke\Providers\DataProviders\AccessDataProvider\AccessHelper

http://www.dotnetnuke.com for more information.

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have developed many web applications with asp & asp.net and to add and use a dropdownlist was always a very simple task, but with the new asp.net, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month18 days, left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question