Reminder FirebirdSQL page at Facebook
FirebirdSQL page at Facebook – join now http://goo.gl/radCw
Author: mariuz
http://wiki.ubuntu.com/Mariuz
Firebird #ODBC Driver 2.0 Released
Alexander Potapchenko is happy to announce that he has released the v.2.0 ODBC/JDBC driver for Firebird. Access the What’s New document, sources and binaries for Windows and Linux 32-bit and 64-bit HERE
ps:don’t confuse it with Java jaybird driver this one is the ODBC driver but in the cvs tree is called ODBCJDBC
Success story : After NT4 death , firebird db started on another server
After the untimely demise of the NT server, I had to move the databases and the firebird server to a different computer. I had tried to do this before in December but was unable to connect from other computers on the network.
This time around, I noticed that I was getting a strange error message about temporary files; it turns out that the temporary file directory had been set to a directory which doesn’t exist. But more importantly, I still couldn’t get any computer to connect to the databases.
Read more on the blog (and the solution)
Vb.net solution : Update datagridview with numeric primary key
The vb.net grid issue, typical in Firebird, consist in the fact that, after you insert a new record with an autoincrement field in a datagridview, we have to exit from the application to be able to edit the new inserted record.
To solve this issue you have to proceed this way
pyfirebirdsql 0.3.4: python dbapi for firebird rdbms minor fixes
pyfirebirdsql released new minor version with small fixes
German article on the new Audit and Trace API is available
FYI: For the German speaking guys here. The originally published German article on the new audit and trace API in the Entwickler Magazin Edition 2.2010 is now available as download.
Check out my blog:
http://blog.upscene.com/thomas/index.php?entry=entry110404-124701
—
With regards,
Thomas Steinmaurer Read more
New Survey from Evans Data Corp
New Survey from Evans Data Corp. mentions Firebird as database , please complete the survey
Servers that don’t want to die Farewell NT4 server: you served us well for 13 years and now is the time to say goodbye
The full goodbye in tears story is on this blog
The server worked admirably as a file server and as a database server (Firebird) until a few months ago when the first Windows 7 machines started to arrive. Win7 had difficulty reading the files on the NT4 server and even more difficulty in creating files. With regret, we installed another computer (originally Win7 but swiftly downgraded to XP) which served as a file host; the NT4 kept on working as the Firebird server.
You’ve heard the story about the servers which stopped working every night? When the support team came to find out what had happened, they found that the janitor had unplugged the electricity cable in order to plug in his vacuum cleaner.
This story may be apocryphal but something similar happened this morning. The noise of the computer annoyed one of the psychologists who was sitting in the same room, so she unplugged the server! Instant death of the databases! We tried resuscitating the server but it kept on showing ‘MBR fault’ – obviously the master boot record of the server had been damaged. I imagine that someone, somewhere will know how to fix this, but we need those databases up and running now.
I’ve got the databases running on a temporary computer, but I will have to transfer them to the XP server. I tried this a few months ago, and whilst I was able to run the databases, I couldn’t connect to them from the Win7 machines. Now I have no option but to try again.
Farewell NT4 server: you served us well for 13 years and now is the time to say goodbye.
New writer for Firebird docs : Introduction
Steve Summers Vice President of the Firebird Foundation will contribute to firebird docs writing , here is his very nice intro
How to get the attachment with the Oldest Active Transaction via the Monitoring Tables
OAT and MON$ – How to get the attachment with the Oldest Active Transaction via the Monitoring Tables on Paul Beach’s blog.