We have used Vista with some success. The problem with Vista
is their
documentation leaves a lot to be desired. They don't answer
phones. You
can't even buy support for vista. It does work with DBF
files and it
will maintain indexes. You will have to probably write
wrapper around
it's functionality. The SQL engine they provide is limited
and will
maintain only one index. The code (SDE) they wrote to
maintain the
underlying Apollo engine seems to work the best - apparently
they
brought out Successware sometime ago. Basically, SDE is very
similar to
Clipper but in a .Net environment as far as database goes.
Apparently, I believe Vista has abandoned further
development and
enhancements for Apollo for .Net.
Hope this helps.
-----Original Message-----
From: Discussion of writing applications and components
using Visual
Basic .NET [mailto:VBDOTNET DISCUSS.DEVELOP.COM] On
Behalf Of Stacey
Levine
Sent: Tuesday, November 21, 2006 3:28 PM
To: VBDOTNETDISCUSS.DEVELOP.COM
Subject: Re: [VBDOTNET] suggestions for accessing DBASE III
files
You are correct. That is exactly what I am looking for. I
have found one
product by Vista Software, but it doesn't look like it has
been updated
in 3 years and that makes me a little wary. I am looking
for some type
of native .NET DBASE data provider
Thanks.
Stacey
-----Original Message-----
From: Discussion of writing applications and components
using Visual
Basic .NET [mailto:VBDOTNETDISCUSS.DEVELOP.COM] On
Behalf Of Stuart
Laughlin
Sent: Tuesday, November 21, 2006 3:11 PM
To: VBDOTNETDISCUSS.DEVELOP.COM
Subject: Re: [VBDOTNET] suggestions for accessing DBASE III
files
On 11/21/06, Stacey Levine <staceylmusicforasong.com>
wrote:
>
>
> My application currently accesses those files through a
linked table
in
> MS Access and I am looking for a way to speed this up.
If by 'this' you mean the database connectivity between
Access and
DBase,
I'm skeptical that you will succeed in your attempt to speed
it up.
Presumably Access is using OLE DB or ODBC to access DBase.
.NET will use
those same technologies, unless you can find a DBase .NET
Data Provider
that
accesses DBase 'natively'. There may be such a thing; I
don't know
anything
about that.
My point is simply that the standard way of interacting with
'legacy'
databases is via OLE DB or ODBC. I presume that is what
Access is using,
and
I presume that is the approach you would take via .NET. If
so, then in
both
cases you are dealing with the same technology/speed
limitations; in
...NET
you just get a pretty wrapper.
HTH,
--Stuart
===================================
This list is hosted by DevelopMentor(r) http://www.develop.com
View archives and manage your subscription(s) at
http://discuss.develop.com
===================================
This list is hosted by DevelopMentor(r) http://www.develop.com
View archives and manage your subscription(s) at
http://discuss.develop.com
===================================
This list is hosted by DevelopMentorŪ http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
|