| Subject | Re: [firebird-support] How to connecto to an embedded Firebird? |
|---|---|
| Author | Helen Borrie |
| Post date | 2011-07-10T08:19:26Z |
At 10:26 AM 10/07/2011, you wrote:
Firebird is a product consisting of a database management engine and a client application programming interface (API). What you do on the client side depends totally on the language you use to write the client applications. It's not a one-language solution like Foxpro - which is *why* it has an API.
So - if I choose to write my application in ObjectPascal (a.k.a. Delphi, Kylix or Lazarus), I need to find an interpretation layer that lets my OP application talk to the Firebird API. As it happens, I use IBObjects. There are others.
If Java is my application language then I will use Jaybird, which does the same job on behalf of Java (albeit in a way that is architecturally a bit different: Jaybird is a fully native driver, that fully reimplements the C API in Java). If C++ is my language, I will use IBPP (as the FlameRobin developers did) or I might use Visual C++ (on Windows) or any one of a host of C++ environments on Linux. If C#, VB.NET or VFP.NET were my language, I would use the Firebird ADO .NET provider.
And so on...PHP, Python, Ruby...and all the rest.
There is no "Foxpro driver for Firebird", that I have heard of, although you might like to ask in firebird-tools. I think ODBC is the only option open to you using Foxpro.
./hb
>Hello HelenYes, it's impossible if Foxpro scripting is the only application language you know. Foxpro is a product consisting of a data storage system and a 100%-dedicated scripting language that was written to read from and write to *that* data storage system. It won't read from or write to a different data storage system without an ODBC driver.
>
>That mean that I cannot connect to a database without an ODBC driver?
>
>I want to make an application portable, without installation. That is very
>easily done with FoxPro native tables (.DBF tables)
>
>The user insert his/her pen-drive and the application works.
>
>Is impossible to do the same thing with Firebird embedded?
Firebird is a product consisting of a database management engine and a client application programming interface (API). What you do on the client side depends totally on the language you use to write the client applications. It's not a one-language solution like Foxpro - which is *why* it has an API.
So - if I choose to write my application in ObjectPascal (a.k.a. Delphi, Kylix or Lazarus), I need to find an interpretation layer that lets my OP application talk to the Firebird API. As it happens, I use IBObjects. There are others.
If Java is my application language then I will use Jaybird, which does the same job on behalf of Java (albeit in a way that is architecturally a bit different: Jaybird is a fully native driver, that fully reimplements the C API in Java). If C++ is my language, I will use IBPP (as the FlameRobin developers did) or I might use Visual C++ (on Windows) or any one of a host of C++ environments on Linux. If C#, VB.NET or VFP.NET were my language, I would use the Firebird ADO .NET provider.
And so on...PHP, Python, Ruby...and all the rest.
There is no "Foxpro driver for Firebird", that I have heard of, although you might like to ask in firebird-tools. I think ODBC is the only option open to you using Foxpro.
./hb