Peter's Gekko

Sponsors

The Lounge

Wicked Cool Jobs

News

Advertisement

Images in this post missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at imagehelp@codebetter.com
Firebird database, VS 2005 (sp1) and Vista

Just like last time getting the Firebird database working on my new machine was a long way of trial and error. I have Visual Studio 2005, installed sp1 and it’s running on Vista. Installing FB has become easier but support is still very fragmented. Worse is that essential parts contain typos which will lead to complete VS crashes. Hereby the recipe which does work. I have to thank Kai Bøhli a lot for his help.

  1. Install the FireBird client. Found here. Having completed that you will see the firebirdclient in the GAC.

  1. Edit the machine.config file (in the directory $WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\). There are online instructions here but do not take these literally. The example contains the values for the firebird-client 2.0.0.0 The current download is version 2.0.1.0, which has also a different public key. This does work for 2.0.1.0:

<section name="firebirdsql.data.firebirdclient"

type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" />

<system.data>

  <DbProviderFactories>

    <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient"

description=".Net Framework Data Provider for Firebird"

type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,

FirebirdSql.Data.FirebirdClient, Version=2.0.1.0, Culture=neutral,

PublicKeyToken=3750abcc3150b00c" />

What is essential is that both version and publickeytoken should match the values of the assembly in the gac.

  1. Install the Firebird data designer for VS 2005, found here
  2. Perform the registry update found here.

After these steps your VS 2005 supports FireBird.

Firebird server running on Vista

The firebird server does run on Vista (RC1) but one feature can completely trash your machine. Part of the setup is the control panel applet to start and stop the FB server. After installing this the Windows explorer crashes when trying to open the control panel. The good thing about the applet is that you do not have to install it; it’s an option in the setup. To start or stop Firebird just use the Window’s service manager.

The FireBird guardian service (listed just above the FireBird service) does the actual stop/restart work. Use that one to control the FB server. (Thanks Kai, where would I be without you :?)


Posted Fri, Nov 17 2006 3:51 AM by pvanooijen
Filed under:

[Advertisement]

Comments

Christopher Steen wrote Link Listing - November 17, 2006
on Fri, Nov 17 2006 10:05 PM

JavaScript Code Inefficiencies from the IE team [Via: Dion Almaer ] The S stands for Simple by Pete...

David Hayden [MVP C#] wrote Recommendations for Getting Started with MySQL, PostgreSQL, Firebird, etc. Databases and ASP.NET?
on Mon, Nov 27 2006 11:29 AM

In the very near future this may cause me to write several tutorials on using different open-source databases

pvanooijen wrote re: Firebird database, VS 2005 (sp1) and Vista
on Tue, Nov 28 2006 2:25 AM

hi David,

that would be welcome! As stated before my experience with OS products is that the documentation is bad, bad, bad. Makes it nice blog fodder :)

stephen wills wrote re: Firebird database, VS 2005 (sp1) and Vista
on Tue, Mar 6 2007 9:50 PM

Very clear and helpful guide, to help a novice like me to wade through the jungle of sdk's, msi installs and other things that may help get me to where i need. This helped me set up firebird for windows forms apps, thank you, but the big question for me is, do you know of a way i can use vs 2005 to create an app on a Pocket PC 2003 device that can access a firebird database?

pvanooijen wrote re: Firebird database, VS 2005 (sp1) and Vista
on Wed, Mar 7 2007 6:07 AM

There is no FB for the compact framework. What we did was build a webservice which serves the data. The Pocket PC communicates with the webservice. Works well.

stephen wrote re: Firebird database, VS 2005 (sp1) and Vista
on Wed, Mar 7 2007 7:34 PM

Ok, bummer:(

Thanks for your suggestion though

smadhu wrote re: Firebird database, VS 2005 (sp1) and Vista
on Tue, Mar 20 2007 11:54 AM

If you want to connect to firebird server from a remote client, open "Windows Firewall with Advanced Security", Click "Inbound Rules" and create a new rule to allow connections to port 3050

Add a Comment

(required)  
(optional)
(required)  
Remember Me?
Devlicio.us