Re: .dbf to firebird ??

Yes the data can be accessed with dBase.  It can read it just fine and use 
it with your dBase application.

But you need to create a ODBC connection in windows first.  Then use the BDE 
Administrator to set a link from dBase to the Firebird database via the ODBC 
driver.  After that you will be able to view, edit and update the firebird 
table with dBase.  Although this is your accounting package maybe you should 
stick to just reading the tables.

Claus


"Fred Evans" <fred@polyflexseals.co.za> wrote in message 
news:P5HFgHsTIHA.952@news-server...
> Hello all ,
>
> I suppose you could call me an old newbie-- 
> old because I have used dbase from dos
> and have much code that is don't want to rewrite
>
> old because I am 65 years old
>
> New because I know nothing about sql servers
>
> The writers of my accounting package ( turbocash ) have just brought
> out their networking version which uses firebird. I am upgrading to this
> version.
>
> I have a fairly complex manufacturing program written in dbase 42 which 
> used
> .dbf tables.
>
> I need to integrate seamlessly one particular part of my manufacturing
> program ( the stores and inventory section)
> into the stores and inventory section of the accounting package.They both
> have to be able to see whether there is stock on hand and find bin numbers
> etc. they both have to be able to adjust stock levels when used either as
> manufacturing raw material or sold directly from the store via over the
> counter sales that are recorded only by the accounting package.
>
> Looking into the folder containing the accounting data I see that the file
> extension used is .fdb.
>
> Is it possible to access this file using dbase plus?
>
> Obviously the next question will be how to do it-- all help will be
> gratefully received.
>
> regards fred evans
>
> 

Hello all ,

I suppose you could call me an old newbie-- 
old because I have used dbase from dos
and have much code that is don't want to rewrite

old because I am 65 years old

New because I know nothing about sql servers

The writers of my accounting package ( turbocash ) have just brought
out their networking version which uses firebird. I am upgrading to this
version.

I have a fairly complex manufacturing program written in dbase 42 which used
.dbf tables.

I need to integrate seamlessly one particular part of my manufacturing
program ( the stores and inventory section)
into the stores and inventory section of the accounting package.They both
have to be able to see whether there is stock on hand and find bin numbers
etc. they both have to be able to adjust stock levels when used either as
manufacturing raw material or sold directly from the store via over the
counter sales that are recorded only by the accounting package.

Looking into the folder containing the accounting data I see that the file
extension used is .fdb.

Is it possible to access this file using dbase plus?

Obviously the next question will be how to do it-- all help will be
gratefully received.

regards fred evans

Sorry I am not sure where you get the odbc driver for Firebird.  Perhaps 
some of the others in the news group will help out.

I know we have several firebird users

Claus

"Fred Evans" <fred@polyflexseals.co.za> wrote in message 
news:19aiKwxTIHA.952@news-server...
> thanks for this info Claus
>
> Problem- setting up an odbc connection through
> start-control panel-administrative tools-data sources-
>
> brings up form called ODBC data source administrator which has many 
> options
>
> I don't know which options to select -
>
> can you please give advice??
>
> many thanks
>
> fred evans
>
>
>
>
> "Claus Mygind" <cmygind@tsccorp.com> wrote in message
> news:ijhD7CuTIHA.544@news-server...
>> Yes the data can be accessed with dBase.  It can read it just fine and

>> use
>> it with your dBase application.
>>
>> But you need to create a ODBC connection in windows first.  Then use
the
> BDE
>> Administrator to set a link from dBase to the Firebird database via
the
> ODBC
>> driver.  After that you will be able to view, edit and update the 
>> firebird
>> table with dBase.  Although this is your accounting package maybe you
> should
>> stick to just reading the tables.
>>
>> Claus
>>
>>
>> "Fred Evans" <fred@polyflexseals.co.za> wrote in
message
>> news:P5HFgHsTIHA.952@news-server...
>> > Hello all ,
>> >
>> > I suppose you could call me an old newbie-- 
>> > old because I have used dbase from dos
>> > and have much code that is don't want to rewrite
>> >
>> > old because I am 65 years old
>> >
>> > New because I know nothing about sql servers
>> >
>> > The writers of my accounting package ( turbocash ) have just
brought
>> > out their networking version which uses firebird. I am upgrading
to 
>> > this
>> > version.
>> >
>> > I have a fairly complex manufacturing program written in dbase 42
which
>> > used
>> > .dbf tables.
>> >
>> > I need to integrate seamlessly one particular part of my
manufacturing
>> > program ( the stores and inventory section)
>> > into the stores and inventory section of the accounting
package.They
> both
>> > have to be able to see whether there is stock on hand and find
bin
> numbers
>> > etc. they both have to be able to adjust stock levels when used
either
> as
>> > manufacturing raw material or sold directly from the store via
over the
>> > counter sales that are recorded only by the accounting package.
>> >
>> > Looking into the folder containing the accounting data I see that
the
> file
>> > extension used is .fdb.
>> >
>> > Is it possible to access this file using dbase plus?
>> >
>> > Obviously the next question will be how to do it-- all help will
be
>> > gratefully received.
>> >
>> > regards fred evans
>> >
>> >
>>
>>
>
> 

thanks for this info Claus

Problem- setting up an odbc connection through
start-control panel-administrative tools-data sources-

brings up form called ODBC data source administrator which has many options

I don't know which options to select -

can you please give advice??

many thanks

fred evans




"Claus Mygind" <cmygind@tsccorp.com> wrote in message
news:ijhD7CuTIHA.544@news-server...
> Yes the data can be accessed with dBase.  It can read it just fine and use
> it with your dBase application.
>
> But you need to create a ODBC connection in windows first.  Then use the
BDE
> Administrator to set a link from dBase to the Firebird database via the
ODBC
> driver.  After that you will be able to view, edit and update the firebird
> table with dBase.  Although this is your accounting package maybe you
should
> stick to just reading the tables.
>
> Claus
>
>
> "Fred Evans" <fred@polyflexseals.co.za> wrote in message
> news:P5HFgHsTIHA.952@news-server...
> > Hello all ,
> >
> > I suppose you could call me an old newbie-- 
> > old because I have used dbase from dos
> > and have much code that is don't want to rewrite
> >
> > old because I am 65 years old
> >
> > New because I know nothing about sql servers
> >
> > The writers of my accounting package ( turbocash ) have just brought
> > out their networking version which uses firebird. I am upgrading to
this
> > version.
> >
> > I have a fairly complex manufacturing program written in dbase 42
which
> > used
> > .dbf tables.
> >
> > I need to integrate seamlessly one particular part of my
manufacturing
> > program ( the stores and inventory section)
> > into the stores and inventory section of the accounting package.They
both
> > have to be able to see whether there is stock on hand and find bin
numbers
> > etc. they both have to be able to adjust stock levels when used
either
as
> > manufacturing raw material or sold directly from the store via over
the
> > counter sales that are recorded only by the accounting package.
> >
> > Looking into the folder containing the accounting data I see that the
file
> > extension used is .fdb.
> >
> > Is it possible to access this file using dbase plus?
> >
> > Obviously the next question will be how to do it-- all help will be
> > gratefully received.
> >
> > regards fred evans
> >
> >
>
>

On Fri, 4 Jan 2008 12:46:40 +0200, in dbase.sql-servers, 
Subject: .dbf to firebird ??, 
Message-ID: <P5HFgHsTIHA.952@news-server>,  
"Fred Evans" <fred@polyflexseals.co.za> wrote:


>I suppose you could call me an old newbie-- 
>old because I have used dbase from dos
>and have much code that is don't want to rewrite
>
>old because I am 65 years old
>
>New because I know nothing about sql servers
>
>The writers of my accounting package ( turbocash ) have just brought
>out their networking version which uses firebird. I am upgrading to this
>version.

A Google search found a free accounting software TurboCash. On a page I noticed
a screenshot
indicating that 'The Borland Database Engine will be installed/upgraded in ...
C:\.....\BDE\

I could not find the word Firebird anywhere. Did I look at an older version?

>
>I have a fairly complex manufacturing program written in dbase 42 which
used
>.dbf tables.
>
>I need to integrate seamlessly one particular part of my manufacturing
>program ( the stores and inventory section)
>into the stores and inventory section of the accounting package.They both
>have to be able to see whether there is stock on hand and find bin numbers
>etc. they both have to be able to adjust stock levels when used either as
>manufacturing raw material or sold directly from the store via over the
>counter sales that are recorded only by the accounting package.
>
>Looking into the folder containing the accounting data I see that the file
>extension used is .fdb.
>
>Is it possible to access this file using dbase plus?

You mention that you have a network version using Firebird tables. I we forget
the network for the
moment and assume that you have TurboCash and your application on the same
machine you may already
have the Firebird server and the ODBC driver installed.

Open the control pane and look for an icon named 'Firebird 1.5 Server Manager'
The version number
may be different. Click it and check that the Firebird service is running and is
started
automatically. If you do not have the icon then click on the icon named
'Administration', then click
'Services' and check if the Firebird Server and the Firebird Guardian are
running. 

Assuming that said services are running we should now try to connect via an ODBC
driver.
Open the ODBC Administrator and select Tab 'System-DSN'. There should be two
columns 'Name' and
'Driver'. Look for a driver named 'Firebird/Interbase(r) driver'. Make a note of
the corresponding
DSN alias name entry in the Name column, then select the alias and press button
'Configure'. In the
window which opens find button 'Test connection' and press it, don't touch
anything else as you may
upset the configuration created by the TurboCash installation. If you get a
messagebox 'Connection
successful!' you have all you need to connect to the Firebird tables and the
next step should be to
create a corresponding BDE alias.  

As all the preceeding is based on assumptions let me know if you have any
success with the method
indicated above, before going to the next step.