suggestions for accessing DBASE III files

Just looking for suggestions for accessing DBASE III  (I
think it is III
it might be IV) files from .NET   

 

My application currently accesses those files through a
linked table in
MS Access and I am looking for a way to speed this up.

 

Stacey Levine

 

 


===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

We use .NET Framework Data Provider for OLE DB with
Microsoft OLE DB
Provider for Visual FoxPro (VFPOLEDB.1). The only problem we
discovered so
far is limitation of 255 fields per table.


-----Original Message-----
From: Discussion of writing applications and components
using Visual Basic
.NET [mailto:VBDOTNETDISCUSS.DEVELOP.COM] On Behalf Of Stacey
Levine
Sent: Tuesday, November 21, 2006 13:51
To: VBDOTNETDISCUSS.DEVELOP.COM
Subject: [VBDOTNET] suggestions for accessing DBASE III
files

Just looking for suggestions for accessing DBASE III  (I
think it is III
it might be IV) files from .NET



My application currently accesses those files through a
linked table in
MS Access and I am looking for a way to speed this up.



Stacey Levine






===================================
This list is hosted by DevelopMentor.  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

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Ū  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

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Ū  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

if you are using a sql server as part of this then you may
want to look into
setting up the dbase files as a linked server in sql.
then you accses the tables using 4 part naming as if it was
another sql
server object.

sql uses the same odbc drives that you setup with a DSN, but
i think there
may be some caching that gose on under the covers to help
performance...

or you could do away with direct access....setup the sql
linked server.
have a nightly...hourly (or smaller timespan maybe 2
minutes...depends on
requirements.) scheduled sql task to take a copy of the
content of the dbase
files into a sql db.  DTS wizard can get you 90% of the way
there with
apoint & click interface.

then write your code against the sql db.


-----Original Message-----
From: Discussion of writing applications and components
using Visual
Basic .NET [mailto:VBDOTNETDISCUSS.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.  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

Unfortunately, the DBASE files are part of a POS system at
our retail
locations.  These so there is a little bit of data stored in
a local MS
Access file, and occasionally I need to access the POS files
which are
DBASE

Thanks.
 
Stacey

-----Original Message-----
From: Discussion of writing applications and components
using Visual
Basic .NET [mailto:VBDOTNETDISCUSS.DEVELOP.COM] On
Behalf Of Phil
Sayers
Sent: Tuesday, November 21, 2006 3:32 PM
To: VBDOTNETDISCUSS.DEVELOP.COM
Subject: Re: [VBDOTNET] suggestions for accessing DBASE III
files

if you are using a sql server as part of this then you may
want to look
into
setting up the dbase files as a linked server in sql.
then you accses the tables using 4 part naming as if it was
another sql
server object.

sql uses the same odbc drives that you setup with a DSN, but
i think
there
may be some caching that gose on under the covers to help
performance...

or you could do away with direct access....setup the sql
linked server.
have a nightly...hourly (or smaller timespan maybe 2
minutes...depends
on
requirements.) scheduled sql task to take a copy of the
content of the
dbase
files into a sql db.  DTS wizard can get you 90% of the way
there with
apoint & click interface.

then write your code against the sql db.


-----Original Message-----
From: Discussion of writing applications and components
using Visual
Basic .NET [mailto:VBDOTNETDISCUSS.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.  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

On 11/21/06, Stacey Levine <staceylmusicforasong.com>
wrote:
>
> I have found one product by Vista Software...



With a name like that, I'd stay far far away! :P


--Stuart

===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

You could probably wrap our own. dBase format is simple.


-----Original Message-----
From: Discussion of writing applications and components
using Visual Basic
.NET [mailto:VBDOTNETDISCUSS.DEVELOP.COM] On Behalf Of Stacey
Levine
Sent: Tuesday, November 21, 2006 14:28
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.  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

When you link the table make sure the key(s) you select are
appropriate for how you will be selecting the data (I think
it prompts
for these with DBase III links).

Since POS DBII access is on an occasional basis, you may
find it
faster to transfer the contents to MS-Access and then
manipulate it
through Jet/OLEDB.  Often the difference is hugh depending
on the
number of records and how it is keyed.

A big advantage here is you can generate indexes for all the
fields
that will be referred to in the WHERE, GROUP BY and ORDER BY
clauses.
Often you can index a few hundred thousand records in
seconds and gain
several orders of magnitude in response.

- Len

On 11/21/06, Stacey Levine <staceylmusicforasong.com>
wrote:
> Just looking for suggestions for accessing DBASE III 
(I think it is III
> it might be IV) files from .NET
>
>
>
> My application currently accesses those files through a
linked table in
> MS Access and I am looking for a way to speed this up.
>

===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com