DAAB with MS Access MDB

3 Aug 2006 3:00 PM

pbaugh

Hi all,
I've used the DAAB very successfully with SQL Server and am now looking
to use it on a project using Access. However, I'm having great trouble
finding decent examples. The quickstart uses SQL Server as does
everything I can find in the docs. Can Anybody recommend an online
guide/example please?

Incidentally, my connstring part of the dataconfiguration section of
the app.config reads :

<connectionStrings>
<add name="Connection String" connectionString="Data
Source=C:\Code\Platty\Platty.mdb;"
providerName="System.Data.OleDb" />
</connectionStrings>

Is that utter nonsense or not????

Thanks in advance

3 Aug 2006 3:10 PM

sloan

DAAB 2.0 was sql server specific.

If you're using the "Enterprise Library", the 1.1 version of the EntLib
shipped with Oracle, SqlServer.
However, you can put in OleDB access.

See
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=137F13F8-AA21-4042-BAB1-3781DF71DCDD
Adding it to the project was easier..since there are some private methods
need to be made public to have it outside the assembly.

Take the above code, and then add it to
http://www.microsoft.com/downloads/details.aspx?FamilyID=a7d2a109-660e-444e-945a-6b32af1581b3&DisplayLang=en

..

I'm not sure offhand of EntLib 2.0 OleDB ability.

<pba***@recoilsoft.com> wrote in message
Show quote

news:1154617232.836656.101230@75g2000cwc.googlegroups.com...
> Hi all,
> I've used the DAAB very successfully with SQL Server and am now looking
> to use it on a project using Access. However, I'm having great trouble
> finding decent examples. The quickstart uses SQL Server as does
> everything I can find in the docs. Can Anybody recommend an online
> guide/example please?
>
> Incidentally, my connstring part of the dataconfiguration section of
> the app.config reads :
>
>   <connectionStrings>
>     <add name="Connection String" connectionString="Data
> Source=C:\Code\Platty\Platty.mdb;"
>       providerName="System.Data.OleDb" />
>   </connectionStrings>
>
> Is that utter nonsense or not????
>
> Thanks in advance
>