#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    2
    Rep Power
    0

    VC# Express 2010 and Firebird 2.5


    Hello,

    I am learning C#. I use Firebird assembly FirebirdSql.Data.FirebirdClient.dll with its classes programatically, get a DataDeader and access records with no problem. Reference to the Firebird assembly is set up and works fine. Records are fetched and displayed normally.

    Now, I want to used typed DataSets:
    When I go to Database Explorer > Right Click > Add Connection the dialog "Add Data Source" appears with 3 options:

    1. MS Access Db File, 2. MS Sql Server 3.5, 3. MS Sql Serve Database file

    In DataProvider Box it only appears "Net Framework Provider for OleDB"

    Firebird asembly seems not registered.

    Is a restricton in MS VC# Express ?

    I am missing any config settings to work with Firebird assemblies ?

    Thanks for your time and best regards,
    Horacio


    --------------------------------------------------------------------------------
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    4
    Rep Power
    0
    I tried for a while to get this to work too. Unfortunately the Firebird Data Source only works in the full version of VS2010. I believe this is a Microsoft restriction and not Firebird's fault.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    2
    Rep Power
    0
    Thanks very much for your answer.
    I guess also is a MS restriction.

    I will try other options,
    Have a nice week end.
    Horacio
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2010
    Posts
    52
    Rep Power
    4
    On my app i just use datareader and nonsqlquery, but the code im using has a function for a dataset, ive never tried it though.

    Here is the code in case you haven't come across it yet

    conn and Openconn() will have to be defined of coarse.

    hope it might help?

    Code:
    public DataSet returnDataSet(string txtQuery)
            {
                Openconn();
                sqlCommand = conn.CreateCommand();
                DB = new FbDataAdapter(txtQuery, conn);
                DS.Reset();
                try
                {
                    DB.Fill(DS);
                }
                catch (Exception e)
                {
                    showDbError(e.Message.ToString());
                }
                conn.Close();
                return (DS);
            }

IMN logo majestic logo threadwatch logo seochat tools logo