In vs2005, is OleDb a good way to go?

18 Mar 2006 2:27 PM

Allen

I want to learn a little about database software.

I have a nice example that uses System.Data.OleDb.

I'd like to study it and extend it into something I can use.

It's a vs2003 solution.

My question is: I'm now running vs2005, is OleDb a good way to go or is
there a newer and better way then using it?

Thanks

18 Mar 2006 6:08 PM

Cor Ligthert [MVP]

Allen,

Use the special provider from a DataBase

I know that those are for SQL (SQLclient), Oracle and MySQL and maybe more.

If those are not there by instance for Access use OleDB.

The difference are not that much that you would miss something learn OleDB.
AFAIK are that in as major point only the parameters.

I hope this helps,

Cor

Show quoteHide quote

"Allen" <allen99NOSPAM@a-znet.com> schreef in bericht
news:%23DsaWgpSGHA.1608@TK2MSFTNGP09.phx.gbl...
>I want to learn a little about database software.
>
> I have a nice example that uses System.Data.OleDb.
>
> I'd like to study it and extend it into something I can use.
>
> It's a vs2003 solution.
>
> My question is: I'm now running vs2005, is OleDb a good way to go or is
> there a newer and better way then using it?
>
>
>
> Thanks
>
>
>
>

19 Mar 2006 2:13 PM

Ken Tucker [MVP]

Hi,

Sql Express allows you to attach a database easily. Here is a link
to an article on how to do that. I dont think there is any thing worng with
using access.
http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/emsqlexcustapp.asp

Ken
-------------------------------

Show quoteHide quote

"Allen" wrote:

> I want to learn a little about database software.
>
> I have a nice example that uses System.Data.OleDb.
>
> I'd like to study it and extend it into something I can use.
>
> It's a vs2003 solution.
>
> My question is: I'm now running vs2005, is OleDb a good way to go or is
> there a newer and better way then using it?
>
>
>
> Thanks
>
>
>
>
>

19 Mar 2006 6:32 PM

Allen

Thanks to both.
I'm bringing up that site now.

Show quoteHide quote

"Allen" <allen99NOSPAM@a-znet.com> wrote in message
news:%23DsaWgpSGHA.1608@TK2MSFTNGP09.phx.gbl...
>I want to learn a little about database software.
>
> I have a nice example that uses System.Data.OleDb.
>
> I'd like to study it and extend it into something I can use.
>
> It's a vs2003 solution.
>
> My question is: I'm now running vs2005, is OleDb a good way to go or is
> there a newer and better way then using it?
>
>
>
> Thanks
>
>
>
>