Search DaniWeb - firebird

Firebird BLOB from MSACCESS VB 18 Years Ago by bvb Hi All, I'm trying get access to a Firebird BLOB field. I have linked the input table using ODBC(… Lib "fbclient.dll" (params as....) as result_type for Firebird data communication functions? Thanks for any idea BVB firebird database 18 Years Ago by amithasija i have two questions? i made my window application in c# using standalone firebird database ,now i want to make my exsisting application database as emmbedded firebird database???? how can i,and also want to implement import feature in my application,which imports the database backup file(export is working fine). Firebird and PHP (or help with PHP Generator) 15 Years Ago by coolmike … need help with using php to dislplay data from a firebird database. I've tried various methods but no success so… class="hr">http://www.sqlmaestro.com/products/firebird/phpgenerator/</td></tr></table>… Firebird 2.1, Linux and Delphi Application 15 Years Ago by instinctfx … client and have developed a small application that uses a firebird backend (ver 2.1.xxxxx) Now, i managed to fix… a permissions issue on Vista with firebird BUT when i run this same app with the database… Firebird and TransactionScope 11 Years Ago by pritaeas …: http://tracker.firebirdsql.org/browse/DNET-540 If someone using Firebird and C# could verify this for me, or shed some… If your Firebird application doesn't work... 20 Years Ago by jwenting … unavailable" when trying to connect to a Firebird database even if fbserver is running fine (and Java…etc.). [B]Scenario:[/B] You have just installed Firebird on a machine that previously had Interbase installed and are…existing GDB32.DLL from the bin directory of the Firebird installation. Close the client application first (this can… Create Database Firebird from NSIS 14 Years Ago by flowtowin …to make a package installer for my c# application and Firebird as my database. And i use NSIS. what i …want to do is : 1.install Firebird 2.Create a Database 3.install my c# application for… i use this command : ExecDos::exec "C:\Program Files\Firebird\Firebird_2_5\bin\isql.exe" "CREATE DATABASE 'localhost:D… Insert image into Firebird/Interbase using ODBC 15 Years Ago by kerek2 … help regarding how to insert image into blob field in Firebird/Interbase 6.0....I'm using connection trough ODBC ( "…;DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME=c:\ibss… HELP...how to insert date into firebird when null 15 Years Ago by kerek2 Can anyone help me how to insert date into firebird?....i get the date value from other field then need to insert it into other database...but the problem is when the column is null the n it cannot insert it..anyone get idea?...tq Lucid Lynx + Firebird 2.5 ?? 14 Years Ago by Ritesh_4 Hello Anyone knows how I can proceed to setup Firebird 2.5 on my Lucid Lynx? The command apt-get install firebird2.5-superserver is not able to locate the package... :-O mySQL to firebird?? 13 Years Ago by Spiderpig085 … as an address book style program. However it uses a firebird backend db. I have a mySQL webserver and I want… Re: mySQL to firebird?? 13 Years Ago by Spiderpig085 I want the web server to be constantly updated by users on the web and then t&e open contacts to be synchronized weekly/daily. The data will be persistent on the web server but will then replace all data on the firebird server when it sync's thanks..... Re: mySQL to firebird?? 13 Years Ago by Spiderpig085 I want the web server to be constantly updated by users on the web and then t&e open contacts to be synchronized weekly/daily. The data will be persistent on the web server but will then replace all data on the firebird server when it sync's thanks..... Creating user in firebird database in vb.net 13 Years Ago by satti Hi ya, Iam using firebird v 2.5 database with vb.net .i just want a help regarding how to create a new user in fb database programmatic ally in vb.net . thank you. php script for connecting PHP to firebird database . .HELP?? 13 Years Ago by skitband does anyone knows how to connect php to firebird database is there any tools or just a script i can use to connect . . replies for help are very much appreciated TY . . . How to get data from a column by selecting column name in firebird 11 Years Ago by satti … of that column . my combo code for getting columns from firebird db is Private Sub txt1_GotFocus(ByVal sender As Object, ByVal… Re: Firebird 2.1, Linux and Delphi Application 15 Years Ago by instinctfx Side note: On restarting the application, the written data does not write back to the database (UPDATE SQLs and Insert data is not getting back to the database) Re: Firebird 2.1, Linux and Delphi Application 15 Years Ago by instinctfx It was the engine between the db and application Apparently it doesnt like nested transactions but never likes to thrown an exception about it either. Re: 97 Firebird runs rough thought it was fuel pump but it's not 15 Years Ago by stixs Hi, Have you ran feul injector cleaner though the fuel tank to clean injectors? I had a similar problem with my 96 Firebird. Ran injector cleaner though the fuel tank and problem cleared up. Ed firebird database problem 15 Years Ago by bernardb7726 I am sitting with a situation that I have to combined (3 years) for 26 site of 29000 database files where there is 1 table in each data base called RECDATA, I need to combined all that data Into one database file called RECDATA For example there is a database called DB1 with a REDATA table inside it, and then DB2 with a RECDATA table inside it… firebird database problem 15 Years Ago by bernardb7726 I am sitting with a situation that I have to combined (3 years) for 26 site of 29000 database files where there is 1 table in each data base called RECDATA, I need to combined all that data Into one database file called RECDATA For example there is a database called DB1 with a REDATA table inside it, and then DB2 with a RECDATA table inside it… Re: firebird database problem 15 Years Ago by kvprajapati Have a look at - [url]http://fbexport.sourceforge.net/[/url] Firebird getting max int 11 Years Ago by pritaeas Am looking for a way to get the maximum value of an integer data type in a function. Since FB doesn't have an unsigned type, casting from -1 doesn't work. Nor can I find any built-in constant or function to get it. Any other ideas? (Am not looking to hardcode any value.) Re: Firebird getting max int 11 Years Ago by diafol Not sure if I quite follow p, I got this info: INTEGER is a signed 32-bit integer (range –/+ 2,147,483,648) From http://www.janus-software.com/fbmanual/manual.php?book=psql&topic=29 So I'm assuming you're looking for a function to return that (or whatever any new value in newer versions would be)? Would range of integer change though? Re: Firebird getting max int 11 Years Ago by pritaeas > So I'm assuming you're looking for a function to return that (or whatever any new value in newer versions would be)? Correct. > Would range of integer change though? No, but I'd like it to work on the [different data types](http://www.firebirdsql.org/manual/migration-mssql-data-types.html) (int, smallint, decimal etc.), so that my query … Re: Firebird getting max int 11 Years Ago by diafol OK, that makes sense. I had a quick scan and couldn't find one either. So something like an `int.MAX` type thingy - no - failed :( I'm assuming it's to prevent an error in queries by validating input against field datatypes? Re: Firebird getting max int 11 Years Ago by pritaeas > I'm assuming it's to prevent an error in queries by validating input against field datatypes? In my case to help order results, `null` being the highest available number. Re: Insert image into Firebird/Interbase using ODBC 15 Years Ago by kvprajapati [code] ... Dim byteArray() as byte=System.IO.File.ReadAllBytes("c:\x.png") Dim Str As String = "update CARDHOLDER set PHOTO = (@Img) where CARDHOLDERID =@Card" Dim cmd As New OleDbCommand(Str, cn) cmd.Parameters.Add("@Img", odbcType.Binary,byteArray.Length).Value=byteArray cmd.Parameters.Add("@Card",… Re: Insert image into Firebird/Interbase using ODBC 15 Years Ago by kerek2 Got this error bro : Failed to convert parameter value from a Byte[] to a Int16. Can u help me.. Re: Insert image into Firebird/Interbase using ODBC 15 Years Ago by kerek2 Ok..i can managed to do ...so i share it to whom want it.... [CODE] Dim photofilepath As String = ("" & myReader.Item(0) & ".jpg") Dim photo() As Byte = GetPhoto(photofilepath) ' Dim name As String = photoFilePath.Substring(photoFilePath.LastIndexOf("\") + 1)…