Instead of SqlConnection, and SqlCommand use FbConnection and FbCommand,
which are Firebird specific variants.
If you add the following to your uses clauses:
using FirebirdSql.Data.FirebirdClient;
Try replacing the SqlConnection and SqlCommand lines with these:
FbConnection conn = new
FbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
FbCommand cmd = new FbCommand("ADD_EMP_PROJ", conn);
Kind regards
Scott :)
On 31/10/2011 19:26, Net Newbie wrote:
> thank you very much for this link.
> I am having some small problems in getting the connection to work.
> Instead of hard coding it to every ASP.NET WebForm I am looking for a
> way to use it from Web.config
> I tried this way but I think I am lacking provider as this gives me
> error "Keyword not supported: dialect.", how to add here Firebird provider?
> in web.config it is defined as following<add name="ConnectionString"
> connectionString="dialect=3;port=3050;data source=localhost;initial
> catalog="C:\Program
> Files\Firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB";user
> id=sysdba;password=masterkey"
> providerName="FirebirdSql.Data.FirebirdClient" />
>
>
> SqlConnection conn = new
> SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
> SqlCommand cmd = new SqlCommand("ADD_EMP_PROJ", conn);
> cmd.CommandType = CommandType.StoredProcedure;
>
> cmd.Parameters.Add("@emp_no", SqlDbType.Int);
> cmd.Parameters["@emp_no"].Value = 2;
>
> cmd.Parameters.Add("@proj_id", SqlDbType.Text);
> cmd.Parameters["@proj_id"].Value = "DGPII";
>
> try
> {
> //open connection
> conn.Open();
> cmd.ExecuteNonQuery();
> conn.Close();
> }
> catch (Exception ex)
> {
> //handle error
> throw (ex);
> }
>
>
> I am sorry to ask so basic questions but I am new to .NET and Firebird
> .NET provider usage could also be better documented and could come with
> samples.
>
> thanks.
>
>
> On 31.10.2011 8:07, Gerdus van Zyl wrote:
>> http://blog.cincura.net/227021-firebird-net-provider-and-calling-stored-procedures-with-parameters/
>>
>> and
>>
>> http://www.lmgtfy.com/?q=stored+procedure+ado.net+firebird
>>
>> On Mon, Oct 31, 2011 at 7:54 AM, Alexander Muylaert
>> <amuylaert_gel...@hotmail.com> wrote:
>>> http://www.amazon.com/ADO-Programming-Dummies-CD-ROM-Krumm/dp/0764507478
>>>
>>> -----Oorspronkelijk bericht-----
>>> Van: Net Developer [mailto:netfireb...@gmail.com]
>>> Verzonden: zondag 30 oktober 2011 23:41
>>> Aan: firebird-net-provider@lists.sourceforge.net
>>> Onderwerp: [Firebird-net-provider] Executing Firebird stored procedure from
>>> ASP.NET
>>>
>>> How to execute a Firebird stored procedure from ASP.NET application?
>>> I have VS2010. Sucessfully can over SQLDataSource connect and do queries.
>>>
>>> please provide a code sample.
>>> thanks.
>>>
>>>
>>>
>
> ------------------------------------------------------------------------------
> Get your Android app more play: Bring it to the BlackBerry PlayBook
> in minutes. BlackBerry App World™ now supports Android™ Apps
> for the BlackBerry® PlayBook™. Discover just how easy and simple
> it is! http://p.sf.net/sfu/android-dev2dev
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
------------------------------------------------------------------------------
Get your Android app more play: Bring it to the BlackBerry PlayBook
in minutes. BlackBerry App World™ now supports Android™ Apps
for the BlackBerry® PlayBook™. Discover just how easy and simple
it is! http://p.sf.net/sfu/android-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
