Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
Which Access-Components do you use? Unified Interbase (which I use) has only a readonly Dataset-Component, but there is some alternative Dataset for it, called AlexsDataSet. I never used it, but it is reported to do the job. (http://www.progdigy.com/modules.php?name=UIB) Alternativley you could try ZeosDBO, which is what I used to connect to mysql - but there's an interbase-layer also. (http://zeos.firmos.at/portal.php) regards Lukas Howard Lee Harkness schrieb: I imported the csv files using IBEasy+, which worked ok except that it doesn't appear to like values starting with a zero, nor does it like dates before 1900. On 6/3/07, Howard Lee Harkness [EMAIL PROTECTED] wrote: No, I am running Windows XP Pro. The files appear be writeable -- I can update them with FlameRobin ok, just not with my Lazarus program. On 6/3/07, Cesar Romero [EMAIL PROTECTED] wrote: Howard, I managed to get Firebird running, and I was able to display the contents of a table in a dbgrid -- but my program insists that the database is read-only. I can't find where I set any read-only flags. Anybody recognize the problem can tell me what I'm doing wrong? Is that in linux? I think you need to set file mode access and owner. Set the owner with chown to firebird user and permition with chmod. []s Cesar Romero _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives -- [EMAIL PROTECTED] -- software security networks Lukas Gradl lazarus#ssn.at Eduard-Bodem-Gasse 9 A - 6020 Innsbruck Tel: +43-720-300168-0 Fax: +43-512-341033-19 _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
I imported the csv files using IBEasy+, which worked ok except that it doesn't appear to like values starting with a zero, nor does it like dates before 1900. On 6/3/07, Howard Lee Harkness [EMAIL PROTECTED] wrote: No, I am running Windows XP Pro. The files appear be writeable -- I can update them with FlameRobin ok, just not with my Lazarus program. On 6/3/07, Cesar Romero [EMAIL PROTECTED] wrote: Howard, I managed to get Firebird running, and I was able to display the contents of a table in a dbgrid -- but my program insists that the database is read-only. I can't find where I set any read-only flags. Anybody recognize the problem can tell me what I'm doing wrong? Is that in linux? I think you need to set file mode access and owner. Set the owner with chown to firebird user and permition with chmod. []s Cesar Romero _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives -- [EMAIL PROTECTED] -- Howard Lee Harkness 214 269 1171 _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
I managed to get Firebird running, and I was able to display the contents of a table in a dbgrid -- but my program insists that the database is read-only. I can't find where I set any read-only flags. Anybody recognize the problem can tell me what I'm doing wrong? On 4/2/07, Razvan Adrian Bogdan [EMAIL PROTECTED] wrote: The Firebird website and IPPhoenix have lot's of tools for every task you might need :) Razvan _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives -- [EMAIL PROTECTED]
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
Howard, I managed to get Firebird running, and I was able to display the contents of a table in a dbgrid -- but my program insists that the database is read-only. I can't find where I set any read-only flags. Anybody recognize the problem can tell me what I'm doing wrong? Is that in linux? I think you need to set file mode access and owner. Set the owner with chown to firebird user and permition with chmod. []s Cesar Romero _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
I finally got Firebird installed and tested on my home system, so I am now in a position to start checking out how to access it with Lazarus. I've got some time this weekend set aside to work on migrating a 19-year-old database application that I wrote for an attorney (originally using Turbo Pascal!). I don't even have a drive that will read the original 1.2MB diskettes anymore, but I was foresighted enough to keep copies of all the software and utilities in several forms, including a complete copy of the source on the attorney's system. One of the utilities that was foresighted enough to write was one that dumps all of the tables into CSV format. Any recommendations for the best way to get a CSV file imported into a Firebird database? Thanks to everyone for the suggestions and information! On 3/29/07, Lee Jenkins [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: try with http://www.progdigy.com/modules.php?name=UIB, support Lazarus and works fine for Firebird, Interbase and Yaffil. Include several components: I've used UIB components in Laz myself and they are good. Recently, I tried the PDO stuff and while it's not TDataset decendant, I really like it. It supports FB as well as MySQL as well. I hope they end up putting SQLITE support as well. That would round off my databases nicely. http://pdo.sourceforge.net/ -- Warm Regards, Lee _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives -- [EMAIL PROTECTED] _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
Howard Lee Harkness wrote: One of the utilities that was foresighted enough to write was one that dumps all of the tables into CSV format. Any recommendations for the best way to get a CSV file imported into a Firebird database? Not for lazarus. I have have some nice components for that sort of thing for delphi that I purchased a while back. For yourself, you could just parse the file and build your SQL on the fly. Just remember for Firebird to commit your transaction every x number of records during the import process. Maybe every 1K - 5K records, piped in, commit and restart your transaction. Otherwise, FB may bog down from the non-committed transaction. -- Warm Regards, Lee _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
You can load your file with a TFixedFormatDataSet or a TSdfDataSet, and then copy to a dataset connected to the Firebird database. Howard Lee Harkness wrote: One of the utilities that was foresighted enough to write was one that dumps all of the tables into CSV format. Any recommendations for the best way to get a CSV file imported into a Firebird database?
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
Howard Lee Harkness wrote: I finally got Firebird installed and tested on my home system, so I am now in a position to start checking out how to access it with Lazarus. I've got some time this weekend set aside to work on migrating a 19-year-old database application that I wrote for an attorney (originally using Turbo Pascal!). I don't even have a drive that will read the original 1.2MB diskettes anymore, but I was foresighted enough to keep copies of all the software and utilities in several forms, including a complete copy of the source on the attorney's system. One of the utilities that was foresighted enough to write was one that dumps all of the tables into CSV format. Any recommendations for the best way to get a CSV file imported into a Firebird database? Thanks to everyone for the suggestions and information! There is: http://fbexport.sourceforge.net/ _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
[lazarus] Anybody on this list use Firebird database with Lazarus?
Anybody on this list use Firebird database with Lazarus? I'm looking for general information on this, and I ran into a dead end while trying to find the ODBC drivers, so I'm hoping somebody here has found a better way -- or knows where to find those drivers. -- [EMAIL PROTECTED] _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
On Thu, 29 Mar 2007, Howard Lee Harkness wrote: Anybody on this list use Firebird database with Lazarus? I'm looking for general information on this, and I ran into a dead end while trying to find the ODBC drivers, so I'm hoping somebody here has found a better way -- or knows where to find those drivers. Why don't you use the native firebird connection from sqldb ? It works out of the box ? Michael. _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
Ok, thanks -- I didn't know that there was a native connection. BTW, I did find the ODBC driver. On 3/29/07, Michael Van Canneyt [EMAIL PROTECTED] wrote: On Thu, 29 Mar 2007, Howard Lee Harkness wrote: Anybody on this list use Firebird database with Lazarus? I'm looking for general information on this, and I ran into a dead end while trying to find the ODBC drivers, so I'm hoping somebody here has found a better way -- or knows where to find those drivers. Why don't you use the native firebird connection from sqldb ? It works out of the box ? Michael. _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives -- [EMAIL PROTECTED] _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
try with http://www.progdigy.com/modules.php?name=UIB, support Lazarus and works fine for Firebird, Interbase and Yaffil. Include several components: TJvUIBDatabase. TJvUIBTransaction. TJvUIBQuery. TJvUIBBackup. TJvUIBRestore. TJvUIBScript. TJvUIBDataSet read only). TJvUIBRepair. TJvUIBSecurity. TJvUIBEvents. TJvUIConfig. El jue, 29-03-2007 a las 10:23 -0500, Howard Lee Harkness escribió: Anybody on this list use Firebird database with Lazarus? I'm looking for general information on this, and I ran into a dead end while trying to find the ODBC drivers, so I'm hoping somebody here has found a better way -- or knows where to find those drivers.
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
On 3/29/07, Howard Lee Harkness [EMAIL PROTECTED] wrote: Anybody on this list use Firebird database with Lazarus? I'm looking for general information on this, and I ran into a dead end while trying to find the ODBC drivers, so I'm hoping somebody here has found a better way -- or knows where to find those drivers. You have many options, the recommended way would be (as Michael said) to use the SQLDB, other options are Zeos, UIB and others, you may check the Lazarus wiki for more info :) Razvan _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
[EMAIL PROTECTED] wrote: try with http://www.progdigy.com/modules.php?name=UIB, support Lazarus and works fine for Firebird, Interbase and Yaffil. You have also ZeosLib - http://zeos.firmos.at El jue, 29-03-2007 a las 10:23 -0500, Howard Lee Harkness escribió: Anybody on this list use Firebird database with Lazarus? I'm looking for general information on this, and I ran into a dead end while trying to find the ODBC drivers, so I'm hoping somebody here has found a better way -- or knows where to find those drivers. -- Joao Morais _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
I have been using Firebird with Lazarus in a commercial environment for over a year now, with great success. I highly recommend the FBLib Firebird Library [http://fblib.altervista.org] with Lazarus. The reason I chose FBLib over SqlDB (that comes with Free Pascal) is because FBLib has support for the Firebird Services (remote backup, restore, gfix, log viewing, etc) that SqlDB currently doesn't support. I needed those Firebird Services in my applications. Unfortunately I can't help you with ODBC, never had the need to use it before. Regards, - Graeme - On 3/29/07, Howard Lee Harkness [EMAIL PROTECTED] wrote: Anybody on this list use Firebird database with Lazarus? I'm looking for general information on this, and I ran into a dead end while trying to find the ODBC drivers, so I'm hoping somebody here has found a better way -- or knows where to find those drivers. -- [EMAIL PROTECTED] _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives -- Graeme Geldenhuys There's no place like S34° 03.168' E018° 49.342' _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Anybody on this list use Firebird database with Lazarus?
[EMAIL PROTECTED] wrote: try with http://www.progdigy.com/modules.php?name=UIB, support Lazarus and works fine for Firebird, Interbase and Yaffil. Include several components: I've used UIB components in Laz myself and they are good. Recently, I tried the PDO stuff and while it's not TDataset decendant, I really like it. It supports FB as well as MySQL as well. I hope they end up putting SQLITE support as well. That would round off my databases nicely. http://pdo.sourceforge.net/ -- Warm Regards, Lee _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
