sorted by: recent | see : popular

Content Tagged with Technical + blogroll

Some last database repair cases we did were with multi-file databases. Interesting, that latest InterBase and Firebird versions was used, and also file system for the storage was NTFS, not FAT32 and FAT16. But, the databases was created and maintained using 1 gigabyte files. [ED: seems that is better to put the database  on an good [...]

If you get this message in firebird.log Fatal lock manager error: semaphores are exhausted, errno: 1 It means that you sould try to increase semaphores count in firebird.conf.                    

Server generated values - not only autoincrements are very useful think. Entity Framework supports two types “Computed” and “Identity”. When you update or insert entity, these fields are automatically refreshed according to state in database (after calling SaveChanges). For more info look at StoreGeneratedPattern.                    

After a long struggle on Devshed forums I decided to try on my own, after all I know Firebird and don’t see why it and ColdFusion can’t play nice together … infact they did, and easily.                    

Other than CREATE USER something really valuable has been added, the ability to query other databases.                    

Some of you reading this may remember that back when InterBase 6.0 was released on Solaris we ran into a fundamental problem on Solaris. It seems that since 1992 there has been an open bug documenting Solaris’ file descriptor problem: “32-bit stdio routines should support file descriptors >255.” When this issue was discovered, we chose to [...]

If you try to connect with Real Basic here is the How To

Firebird .NET provider has ability to create parameterized queries. Both named and unnamed parameters are supported. Everything works as you expect with select, insert, delete or update commands. The tricky part comes with stored procedures. Unlike MS SQL, that has direct support for named parameters, in provider, we’re parsing parameter names and we’re sending it [...]

http://home.lsces.co.uk/lsces/wiki/index.php?page=FirebirdSQL+Reference Has MySQL updated to 6.0 and PostgreSQL updated to 8.2. Some pages will request a login. That is because we are using private information to provide them and can’t allow access in the public domain.

Here is the tutorial in Spanish Este pequeño tutorial lo he hecho para compartir mis experiencias y los caminos q he tenido que recorrer para llegar a acceder a mi base de datos favorita “FIREBIRD”, sin embargo este tutorial puede ser usado para acceder a CUALQUIER BASE DE DATOS siempre cuando tengas su driver odbc; asi [...]

Today I decide to put up a post about a common requirement which leads to an interesting SQL query (see an example here) using Firebird and Flamerobin, after a few seconds I was writing bug reports

Here is the guide in spanish for installing firebird 2.0 on debian using alien and firebird rpm package [ED:there’s More Than One Way To Do the install .]

an great post with an alternate way of installing firebird 2.0.x in ubuntu 7.10 (from tar.gz) via dbrunas.com.ar

With the growing concerns regarding comment SPAM, XSS attacks, security breaches, etc, we should spend some time learning how to defend ourselves against such threats.etc. So, let’s focus on securing our PHP server, thus barring most of the attacks from the start. http://www.alberton.info/secure_php_installation.html

I’ve decided to try to install into VS2008 the DDEX provider. It has been working like a charm. I’ve been doing steps like in any other installation

This is the results of a single successful installation of Firebird SQL server on Leopard. Most of the configuration was carried out while on a short commuter flight from Ottawa to Toronto this evening, there exists no warrantee or promises.

I am getting the following controller exception when trying to access my newly installed Firebird DB  (to replace MySQL) from my app. [See remaining text…]  libfbclient.so.1: cannot open shared object file: No such file or directory - /usr/local/lib/ruby/gems/1.8/gems/fireruby-0.4.0-i586- linux/lib/fr_lib.so [ED:Solution [...]

I have been a big fan of the Firebird database for a while now. It is a fast, reliable and maintenance free database which suits my needs. While it is very good at a couple of things, one of the features that I like is the fact that the entire database is stored in one [...]