Import BTR files?

I have in the past imported files from an AS400, and files from MS SQL, or
access etc.
Now I have a need to import the customer master table from a pervasive
database.
Having no experience with importing these types of files Iwanted to ask
first.
Can it be done, what do I need to know etc?
Thanks you
(the files end in .btr)

Carsten
Wed May 11 05:03:47 CDT 2005

Dan,

i have never heard about the database, but googled on "pervasive database
odbc". Among ~80.000 hits the following page was quite at the top:
http://www.pervasive.com/support/techpapers.asp

In the document
http://www.pervasive.com/documentation/techpapers/pdf/BestPractices_OLEDB_11
02.pdf they claim to offer an odbc and an oledb-driver.
Your client probably got the odbc or oledb-drivers.

Your program could be quite simple. Something like this:

lcConnString= 'Driver={Pervasive ODBC Client
Interface};ServerName=srvname;dbq=@dbname'
NOTE: OR
lcConnString= 'Provider=PervasiveOLEDB;Data Source=C:\path"'
lnConn= SQLConnect( lcConnString )
SQLExec( lnConn, "SELECT * FROM <table>", "MyCursor" )
NOTE: Now the records are in a cursor called MyCursor

Read more about connectionstrings on: http://www.connectionstrings.com/

--
Cheers
Carsten
_______________________________

"Dan Williams" <danATwillcraft.com> schrieb im Newsbeitrag
news:11828t0k021vj29@news.supernews.com...
> I have in the past imported files from an AS400, and files from MS SQL, or
> access etc.
> Now I have a need to import the customer master table from a pervasive
> database.
> Having no experience with importing these types of files Iwanted to ask
> first.
> Can it be done, what do I need to know etc?
> Thanks you
> (the files end in .btr)
>
>

Paul
Wed May 11 12:01:03 CDT 2005

Yes, it can be done. I access Btrieve data via ODBC. It's also possible to
use a third party tool such as AutoBTR.

Btrieve data is different in that the data structure is defined by a DDF
file, which is external to the data file.

Pervasive sells a "Workgroup engine" which allows access by both the new
ODBC driver and legacy apps. It's pretty cheap, and comes with a license for
five workstations in the local group. Access via ODBC is tolerable if you're
simply reading a table, but doing even simple joins is excruciatingly slow.
There are two methods of accessing the data, SQL and Transactional. AutoBTR
uses transactional, which I think will be much faster (I don't have much
experience with it), but it does not bring back data in the familiar cursor
format.

Pervasive also sells a server engine, much more expensive, but still way
cheaper than MSSQL.



"Dan Williams" <danATwillcraft.com> wrote in message
news:11828t0k021vj29@news.supernews.com...
>I have in the past imported files from an AS400, and files from MS SQL, or
>access etc.
> Now I have a need to import the customer master table from a pervasive
> database.
> Having no experience with importing these types of files Iwanted to ask
> first.
> Can it be done, what do I need to know etc?
> Thanks you
> (the files end in .btr)
>

Dan
Wed May 11 12:55:30 CDT 2005

Hi Paul,
What we want to do is on a scheduled nightly basis:
-import the customer master, and the parts master tables from the third
party database, to the custom written VFP database.
The main Business Application Software that is using Pervasive for Linux,
has all of the customer data, and parts inventory data. The Custom VFP app
for respect to the vendor of the Business Application Software will not tie
the two together. So the next best thing for us is to get that data nightly
(saves manually keeping up both databases)
Dan

"Paul Pedersen" <no-reply@swen.com> wrote in message
news:uScBFskVFHA.616@TK2MSFTNGP12.phx.gbl...
> Yes, it can be done. I access Btrieve data via ODBC. It's also possible to
> use a third party tool such as AutoBTR.
>
> Btrieve data is different in that the data structure is defined by a DDF
> file, which is external to the data file.
>
> Pervasive sells a "Workgroup engine" which allows access by both the new
> ODBC driver and legacy apps. It's pretty cheap, and comes with a license
> for five workstations in the local group. Access via ODBC is tolerable if
> you're simply reading a table, but doing even simple joins is
> excruciatingly slow. There are two methods of accessing the data, SQL and
> Transactional. AutoBTR uses transactional, which I think will be much
> faster (I don't have much experience with it), but it does not bring back
> data in the familiar cursor format.
>
> Pervasive also sells a server engine, much more expensive, but still way
> cheaper than MSSQL.
>
>
>
> "Dan Williams" <danATwillcraft.com> wrote in message
> news:11828t0k021vj29@news.supernews.com...
>>I have in the past imported files from an AS400, and files from MS SQL, or
>>access etc.
>> Now I have a need to import the customer master table from a pervasive
>> database.
>> Having no experience with importing these types of files Iwanted to ask
>> first.
>> Can it be done, what do I need to know etc?
>> Thanks you
>> (the files end in .btr)
>>
>
>

Paul
Thu May 12 00:50:55 CDT 2005

If it's using a newer version of the Pervasive engine, you might have the
ODBC drivers installed already, so it should be easy enough to set up a data
source.


"Dan Williams" <danATwillcraft.com> wrote in message
news:1184h9i2vjka30@news.supernews.com...
> Hi Paul,
> What we want to do is on a scheduled nightly basis:
> -import the customer master, and the parts master tables from the third
> party database, to the custom written VFP database.
> The main Business Application Software that is using Pervasive for Linux,
> has all of the customer data, and parts inventory data. The Custom VFP app
> for respect to the vendor of the Business Application Software will not
> tie the two together. So the next best thing for us is to get that data
> nightly (saves manually keeping up both databases)
> Dan
>
> "Paul Pedersen" <no-reply@swen.com> wrote in message
> news:uScBFskVFHA.616@TK2MSFTNGP12.phx.gbl...
>> Yes, it can be done. I access Btrieve data via ODBC. It's also possible
>> to use a third party tool such as AutoBTR.
>>
>> Btrieve data is different in that the data structure is defined by a DDF
>> file, which is external to the data file.
>>
>> Pervasive sells a "Workgroup engine" which allows access by both the new
>> ODBC driver and legacy apps. It's pretty cheap, and comes with a license
>> for five workstations in the local group. Access via ODBC is tolerable if
>> you're simply reading a table, but doing even simple joins is
>> excruciatingly slow. There are two methods of accessing the data, SQL and
>> Transactional. AutoBTR uses transactional, which I think will be much
>> faster (I don't have much experience with it), but it does not bring back
>> data in the familiar cursor format.
>>
>> Pervasive also sells a server engine, much more expensive, but still way
>> cheaper than MSSQL.
>>
>>
>>
>> "Dan Williams" <danATwillcraft.com> wrote in message
>> news:11828t0k021vj29@news.supernews.com...
>>>I have in the past imported files from an AS400, and files from MS SQL,
>>>or access etc.
>>> Now I have a need to import the customer master table from a pervasive
>>> database.
>>> Having no experience with importing these types of files Iwanted to ask
>>> first.
>>> Can it be done, what do I need to know etc?
>>> Thanks you
>>> (the files end in .btr)
>>>
>>
>>
>
>

swdev2
Sat May 14 17:09:14 CDT 2005

Heya Dan -
The Custom VFP app CAN talk to the Business Application Software,
technically,
via Pervasive's odbc drivers. I'll bet you anything you already own them
[or the legal holder of the Pervasive license already has the odbc drivers]

I can not think of a technical reason why this would not work -
in essence - the only reason it MIGHT not work comes about as a result of a
decision made
by a human NOT to do it.

Find That Human, and have a nice conversation. Then - let me know how that
works out .

mondo regards [Bill]
--
"Dan Williams" <danATwillcraft.com> wrote in message
news:1184h9i2vjka30@news.supernews.com...
> Hi Paul,
> What we want to do is on a scheduled nightly basis:
> -import the customer master, and the parts master tables from the third
> party database, to the custom written VFP database.
> The main Business Application Software that is using Pervasive for Linux,
> has all of the customer data, and parts inventory data. The Custom VFP app
> for respect to the vendor of the Business Application Software will not
tie
> the two together. So the next best thing for us is to get that data
nightly
> (saves manually keeping up both databases)
> Dan
[snip]