How to connect to MS Access....

25 Feb 2006 1:28 AM

Pete Smith

How to connect to MS Aceess using vb.net & .Net Framework 1.1?
System.Data.Odbc or

System.Data.SqlClient ?

What is the rightway of doing this?

Thank you,

Pete

25 Feb 2006 2:56 AM

Cyril Gupta

Hello,

The correct namespace is Microsoft.Data.OleDB

Regards
Cyril Gupta

27 Feb 2006 4:54 PM

Pete Smith

Thank you for the reply.
What about "System.Data.Odbc" ?
Pete

Show quoteHide quote

"Cyril Gupta" <nomail@nospam.com> wrote in message
news:OiW%23ZodOGHA.2336@TK2MSFTNGP12.phx.gbl...
> Hello,
>
> The correct namespace is Microsoft.Data.OleDB
>
> Regards
> Cyril Gupta
>
>

27 Feb 2006 5:04 PM

Paul Clement

On Mon, 27 Feb 2006 08:54:10 -0800, "Pete Smith" <PeteSmit***@hotmail.com> wrote:

¤ Thank you for the reply.
¤ What about "System.Data.Odbc" ?
¤ Pete

No, don't use it as the basis for your application. That would require the MS Access ODBC driver
which isn't as stable at the Jet OLEDB Provider.

Paul
~~~~
Microsoft MVP (Visual Basic)

27 Feb 2006 7:43 PM

Pete Smith

Thank you for the suggestion.
Pete

"Paul Clement" <UseAdddressAtEndofMess***@swspectrum.com> wrote in message
news:d5c602174gtaviickvcrej7fhpggdrm1qn@4ax.com...
> On Mon, 27 Feb 2006 08:54:10 -0800, "Pete Smith" <PeteSmit***@hotmail.com>
wrote:
>
> ¤ Thank you for the reply.
> ¤ What about "System.Data.Odbc" ?
> ¤ Pete
>
> No, don't use it as the basis for your application. That would require the

MS Access ODBC driver
Show quoteHide quote

> which isn't as stable at the Jet OLEDB Provider.
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

25 Feb 2006 3:30 AM

Kerry Moorman

Pete,

System.Data.OleDb

Kerry Moorman

Show quoteHide quote

"Pete Smith" wrote:

> How to connect to MS Aceess using vb.net & .Net Framework 1.1?
> System.Data.Odbc or
>
> System.Data.SqlClient ?
>
> What is the rightway of doing this?
>
> Thank you,
>
> Pete
>
>
>
>
>
>
>
>
>