firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] may be bug

[<car...@te...>]

HEllo:

> i have problem with named parameters...
> 
> i have parameter @p10 and this parameter make problems... When i rename 
> it to @px its working...
> 
> problem is exception TOKEN UNKNOW line x char y "0"

I´m triying to reproduce this withou result, i have a test case like this :


FbConnection myConnection = new FbConnection(connectionString);

myConnection.Open();

FbTransaction myTransaction = myConnection.BeginTransaction();			
FbCommand myCommand = new FbCommand("select * from TEST_TABLE_01 
where 		INT_FIELD = @p10", myConnection, myTransaction);
	
myCommand.Parameters.Add("@p10", FbType.Integer, "INT_FIELD").Value = 1;

myCommand.Prepare();

myCommand.ExecuteNonQuery();

myDataAdapter.Dispose();
myCommand.Dispose();
myConnection.Close();



It's correct???





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] may be bug

[Pavol S. <pa...@st...>]

hi,

i have problem with named parameters...

i have parameter @p10 and this parameter make problems... When i rename 
it to @px its working...

problem is exception TOKEN UNKNOW line x char y "0"

p.

Re: [Firebird-net-provider] Question on Assembly

[Dick C. <di...@me...>]

Thanks!  That worked!

Dick

Carlos Guzm=E1n =C1lvarez wrote:
> Hello:
>=20
>> I have a newbie question -- I installed the firebird net provider=20
>> using the installer, and I can see the entry in the Global Assembly=20
>> Cache (\winnt\assembly).  I'm just wondering how come when I choose=20
>> the "Add References" option in Visual Studio, Firebird does not appear=
=20
>> in the ..NET tab?  I have to manually choose "Browse" and look for the=
=20
>> DLL.  Am I missing something?
>>
>> I have already tried also doing a drag-and-drop of the DLL to the=20
>> assembly folder, as well as, use the gacutil.exe.  But while I can see=
=20
>> there is a FirebirdSql.Data.Firebird in my assembly folder, it just=20
>> refuses to appear automatically in Visual Studio's Reference dialog.
>=20
>=20
>=20
> See this :
>=20
> http://support.microsoft.com/default.aspx?scid=3Dkb%3Ben-us%3B306149
>=20
>=20

Re: [Firebird-net-provider] Question on Assembly

[<car...@te...>]

Hello:

> I have a newbie question -- I installed the firebird net provider using 
> the installer, and I can see the entry in the Global Assembly Cache 
> (\winnt\assembly).  I'm just wondering how come when I choose the "Add 
> References" option in Visual Studio, Firebird does not appear in the 
> ..NET tab?  I have to manually choose "Browse" and look for the DLL.  Am 
> I missing something?
> 
> I have already tried also doing a drag-and-drop of the DLL to the 
> assembly folder, as well as, use the gacutil.exe.  But while I can see 
> there is a FirebirdSql.Data.Firebird in my assembly folder, it just 
> refuses to appear automatically in Visual Studio's Reference dialog.


See this :

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306149


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] newbie - trying to Get this to work

[Dick C. <di...@me...>]

I don't really do VB, but I believe the import statement below is 
analogous to C#'s "using FirebirdSql.Data.Firebird".  That being the 
case, the answer to your question is 'no'.  Including the namespace does 
not link the DLL.  All it accomplishes is allow you to type 
classes/members/methods in a shorter form without having to fully 
qualify them all the time.  I think the closest analogy with VB is the 
"WITH" statement.  For example, instead of writing:

FirebirdSql.Data.Firebird.FbConnection myConnection = new 
FirebirdSql.Data.Firebird.FbConnection(connectionString);

you can do:

using FirebirdSql.Data.Firebird;

FbConnection myConnection = new FbConnection(connectionString);

Notice that I did not have to fully qualify FbConnection to its formal 
namespace because I included it in the 'using' statement.  But that's 
all it does -- save you typing.  It is not a mechanism to actually 
establish an association in your Assembly file.  To do that, you need to 
setup a reference under the Solutions Explorer.

Dick


Andrew Goodall wrote:
> Isn't that what the import namespace statement does ? 
> I have that included but it still cannot find the classes, such as
> Fbconnection.
> 
> <%@ import Namespace="FirebirdSql.Data.Firebird" %>
> 
> --------------------------------------------------
> 
> 
> In Visual Studio, you would normally include the 
> FirbirdSql.Data.Firebird in the Solutions Explorer's References.  This 
> sorts of binds your application to the DLL.  Maybe you need to do 
> something similar with webmatrix.
> 
> Dick
> 
> 
> 
> Andrew Goodall wrote:
> 
>> 
>>I'm using webmatrix free dev-app to do my developing, with VB on the 
>>codebehind.
>> 
>>The error I receive on loading the webpage .aspx is:  Type 
>>'FbConnection' is not defined
>> 
>>which tells me its not finding the FirebirdSql.Data.Firebird class.
> 

Fw: [Firebird-net-provider] sql inserts and updates not working

[Pavol S. <st...@st...>]

hi,

i think you will do best to put there dispose calls to... There are same
leaks (or something like that) in firebird (may be in provider)

and i found that if you use reader you have to dispose it too...

p.

> Hello:
>
> myConnection.Close() make a Rollback of the transaction,  try with this:
>
> myConnectionString =
>
"Database=C:\\interbase\\Usertasks\\xxx.GDB;User=xxx;Password=xxx;Dialect=3;
Server=xxx"
> myConnection = new FbConnection(myConnectionString)
> myConnection.Open()
>
> Dim UpdateCmd As String
>
> Updatecmd = "UPDATE users SET fname = 'Andrew' WHERE userid = " &
> txtuserid.Value
>
> myTxn = myConnection.BeginTransaction()
>
> MyCommand = New FbCommand(updateCmd, MyConnection, myTxn)
>
> Try
>     MyCommand.ExecuteNonQuery()
>     Message.Style("color") = "Green"
>     Message.InnerHtml = "<b>Account has been updated.</b><br>"
>
>     myTxn.Commit()
       myTxn.Dispose()
       myCommand.Dispose()

>  Catch Exp As FbException
>     Message.Style("color") = "red"
>     Message.InnerHtml = "ERROR: Could not update Account: <br>" &
Exp.Message
>     myConnection.Close()
> End Try
>
> myConnection.Close()
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] sql inserts and updates not working

[Carlos G.A. <car...@te...>]

Hello:

myConnection.Close() make a Rollback of the transaction,  try with this:

myConnectionString = 
"Database=C:\\interbase\\Usertasks\\xxx.GDB;User=xxx;Password=xxx;Dialect=3;Server=xxx"
myConnection = new FbConnection(myConnectionString)
myConnection.Open()
 
Dim UpdateCmd As String
 
Updatecmd = "UPDATE users SET fname = 'Andrew' WHERE userid = " & 
txtuserid.Value
 
myTxn = myConnection.BeginTransaction()
                          
MyCommand = New FbCommand(updateCmd, MyConnection, myTxn)
                 
Try
    MyCommand.ExecuteNonQuery()
    Message.Style("color") = "Green"
    Message.InnerHtml = "<b>Account has been updated.</b><br>"
 
    myTxn.Commit()  
 Catch Exp As FbException
    Message.Style("color") = "red"
    Message.InnerHtml = "ERROR: Could not update Account: <br>" & Exp.Message
    myConnection.Close()   
End Try
    
myConnection.Close()

[Firebird-net-provider] sql inserts and updates not working

[Andrew G. <ag...@jc...>]

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

FW: [Firebird-net-provider] newbie - trying to Get this to work

[Andrew G. <ag...@jc...>]

Even though I had the namspace defind it was still looking for the
reference.
After looking around on google - I found the fix.

1. I updated the web.config file and added:

	<compilation>
	<assemblies>
         <add assembly="FirebirdSql.Data.Firebird, 
                        Version=0.2.1141.24128, 
                        Culture=neutral, 
                        PublicKeyToken=e98daebe910ed179" /> 
       </assemblies>
	</compilation>

This still didn't fix it because now it could not find the dll.

2. Created a bin folder on my webserver root with copied the
FirebirdSql.Data.Firebird.dll into that folder, as this was one of the
folders that .NET was looking for the dll.

Regards,

Andrew Goodall



-----Original Message-----
From: Andrew Goodall [mailto:ag...@jc...] 
Sent: Friday, February 28, 2003 09:08
To: 'Dick Chiang'
Cc: 'fir...@li...'
Subject: RE: [Firebird-net-provider] newbie - trying to Get this to work


Isn't that what the import namespace statement does ? 
I have that included but it still cannot find the classes, such as
Fbconnection.

<%@ import Namespace="FirebirdSql.Data.Firebird" %>

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


In Visual Studio, you would normally include the 
FirbirdSql.Data.Firebird in the Solutions Explorer's References.  This 
sorts of binds your application to the DLL.  Maybe you need to do 
something similar with webmatrix.

Dick



Andrew Goodall wrote:
>  
> I'm using webmatrix free dev-app to do my developing, with VB on the 
> codebehind.
>  
> The error I receive on loading the webpage .aspx is:  Type 
> 'FbConnection' is not defined
>  
> which tells me its not finding the FirebirdSql.Data.Firebird class.

RE: [Firebird-net-provider] newbie - trying to Get this to work

[Andrew G. <ag...@jc...>]

Isn't that what the import namespace statement does ? 
I have that included but it still cannot find the classes, such as
Fbconnection.

<%@ import Namespace="FirebirdSql.Data.Firebird" %>

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


In Visual Studio, you would normally include the 
FirbirdSql.Data.Firebird in the Solutions Explorer's References.  This 
sorts of binds your application to the DLL.  Maybe you need to do 
something similar with webmatrix.

Dick



Andrew Goodall wrote:
>  
> I'm using webmatrix free dev-app to do my developing, with VB on the 
> codebehind.
>  
> The error I receive on loading the webpage .aspx is:  Type 
> 'FbConnection' is not defined
>  
> which tells me its not finding the FirebirdSql.Data.Firebird class.

Re: [Firebird-net-provider] newbie - trying to Get this to work

[Dick C. <di...@me...>]

Andrew Goodall wrote:
>  
> I'm using webmatrix free dev-app to do my developing, with VB on the 
> codebehind.
>  
> The error I receive on loading the webpage .aspx is:  Type 
> 'FbConnection' is not defined
>  
> which tells me its not finding the FirebirdSql.Data.Firebird class.


In Visual Studio, you would normally include the 
FirbirdSql.Data.Firebird in the Solutions Explorer's References.  This 
sorts of binds your application to the DLL.  Maybe you need to do 
something similar with webmatrix.

Dick

[Firebird-net-provider] newbie - trying to Get this to work

[Andrew G. <ag...@jc...>]

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

[Firebird-net-provider] debugger and list

[Pavol S. <st...@ra...>]

hi,

you can find debugger in Net framework directory and in GuiDebug...
on my computer it is
c:\program files\microsoft.net\sdk\v1.1\guidebug\dbgclr.exe

i don know if it is in v1.0 framework...

to my problem with mailing list... i checked that i want to recive messages
in daily digest...

Now im subscribed two times so i hope that i will recive all messages too...

p.

Re: [Firebird-net-provider] debugger

[Carlos G. A. <car...@te...>]

Hello:

> I am sorry if this is getting offtopic but does the free 1.0 SDK contain the
> visual debugger?


No problem, see this :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/netstart/html/vcoriTheCOM20SDKDebugger.asp





Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] debugger

[Christoph D. <cd...@ar...>]

I am sorry if this is getting offtopic but does the free 1.0 SDK contain the
visual debugger?


Christoph

----- Original Message -----
From: "Carlos Guzman Alvarez" <car...@te...>
To: "Pavol Starek" <pa...@st...>
Cc: <fir...@li...>
Sent: Wednesday, February 26, 2003 10:44 PM
Subject: Re: [Firebird-net-provider] debugger


> ello:
>
> > i was just looking for debugger. And i found... You dont need use
> > command line debugger becouse there is DbgCLR.exe in SDK1.1\GuiDebug...
> > Its fully featured debugger... Try it and you will not need VS.NET :-)
>
>
> Hummm ... really good :)
>
>
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Scholarships for Techies!
> Can't afford IT training? All 2003 ictp students receive scholarships.
> Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more.
> www.ictp.com/training/sourceforge.asp
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] debugger

[Carlos G. A. <car...@te...>]

ello:

> i was just looking for debugger. And i found... You dont need use 
> command line debugger becouse there is DbgCLR.exe in SDK1.1\GuiDebug... 
> Its fully featured debugger... Try it and you will not need VS.NET :-)


Hummm ... really good :)




Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] asp.net

[Carlos G. A. <car...@te...>]

Hello:


> Thanks so much for your help, I didn't realize that your source file had
> examples and only had the help file to work with so I was a bit lost. At any
> rate, your samples set me right and I have a working model and as promised
> I'm including the sample code. We plan on using your product for all our
> asp.net development with Delphi.

:) Thanks very much.



Best regards
Carlos Guzma'n A'lvarez
Vigo-Spain





<%@ Page Language="delphi" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="FirebirdSql.Data.Firebird" %>
<script runat="server">

          const
             ProdName = 'Delphi for .NET';
             DispFields = 'OrderID, CustomerID, ShipName, ShipCity,
ShipCountry';

          procedure DateSelected(Sender: System.Object; E: EventArgs);
          begin
             Label1.Text := ProdName + ' says you picked ' +
Calendar1.SelectedDate.ToString('D');
             DataGrid1.DataSource := GetOrders(Calendar1.SelectedDate);
             DataGrid1.DataBind;
          end;

          procedure Button1Click(Sender: System.Object; E:EventArgs);
          begin
             Calendar1.VisibleDate := System.Convert.ToDateTime(Edit1.Text);
             Label1.Text := ProdName + ' says you set ' +
Calendar1.VisibleDate.ToString('D');
          end;

          procedure Button2Click(Sender: System.Object; E:EventArgs);
          begin
             DisplayFields.Text := DispFields;
          end;

          function GetOrders(Date : DateTime) : DataSet;
          var
             Adapter : FbDataAdapter ;
             command: FbCommand;
             connection: FBConnection;
             transaction: FBTransaction;
             ds: DataSet;
             MyConnectionString:string;
             builder:FbCommandBuilder;

           begin

                MyConnectionString :=
'Database=d:\projects\data\disdat.GDB;User=SYSDBA;Password=masterkey;Dialect
=1;Server=localhost';
                connection:=FBConnection.create(MyConnectionString);
                connection.open;
                transaction:=Connection.BeginTransaction;
                command := FbCommand.create('select * from code', 
connection,
transaction);
                adapter := FbDataAdapter.create(command);
                builder := FbCommandBuilder.create(adapter);
                Result := DataSet.Create;
                adapter.Fill(Result, 'code');
                label2.text:='Adap fill';
                transaction.commit;
                connection.close;
                command.free;
                adapter.free;
                builder.free;



          end;

</script>
<html>
<head>
</head>
<body style="FONT: 18pt Verdana">
     <form runat="server">
         <h1><%=ProdName %>with a Calendar, DataGrid, &amp; SqlClient in
ASP.NET
         </h1>
         <table>
             <tbody>
                 <tr valign="top">
                     <td>
                         <p>
                             <b>Pick a date</b>
                         </p>
                         <asp:Calendar id="Calendar1" runat="server"
ForeColor="#0000FF" BackColor="#FFFFCC" OnSelectionChanged="DateSelected">
                             <TodayDayStyle font-bold="True" />
                             <NextPrevStyle forecolor="#FFFFCC" />
                             <DayHeaderStyle backcolor="#FFCC66" />
                             <SelectedDayStyle forecolor="Black"
backcolor="#CCCCFF" />
                             <TitleStyle font-size="14pt" font-bold="True"
forecolor="#FFFFCC" backcolor="#990000" />
                             <OtherMonthDayStyle forecolor="#CC9966" />
                         </asp:Calendar>
                         <p>
                             <asp:TextBox id="Edit1" runat="server"
width="150"></asp:TextBox>
                             <asp:Button id="Button1" onclick="DateSelected"
runat="server" text="Set date"></asp:Button>
                         </p>
                     </td>
                     <td valign="top">
                         <p>
                             <b>Display fields:</b>
                             <asp:TextBox id="DisplayFields" runat="server"
width="500" text="OrderID, CustomerID, ShipName, ShipCity,
ShipCountry"></asp:TextBox>
                             <asp:Button id="Button2" onclick="Button2Click"
runat="server" text="Reset fields"></asp:Button>
                             <asp:Button id="Button3" onclick="DateSelected"
runat="server" Text="Button"></asp:Button>
                         </p>
                         <p>
                             <a
href="http://localhost/scripts/dategrid.aspx">http://localhost/scripts/dateg
rid.aspx</a>
                         </p>
                         <asp:DataGrid id="DataGrid1" runat="server"
ForeColor="#0000FF" BorderColor="#FFCC66">
                             <HeaderStyle forecolor="#FFFFCC"
backcolor="#990000" />
                         </asp:DataGrid>
                     </td>
                 </tr>
             </tbody>
         </table>
         <p>
             <asp:Label id="Label1" runat="server"></asp:Label>
         </p>
         <p>
             <asp:Label id="Label2" runat="server"></asp:Label>
         </p>
     </form>
     The data connectivity
</body>
</html>

Re: [Firebird-net-provider] debugger

[Carlos G. A. <car...@te...>]

Hello:

> im not using any debugger :( Yes that is problem and sometimes tricky to 
> work without debuger, but im using TRACE and DEBUG listeners... Its 
> working for me and in conjunction with nunit (testing environment) its 
> fine...


Using a logger class can help too :)




Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] mailing list

[Carlos G. A. <car...@te...>]

Hello:


> hi,
>  
> i have one question:
> why i recive only messages for my self and not posts addressed to others 
> people in this list??? im allways suprised, when i read FB-N-P digest... 
> I want to recive all posts :-) I want to know everything what happend 
> around net provider :-)


Are you suscribed to the list ??  :) , i think yes, but it's the only 
thing that can happen for not to receive all messages, if are not 
suscribed see here :

http://lists.sourceforge.net/lists/listinfo/firebird-net-provider





Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] debugger

[Christoph D. <cd...@ar...>]

How does that work?  Do you have any screenshots or know where any are?


Christoph
  ----- Original Message -----=20
  From: Pavol Starek=20
  To: fir...@li...=20
  Sent: Wednesday, February 26, 2003 10:38 AM
  Subject: [Firebird-net-provider] debugger


  hi,

  i was just looking for debugger. And i found... You dont need use =
command line debugger becouse there is DbgCLR.exe in SDK1.1\GuiDebug... =
Its fully featured debugger... Try it and you will not need VS.NET :-)

  p.

[Firebird-net-provider] debugger

[Pavol S. <st...@ra...>]

hi,

i was just looking for debugger. And i found... You dont need use =
command line debugger becouse there is DbgCLR.exe in SDK1.1\GuiDebug... =
Its fully featured debugger... Try it and you will not need VS.NET :-)

p.

[Firebird-net-provider] mailing list

[Pavol S. <st...@ra...>]

hi,

i have one question:
why i recive only messages for my self and not posts addressed to others =
people in this list??? im allways suprised, when i read FB-N-P digest... =
I want to recive all posts :-) I want to know everything what happend =
around net provider :-)

p.

[Firebird-net-provider] debugger

[Pavol S. <st...@st...>]

hi,

im not using any debugger :( Yes that is problem and sometimes tricky to =
work without debuger, but im using TRACE and DEBUG listeners... Its =
working for me and in conjunction with nunit (testing environment) its =
fine...

Anyway you have to write code for this little different way as you have =
debugger.

simple split everything to smallest routines (functions), debug them and =
never come back to them... You need to make analyse before coding, not =
code and then think whats wrong :-)

Anyway i dont have money to buy NET studio (it cost 5 month wages :) so =
i have no choice...

p.

Re: [Firebird-net-provider] using assembly

[Alan Q. <al...@pi...>]

How?

"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:3E5...@te......
> Hello:
>
> > i dont know how to use assembly in VS,
>
>
> You can add Firebird .Net Provider components to the VS Toolbox too.
>
>
>
>
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Re: VS

[Christoph D. <cd...@ar...>]

Do you use the command line debugger?

The lack of an integrated debugger in SharpDevelop is the only reason I am
still using VS.NET.


Christoph

----- Original Message -----
From: "Carlos Guzman Alvarez" <car...@te...>
To: "Pavol STAREK" <pa...@st...>
Cc: <fir...@li...>
Sent: Tuesday, February 25, 2003 10:36 PM
Subject: [Firebird-net-provider] Re: VS


> Hello:
>
> > anyway i use sharpdevelop... Its free and great..
>
> Yes :D
>
>
>
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>