VC# Express 2010 and Firebird 2.5

Dev Shed Forums Sponsor:

August 18th, 2011, 11:18 AM

HBB_BA

Registered User

Join Date: Aug 2011

Posts: 2

Time spent in forums: 29 m 11 sec
Reputation 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

--------------------------------------------------------------------------------

August 19th, 2011, 02:56 AM

Talbotty

Registered User

Join Date: Aug 2011

Posts: 4

Time spent in forums: 1 h 3 m 15 sec
Reputation 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.

August 19th, 2011, 04:29 PM

HBB_BA

Registered User

Join Date: Aug 2011

Posts: 2

Time spent in forums: 29 m 11 sec
Reputation 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

September 14th, 2011, 08:36 PM

thegaffney

Contributing User

Join Date: Sep 2010

Posts: 52

Time spent in forums: 20 h 38 m 7 sec
Reputation Power: 3

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);
        }

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > VC# Express 2010 and Firebird 2.5

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump