[Firebird-net-provider] Problems with the 2.0 beta4 version

2006-03-16 Thread Fabio Gomes
Hi, I m new to .net and everything and i got some trouble with this version.It just doesnt connect, it says "Unable to complete network request to host 192.168.15.101"But it also refuses the connection in a local server.I googled for it and several people have the same problemI m using it with C#

Re: [Firebird-net-provider] Problems with the 2.0 beta4 version

2006-03-17 Thread Fabio Gomes
Yes, i tried that and it connects. But the thing is: I uninstalled the 2.0 beta4 and installed the 1.7 version and it worked in the first try without changing anything on the code, so the problem isnt my connection. Currently i m with the 1.7 version and its working just fine. On 3/17/06, Carlo

Re: [Firebird-net-provider] Problems with the 2.0 beta4 version

2006-03-17 Thread Fabio Gomes
ok, here we go:Here is the exception:FirebirdSql.Data.FirebirdClient.FbException: Unable to complete network request to host "192.168.15.101 ". ---> FirebirdSql.Data.Common.IscException: Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.   at FirebirdSql.Data.Client.Gds.GdsConnect

Re: [Firebird-net-provider] Problems with the 2.0 beta4 version

2006-03-17 Thread Fabio Gomes
No, this error is without sockets.But, do i NEED a socket to use this version of the provider?Why does the 1.7 works without sockets then?On 3/17/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:> FirebirdSql.Data.FirebirdClient.FbException: Unable to complete> network request to host "1

[Firebird-net-provider] Mono and firebird on windows.

2006-04-03 Thread Fabio Gomes
Hi all.I m new to C# and all this .NET stuff. But i m trying to at least learn and start developing with C# and firebird, firebird 1.7 is working fine on Visual Studio, but i tried to use mono and got not luck. I tried mono with sharpdevelop, it installs and try to compile.. a simple "hello world"

Re: [Firebird-net-provider] Mono and firebird on windows.

2006-04-03 Thread Fabio Gomes
Hum.. where can i find info about how to build it? i just downloaded the installer and installed it.On 4/3/06, Carlos Guzmán Álvarez < [EMAIL PROTECTED]> wrote:Hello:> The same code compiles and run fine if i just switch the compiler from > mono to .NET.>> Am i m making something wrong? could you g

Re: [Firebird-net-provider] Mono and firebird on windows.

2006-04-03 Thread Fabio Gomes
Thanx.So i need to compile the version 1.7 of the provider?"Version 2.0 of the provider targets only the .NET Framework 2.0 and the .NET Compact Framework 2.0"Or is it going to compile on mono too?Sorry if its a stupid question, but i m really new to this .NET stuff :(On 4/3/06, Carlos Guzmán Álv

Re: [Firebird-net-provider] Mono and firebird on windows.

2006-04-03 Thread Fabio Gomes
I was able to compile the 1.7 data provider.But how do i install it now so i can use it on mono and sharpdevelop?It created a net 1.1 folder with a release folder inside of it and some files... where should i put those files? On 4/3/06, Fabio Gomes <[EMAIL PROTECTED]> wrote: Thanx.So i n

Re: [Firebird-net-provider] Mono and firebird on windows.

2006-04-03 Thread Fabio Gomes
I found the option to browse the assembly and the code i posted earlier now compiled with mono!Thanx a lot!Now i just need to test it all on linux :)On 4/3/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:> I was able to compile the 1.7 data provider.>> But how do i install it now so i c

[Firebird-net-provider] Helping inserting data on a firebird database using C#.

2006-04-07 Thread Fabio Gomes
Hi guys, sorry about bothering you with my newbie questions again, but i cant find why this thing isnt working, and also i need some advice if what i m doing is correct or not.i m getting this error when trying to execute a Insert Command on my database: System.NullReferenceException: Object refere

Re: [Firebird-net-provider] Helping inserting data on a firebird database using C#.

2006-04-07 Thread Fabio Gomes
Ok, i tried to change to this:                da_cli.InsertCommand = con.CreateCommand();                // DADOS:                   da_cli.InsertCommand.CommandText = "INSERT INTO CLIENTES (CLI_COD,CLI_NOME, CLI_SOBRENOME) VALUES(@cli_cod,@cli_nome,@cli_sobrenome)";                    da_cli.Inser

[Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
Hi, thats me again :)Now i m trying to delete a record using this: int codigo=int.Parse(this.txtCli_cod.Text);                 if (dr ==DialogResult.Yes){                         try {                                 da_cli.DeleteCommand = con.CreateCommand();                                

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
Sorry.. what do mean changes before the update?The weird thing is that i dont have any errors, but it doesnt delete either :(On 4/11/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:>> int codigo=int.Parse(this.txtCli_cod.Text);> if (dr ==DialogResult.Yes){>  

[Firebird-net-provider] Firebird and .NET (C# and ADO.NET) books

2006-04-11 Thread Fabio Gomes
Is there any books about using firebird with C#?Cause i cant find good tutorials and info on the internet, and i m having a lot of troubles with firebird here as you may have already noticed.So if there is any books out there about it, please send me the link, i ll make my boss buy it :) thanx for

Re: [Firebird-net-provider] Firebird and .NET (C# and ADO.NET) books

2006-04-11 Thread Fabio Gomes
AIL PROTECTED]> wrote: I hope help you with : http://www.dotnetfirebird.org/ It's a good site about firebird and .net Bye On 4/11/06, Fabio Gomes <[EMAIL PROTECTED] > wrote: Is there any books about using firebird with C#?Cause i cant find good tutorials and info on the internet, and

Re: [Firebird-net-provider] Firebird and .NET (C# and ADO.NET) books

2006-04-11 Thread Fabio Gomes
005 Step by Step" book. I think it's a great book and with a Delphi background (many years) makes it easier. Cheers, Kevin     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Fabio Gomes Sent: Tuesday, April 11, 2006 6:53 AM To: firebird-net-provider@lists.sou

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
No, o didnt do that.I think that this is the problem then.I try to read about it, i m completely lost on this stuff.Thanx :)On 4/11/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:> Sorry.. what do mean changes before the update?Check if ds_cli.HasChanges is true if not the dataadapter

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
PrimaryKey value to the dataTable?Thanx again, and sorry for the lots of questions :(On 4/11/06, Fabio Gomes <[EMAIL PROTECTED]> wrote: No, o didnt do that.I think that this is the problem then.I try to read about it, i m completely lost on this stuff.Thanx :) On 4/11/06, Carlos Guzmán Álvarez &

[Firebird-net-provider] Getting a single value from the database in C#

2006-04-27 Thread Fabio Gomes
Hi guys, i m trying to do a very simple thing here but i cant find a simple way to do this.I m doing a login window, and i want to just make a select like this:SELECT ID FROM TABLE WHERE USERNAME='USERNAME' This seens very simple, my query is ok, but what i m missing, is a simple method to know if

Re: [Firebird-net-provider] Getting a single value from the database in C#

2006-04-27 Thread Fabio Gomes
I tried it, and it says it cant convert and object and blá blá blá...How can i convert it to an int value so i can check if it returned true or false?Thanx for the quick reply. On 4/27/06, Oleg Deribas <[EMAIL PROTECTED]> wrote: Hello,Fabio Gomes said the following on 27.04.2006 20:44:>

Re: [Firebird-net-provider] Getting a single value from the database in C#

2006-04-27 Thread Fabio Gomes
ror says: Error    1    Cannot implicitly convert type 'object' to 'int'. An explicit conversion exists (are you missing a cast?)  Thanx.On 4/27/06, Jiri Cincura <[EMAIL PROTECTED]> wrote: On 27.4.2006 19:57 Fabio Gomes wrote:> I tried it, and it says it cant convert and

Re: [Firebird-net-provider] Getting a single value from the database in C#

2006-04-27 Thread Fabio Gomes
nt i = (int) cmd.ExecuteScalar();    } catch (Exception ex) {    MessageBox.Show(ex.ToString());    } On 4/27/06, Jiri Cincura <[EMAIL PROTECTED]> wrote: On 27.4.2006 20:18 Fabio Gomes wrote:> int i = cmd.ExecuteScalar();Simpliest way: int i = (int

Re: [Firebird-net-provider] Getting a single value from the database in C#

2006-04-27 Thread Fabio Gomes
NTES(etc etc)That way ExecuteScalar() will return 0 if there are no rows, or >0 if therewere rows.  You won't have to check for NULL's that way. Robert- Original Message -From: "Fabio Gomes" <[EMAIL PROTECTED]>To: < firebird-net-provider@lists.sourceforge.n

Re: [Firebird-net-provider] Getting a single value from the database in C#

2006-04-28 Thread Fabio Gomes
Thanx guys, this code now worked:I dont know why it wasnt workings yesterday, i didnt changed much in the code, but now its working as i expected, thanx for your time and patience :)    FbCommand cmd = new FbCommand("SELECT CLI_COD FROM CLIENTES WHERE CLI_NOME='" + txtUsuario.Text.ToString

[Firebird-net-provider] Why my update command never works?

2006-05-02 Thread Fabio Gomes
I m trying to do make a simple UPDATE using this:this.BindingContext[ds.Tables[0]].EndCurrentEdit();da.Update(ds.Tables[0]);My BindingContext is working fine and i can navigate trough the records, but when i try to update my data into the database nothing happens! This is my code:    try { 

[Firebird-net-provider] Re: Why my update command never works?

2006-05-02 Thread Fabio Gomes
(ex.ToString());    }    If i take off the first line, with the txtAtual.focus(), my updated doesnt work, simply chaging the focus to this text box (that doesnt have any DataBindings) all the updates work. Anyone knows why this can be happening?thanx in advance.On 5/2/06, Fabio Gomes <[EM

[Firebird-net-provider] Weird behavior, i cant figure out why

2006-05-05 Thread Fabio Gomes
Hey guys, i dont know if it can be a firebird problem or if am i doing something wrong, but i cant find help anywhere.The problem is the following.I m making an application and using data bindings to bind my data to several textboxes, i can navigate through the records without problems, everything

Re: [Firebird-net-provider] Weird behavior, i cant figure out why

2006-05-05 Thread Fabio Gomes
Man, i love you :)It was this simple, cant belive how dumb i am omg It solved my problems, thanx a lot.On 5/5/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:Hello: > this.cmdUpdate.CommandText = "UPDATE CLIENTES SET> CLI_NOME=?, CLI_SOBRENOME=?, VED_COD=? WHERE CLI_COD = ?";> 

[Firebird-net-provider] Small date problem when binding to a textbox

2006-05-16 Thread Fabio Gomes
Hi guys, i m with a small problem here and i dont know if it has something to do with the firebird provider, but i hope you can help me out.I used a maskedtextbox and used databindings to bind it to a data field on my DB. It is working, here in brazil we use the dd/mm/ date format, and if i typ

Re: [Firebird-net-provider] Small date problem when binding to a textbox

2006-05-16 Thread Fabio Gomes
it shows like this:24/7/1984 00:00:00Withou the 0 (zero) too, the same as it shows on the maskedtext box.Is there any way to fix it?On 5/16/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:> But when i need to show the data on the maskedtextbox, the data> appears like this:>> 24/71/984>>

Re: [Firebird-net-provider] Small date problem when binding to a textbox

2006-05-17 Thread Fabio Gomes
Thanx, i solved it using a custom made maskedtextbox, its weird that the normal textbox takes off the zeros :(On 5/17/06, Carlos Guzmán Álvarez < [EMAIL PROTECTED]> wrote:Hello:> it shows like this:>> 24/7/1984 00:00:00 >> Withou the 0 (zero) too, the same as it shows on the maskedtext box.>> Is th

[Firebird-net-provider] Can connect using the server name, but cant with the ip, why?

2006-05-22 Thread Fabio Gomes
I tried some time ago to use the 2.0 version of the .net provider but i couldnt connect to my database (linux server), then i tried it at home and connect perfectly using "localhost", today i decided to try it here at work, and it didnt work using the ip, then i just changed the ip to the server na

[Firebird-net-provider] Connection String Builder Problem

2006-05-29 Thread Fabio Gomes
Hi,I m trying to using a connection string builder but it isnt working, when i use:csb.ToString() or csb.ConnectionStringit outputs:user id=SYSDBA;password=masterkey;initial catalog=LINUX;character set=ISO8859_1;server type=Default If i try to connect it gives me an error saying that the string is

[Firebird-net-provider] Problems with Date Field

2006-06-26 Thread Fabio Gomes
Hi guys, I ve been using the Firebird Provider 2.0 Since the beta release and never had problems with it, but i was having some problems with some Dates and was blaming my TextBox for it, but after trying a lot of stuff to fix the problem i m not sure if the problem is the TextBox, some Binding st

Re: [Firebird-net-provider] Problems with Date Field

2006-06-27 Thread Fabio Gomes
Carlos, The weird thing is that in my DataSet the Date is correct, but it is always showing 2006 on the TextBox, even when i open the form for the first time it shows 2006 in all my Date TextBoxes. I ll try to make a test case and send it to you, cause my actual project is kinda big. thanx, -Fá

Re: [Firebird-net-provider] Problems with Date Field

2006-06-28 Thread Fabio Gomes
Carlos, Thanx for your help, but I solved the problem, the problem was the windows regional configuration, the Date format was set to d/M/yy, after setting it to: dd/MM/ it worked just fine. I never had to do it before so i didnt think about it, but now everything is working fine, and again t

[Firebird-net-provider] Using the 2.0 Provider on Mono

2006-06-30 Thread Fabio Gomes
I m thinking about starting to play with mono, and i would like to know if i can use the 2.0 provider on mono.Thanx. Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Applica

Re: [Firebird-net-provider] Using the 2.0 Provider on Mono

2006-06-30 Thread Fabio Gomes
Nice, but i forgot to say that i ll be using linux, will i have to compile the provider on linux?On 6/30/06, Le roy Arnaud < [EMAIL PROTECTED]> wrote:> I m thinking about starting to play with mono, and i would like to know if i > can use the 2.0 provider on mono.>> Thanx.normally  yes !Using Tomca

Re: [Firebird-net-provider] Using the 2.0 Provider on Mono

2006-07-04 Thread Fabio Gomes
So, keeping it short, its better i just use Firebird 1.7 for now? Can i have bot 1.7 and 2.0 installed together? on windows i mean, cause i ll use sharpdevelop for mono stuff...On 7/3/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:> I've read that 1.1.13.8 considered as stable version

[Firebird-net-provider] Size on FbParameters

2006-07-06 Thread Fabio Gomes
Hi guys, this is not a problem in the provider or something like it, but i m with a little doubt stuck in my head and i cant find info about, i m learning C# and ADO.NET by myself, i think that this is stupid but My question is about field size in the parametes, especially in numeric types and

Re: [Firebird-net-provider] Size on FbParameters

2006-07-06 Thread Fabio Gomes
Hum... Does the provider autodetect the size? what if i send some data that is bigger than the field size? And can i take off the Value too? On 7/6/06, Jiri Cincura <[EMAIL PROTECTED]> wrote: > Well, you can use (simplified) syntax, to omit the size parameter. > command.Parameters.Add("@id", FbD

Re: [Firebird-net-provider] Size on FbParameters

2006-07-06 Thread Fabio Gomes
AIL PROTECTED]> wrote: > On 6.7.2006 18:07 Fabio Gomes wrote: > > Hum... > > > > Does the provider autodetect the size? what if i send some data that > > Yes. > > > is bigger than the field size? > > Exception is thrown. > > > And can i take

[Firebird-net-provider] Executing Stored Procedures, why this isnt working?

2006-07-20 Thread Fabio Gomes
Hi guys, i m tying to learn how to work with stored procedures, but i cant make it work.In every single tutorial i found on the internet i said this:cmd.CommandText =  "StoredProcedureName"; but in my case it didnt work, it just workes when i use:cmd.CommandText = "EXECUTE PROCEDURE StoredProcedure

Re: [Firebird-net-provider] Executing Stored Procedures,

2006-07-20 Thread Fabio Gomes
I m adding it to the code, but it doesnt work, here all my code:  public static bool ExecutarProcedure(string sql, List Parameters, IDbConnection cn, IDbTransaction tr)  {  FbConnection _cn = (FbConnection)cn;   FbTransaction _tr = (FbTransaction)tr;  FbCommand cmd =

Re: [Firebird-net-provider] Executing Stored Procedures,

2006-07-20 Thread Fabio Gomes
The problem is that i dont get an Exception, anyway, now it worked.The Parameters names in my procedure was:INCID_COD, IN_CID_NOMEit wasnt working, so i used "@CID_COD" in my parameters (CID_COD is actually the name of my DataBase collumn). Was this the problem? should i name the parameters after t

Re: [Firebird-net-provider] Executing Stored Procedures,

2006-07-20 Thread Fabio Gomes
Sorry, i forgot to mention that it worked with this: cmd.Parameters.AddWithValue("@CID_COD" , value); CID_COD is the name of my Column in the Table, but my variable in the stored procedure is named INCID_COD, and i was passing the Parameter as "INCID_COD". So, do i need to name the parameter wit

Re: [Firebird-net-provider] Executing Stored Procedures,

2006-07-20 Thread Fabio Gomes
ECTED] ] On Behalf Of Fabio Gomes Sent: Thursday, July 20, 2006 8:13 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Executing Stored Procedures,   I m adding it to the code, but it doesnt work, here all my code:   public static bool Exe

Re: [Firebird-net-provider] Executing Stored Procedures,

2006-07-20 Thread Fabio Gomes
Oh.. so that was the problem, the "@"Thanx, and sorry for my "newbieness" :)-Fábio.On 7/20/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:Hello: > Yes, i am.>> But, is the "@" anything to do with the parameter?It's the way the provider can identify parameter names in the sqlcommand ( firebird

Re: [Firebird-net-provider] Firebird with C#

2006-08-21 Thread Fabio Gomes
Could you be more specific? what exactly do you need? Did you take a look at this site? http://www.dotnetfirebird.org/ On 8/21/06, Raimundo Morais <[EMAIL PROTECTED]> wrote: > Good day, former programmer delphi in Brazil, needs aid to connect to > firebird 1.5.x in c#. > > >

Re: [Firebird-net-provider] Using the 2.0 Provider on Mono

2006-11-10 Thread Fabio Gomes
I tested the binary provider in the mono 1.2 today and it worked on the first try :) Its sad that is doesnt come in the package :( On 11/10/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: > Hello: > > Mono 1.2 finally was released, and it seems it doesn't include provider > > 2.0. And provid

Re: [Firebird-net-provider] Output parameter values may not match its names

2006-12-11 Thread Fabio Gomes
I don´t like the way it is too, but its not a real big deal, sometimes i have to do some workarounds in my code so the parameters match the order, but i ve been working with the firebird provider for a long time and got used to it, but matching the parameters by name would make my life easier somet

[Firebird-net-provider] Connection timeout Problems

2007-01-23 Thread Fabio Gomes
tput window "a first chance of Firebirsql.SystemException ocurred in FirebirdSql.dll Is there something wrong with my connection string? How can i find out the root of the problem? and why it just happens after 10 minutes or more after i start my software? thanx in advance for an