Dotnet Connection with FireBird Database

Hi Friends,

          Lets me explain how to connect to FireBird database using .Net. To connect FireBird database using please follows the following steps:

      1. First check is Firebird installed in local or server? If no install Firebird 2.0
      2. Download Firebird .Net Dataprovider dll from http://prdownloads.sourceforge.net/firebird/FirebirdClient-2.0.1.exe?download
      3. In your project add reference of this dll.
      4. Import namespace using FirebirdSql.Data.Firebird; in your project.
      5. Please add the following code in your web.config file.

<add key=”connectionstring” value=”Driver={ODBC Driver (*.fdb)}; Database=localhost:C:\test1.fdb;Uid=SYSDBA;DataSource=localhost; Password=masterkey;”/>

6.    Write the following code in your codebehind file to check.

FbConnection fbConn = new FbConnection(ConfigurationManager.AppSettings[“connectionstring”].ToString());

fbConn.Open();

Response.Write(fbConn.State.ToString());

Hope this will help you…..

I am thankful to my one friend for explaining such good thing.

Advertisements

About Vijay Modi

Having 12+ years of experience in web application development. Expertise in various domains like E-Commerce, E-Learning, Insurance. I have expertise in web application development, window application development, Performance improvement, bug fixing etc. I am believing in quality work and achieving deadlines. Also like to work on new technologies and quick learner.
This entry was posted in Uncategorized and tagged . Bookmark the permalink.

3 Responses to Dotnet Connection with FireBird Database

  1. James says:

    How to Connect Asp.Net With Oracle Database …

    James (Chennai)

  2. Ashok Kumar says:

    Thanks a lot.This is very use full for me.

  3. Elis says:

    where I put this part??????????????????????????????????????

    6. Write the following code in your codebehind file to check.

    FbConnection fbConn = new FbConnection(ConfigurationManager.AppSettings[“connectionstring”].ToString());

    fbConn.Open();

    Response.Write(fbConn.State.ToString());

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s