Answer: Microsoft Application Blocks For ODBC

Is there a "version" of the Microsoft Application Blocks to be used with ODBC databases like Access or Oracle?

The one for SQL works great but it only works for SQL, not other DBs.

[188 byte] By [mcatet] at [2007-12-17]
# 1
mcatet,

Check out the new Data Access Application Block available at the link below. This block abstracts the Database and provides you out of the box with SqlDatabase, OracleDatabase and Db2Database classes.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp

Gary Blatt wrote a great article to prime you up on the Enterprise Library located here:

http://www.dotnetjunkies.com/Tutorial/29EF3A4F-A0C2-4BB2-A215-8F87F100A9F9.dcik

- David Sandor

dsandor at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...
# 2
I'm currently using Data Application Blocks V2 but it only has classes using SQLClient. I looked at the Enterprise Library and like it. It is all the application blocks in one place. Is there a VB version of it?

Also, is there anything specifically for Microsoft Access? I have a number of Access DB's I need to connect to but can't convert them to SQL (Or anything else for that matter).

I would rather not spend time building a class to use OleDB instead of SQLClient if I don't have to.

Thanks for the links.

mcatet at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...

.NET Development

Site Classified