I have basically given up trying to connect to SQL Server through VB.NET in
real-time. I tried everything and have been unsuccessful (plus SQL server is
really overkill for my project), therefore I want to try to connect to MS
Access in real-time. I know VB.NET does not supply native drivers for Access
but does anyone know where I can find a third-party plugin?

RE: MS Access and VB.NET by G

G
Thu Dec 30 21:01:02 CST 2004

As far as I know, VB .Net does have a driver capable of connecting to MS
Access. Create a OLEDBDataConnection, set the provider to MS Access and off
you go. I don't think there is a native driver, but this works.


"Badge" wrote:

> I have basically given up trying to connect to SQL Server through VB.NET in
> real-time. I tried everything and have been unsuccessful (plus SQL server is
> really overkill for my project), therefore I want to try to connect to MS
> Access in real-time. I know VB.NET does not supply native drivers for Access
> but does anyone know where I can find a third-party plugin?
>
>

RE: MS Access and VB.NET by Badge

Badge
Fri Dec 31 12:09:02 CST 2004

Thanks ... I'll give it a shot.

"G Butler" wrote:

> As far as I know, VB .Net does have a driver capable of connecting to MS
> Access. Create a OLEDBDataConnection, set the provider to MS Access and off
> you go. I don't think there is a native driver, but this works.
>
>
> "Badge" wrote:
>
> > I have basically given up trying to connect to SQL Server through VB.NET in
> > real-time. I tried everything and have been unsuccessful (plus SQL server is
> > really overkill for my project), therefore I want to try to connect to MS
> > Access in real-time. I know VB.NET does not supply native drivers for Access
> > but does anyone know where I can find a third-party plugin?
> >
> >

RE: MS Access and VB.NET by Badge

Badge
Fri Dec 31 13:13:01 CST 2004

No good ... OLEDB is not supported in the .NET Compact Framework

"G Butler" wrote:

> As far as I know, VB .Net does have a driver capable of connecting to MS
> Access. Create a OLEDBDataConnection, set the provider to MS Access and off
> you go. I don't think there is a native driver, but this works.
>
>
> "Badge" wrote:
>
> > I have basically given up trying to connect to SQL Server through VB.NET in
> > real-time. I tried everything and have been unsuccessful (plus SQL server is
> > really overkill for my project), therefore I want to try to connect to MS
> > Access in real-time. I know VB.NET does not supply native drivers for Access
> > but does anyone know where I can find a third-party plugin?
> >
> >

Re: MS Access and VB.NET by Tim

Tim
Fri Dec 31 13:39:49 CST 2004

The CF really only supports SQL in this regard but you can work around the
problem using the component at the link below.
http://www.inthehand.com/index.php?page=5&show=1,2

--
Tim Wilson
.Net Compact Framework MVP

"Badge" <Badge@discussions.microsoft.com> wrote in message
news:5656870A-BAB6-4EAF-96D6-B0E04F7E1DE3@microsoft.com...
> No good ... OLEDB is not supported in the .NET Compact Framework
>
> "G Butler" wrote:
>
> > As far as I know, VB .Net does have a driver capable of connecting to MS
> > Access. Create a OLEDBDataConnection, set the provider to MS Access and
off
> > you go. I don't think there is a native driver, but this works.
> >
> >
> > "Badge" wrote:
> >
> > > I have basically given up trying to connect to SQL Server through
VB.NET in
> > > real-time. I tried everything and have been unsuccessful (plus SQL
server is
> > > really overkill for my project), therefore I want to try to connect to
MS
> > > Access in real-time. I know VB.NET does not supply native drivers for
Access
> > > but does anyone know where I can find a third-party plugin?
> > >
> > >



Re: MS Access and VB.NET by Badge

Badge
Sun Jan 02 14:03:01 CST 2005

I had already looked into this but there are two problems. The first being
that "In the Hand" only supports CE databases. I need to access an MS Access
database remotely. Second, they do not support the UPDATE command in SQL.
Without this feature, even if I wanted to use CE databases, makes it
worthless.

"Tim Wilson" wrote:

> The CF really only supports SQL in this regard but you can work around the
> problem using the component at the link below.
> http://www.inthehand.com/index.php?page=5&show=1,2
>
> --
> Tim Wilson
> ..Net Compact Framework MVP
>
> "Badge" <Badge@discussions.microsoft.com> wrote in message
> news:5656870A-BAB6-4EAF-96D6-B0E04F7E1DE3@microsoft.com...
> > No good ... OLEDB is not supported in the .NET Compact Framework
> >
> > "G Butler" wrote:
> >
> > > As far as I know, VB .Net does have a driver capable of connecting to MS
> > > Access. Create a OLEDBDataConnection, set the provider to MS Access and
> off
> > > you go. I don't think there is a native driver, but this works.
> > >
> > >
> > > "Badge" wrote:
> > >
> > > > I have basically given up trying to connect to SQL Server through
> VB.NET in
> > > > real-time. I tried everything and have been unsuccessful (plus SQL
> server is
> > > > really overkill for my project), therefore I want to try to connect to
> MS
> > > > Access in real-time. I know VB.NET does not supply native drivers for
> Access
> > > > but does anyone know where I can find a third-party plugin?
> > > >
> > > >
>
>
>