[Firebird-net-provider] Connection timeout Problems

[Fabio Gomes]

Hi, i have the following code:

   try
   {
   cn.ConnectionString =
"User=SYSDBA;Password=masterkey;Database=/opt/firebird/dados/siad.gdb;DataSource=
192.168.15.254;Port=3050;Dialect=3;Charset=ISO8859_1;Role=;Connection
lifetime=0;Connection timeout=1;Pooling=True;Packet Size=8192;Server
Type=0";
   cn.Open();
   }
   catch
   {
   try
   {
   cn.ConnectionString = cn.ConnectionString =
"User=SYSDBA;Password=masterkey;Database=/opt/firebird/dados/siad.gdb;DataSource=linux;Port=3050;Dialect=3;Charset=ISO8859_1;Role=;Connection
lifetime=0;Connection timeout=1;Pooling=True;Packet Size=8192;Server
Type=0";
   cn.Open();
   }
   catch (Exception ex)
   {
   throw new Exception(ex.Message);
   }
   }

Now it is with timeout=1 but it was 15 before and i was having connection
issues, after using my software for more then 10 minutes it started to
freeze, and after debugging it i figured out that firebird was returning
connection timeout.

And my debuuger keeps saying on the output 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 any reply.


--
Fabio Gomes
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 sometimes ;)

On 12/8/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
> Hello:
> >
> > My question: I do not understand what do you mean "it is as is by design".
> > Could you explain it in more detail please? Do you mean (when using the term
> > "design") either concrete implementation of the Firebird provider, or design
> > of ADO .NET architecture? Or something completely different ;-) ?
> Firebird doesn't have support for named parameters ( the support for
> named input parameters is implemented in the
> provider )
> > In any case, this issue is very surprising and disappointing for me and IMHO
> > for 90% of all users of the Fb provider.. :-/
> I don't think that is true ...
>
>
> --
> Carlos Guzmán Álvarez
> Vigo-Spain
>
> http://carlosga.wordpress.com
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 provider 1.7 included only for mono 1.0 profile...
> >
>
> Here is the email i have sent to the mono-devel list:
>
> "Is there interest on having that sources on the mono svn ?? they work
> only with .net 2.0 and the equivalent mono version and there are heavy
> changes on namespaces and directory structure organization compared
> with the 1.7 sources ( that are the ones currently in mono svn )"
>
> And here the answer from Miguel De Icaza
>
>
> "I think there is some interest, but we need to think about how much of
> the code we want to keep inside Mono today.
>
> We have recently started to split things up, because having every
> library in the "mono" distribution has its share of logistic issues.
>
> Recently we moved a lot of the FX 3 stuff to a new module called
> "Olive", and we have created our own stack of crypto stuff in a module
> called "Crimson".
>
> I would like to have a new module for this kind of libraries, to keep
> the Mono core smaller.   We would still ship it though."
>
>
>
>
>
> --
> Carlos Guzmán Álvarez
> Vigo-Spain
>
> http://carlosga.wordpress.com
>
> -
> 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 Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>


-- 
.HELP SEX: This system is a computer and as such is not able to help
with enquiries of this nature. For details on reproduction, see the
Xerox documentation.

-
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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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#.
>
>
>  
>  Yahoo! Search
>  Música para ver e ouvir: You're Beautiful, do James Blunt
>
>
> -
> 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 Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>

-
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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 doesn't have support for named parameters, it's
implemented in the provider )--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/No hay un solo rey que no descienda de un esclavo,
ni un esclavo que no haya tenido reyes en su familia.-Take Surveys. Earn Cash. Influence the Future of ITJoin SourceForge.net
's Techsay panel and you'll get the chance to share youropinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/firebird-net-provider

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Fabio Gomes]

Yes, i am.But, is the "@" anything to do with the parameter?On 7/20/06, Amanda Kabak <[EMAIL PROTECTED]
> wrote:















Are you adding your parameters in the same
order they're specified in the execute statement?

 









From:
[EMAIL PROTECTED]

[mailto:[EMAIL PROTECTED]
] 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 ExecutarProcedure(string sql,
List Parameters, IDbConnection cn, IDbTransaction tr)
  {
  FbConnection _cn =
(FbConnection)cn; 
  FbTransaction _tr = (FbTransaction)tr;
  FbCommand cmd = new
FbCommand();
  cmd.CommandType =
CommandType.StoredProcedure;
  cmd.CommandText =
sql;  
  cmd.Connection = _cn;
  if (tr != null)
 
cmd.Transaction = _tr;
  foreach (Parametro par
in Parameters)
  {
 
cmd.Parameters.AddWithValue(par.nome, par.valor);
 
}  
  return
(cmd.ExecuteNonQuery() > 0);
  }



On 7/20/06, Le roy Arnaud
<[EMAIL PROTECTED]> wrote: 

hello try to this :

cmd.CommandType = CommandType.StoredProcedure;



-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash 

http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___ 
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net


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



 







-Take Surveys. Earn Cash. Influence the Future of ITJoin SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/firebird-net-provider

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 with the name of my table collumn?-- Forwarded message --From: Carlos Guzmán Álvarez <
[EMAIL PROTECTED]>Date: Jul 20, 2006 10:49 AMSubject: Re: [Firebird-net-provider] Executing Stored Procedures,To: "For users and developers of the Firebird .NET providers" <
firebird-net-provider@lists.sourceforge.net>Hello:> Was this the problem? should i name the parameters after the collumn name?I'm sorry but i don't understand what you mean.--
Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/No hay un solo rey que no descienda de un esclavo,ni un esclavo que no haya tenido reyes en su familia.
-Take Surveys. Earn Cash. Influence the Future of ITJoin SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cashhttp://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 the collumn name?On 7/20/06, Carlos Guzmán Álvarez <
[EMAIL PROTECTED]> wrote:Hello:> I m adding it to the code, but it doesnt work, here all my code:
What exception are you getting ??--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/No hay un solo rey que no descienda de un esclavo,
ni un esclavo que no haya tenido reyes en su familia.-Take Surveys. Earn Cash. Influence the Future of ITJoin SourceForge.net
's Techsay panel and you'll get the chance to share youropinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/firebird-net-provider

-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 = new FbCommand();  cmd.CommandType = CommandType.StoredProcedure;  cmd.CommandText = sql;    cmd.Connection
 = _cn;  if (tr != null)  cmd.Transaction = _tr;  foreach (Parametro par in Parameters)  {  cmd.Parameters.AddWithValue(par.nome, par.valor);  }  
  return (cmd.ExecuteNonQuery() > 0);  }On 7/20/06, Le roy Arnaud <[EMAIL PROTECTED]> wrote:
hello try to this :cmd.CommandType = CommandType.StoredProcedure;
-Take Surveys. Earn Cash. Influence the Future of ITJoin SourceForge.net's Techsay panel and you'll get the chance to share youropinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 StoredProcedureName(@param1, @param2, @param3)";I m making a Data Access Layer, and i would like it to make my application work with Firebird and Sql Server without changing code, i know less about Sql Server then i know firebird, but i think that this "Execute procedure" will not work there...
How can i make this thing works?I m passing the parameters like this:cmd.Parameters.AddWithValue("@Param1", somevalue);And here is my stored procedure:CREATE PROCEDURE SP_INS_CIDADE (
    INCID_COD INTEGER,    INCID_NOME VARCHAR(60),    INEST_COD CHAR(2))ASbegin    INSERT INTO CIDADES (CID_COD, CID_NOME, EST_COD) VALUES(:incid_cod, :incid_nome, :inest_cod);endThanx for any help,
-Fábio.
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Fabio Gomes]

I tried without the size, but i got an exeption saying that i must
fill the source column, i m using DataAdapter.Update(DataSet), so i
think i will have to fill up the size too.

Could you guys give me some guidance about the sizes that i asked?

Thanx,

-Fábio.

On 7/6/06, Jiri Cincura <[EMAIL 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 off the Value too?
>
> Why?
>
> --
> Jiri Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> 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 Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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", FbDbType.Integer).Value = id;
> There's no need to specify it (sometimes, you will save one data-exchange
> with server - but who cares). :)
>
>
> --
> Jiri Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> 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 Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Size on FbParameters

[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 blob.. for example, the field above is
NUMERIC(10,3), how should i put the size? 13? Whant about integer
fields, how do i set the size? And Blobs?

cmdUpdate.Parameters.Add(new FbParameter("@PRO_QTDE",
FbDbType.Numeric, 13, "PRO_QTDE"));


I think its kinda stupid hehe hope you guys dont mind helping me out.

Thanx in advance,

Fábio.

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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 targeted to NET1.1> compatibility and all .NET 2.0 development being done in 1.1.15 branch.>> Could you please try to build using latest mono from 
1.1.15 branch?>Right now no ( the DbParameter file looks as being without changes forthe last 4 months in trunk, anyway )all the builds i have done of mono was on linux and i haven't itinstalled now.
--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/No hay un solo rey que no descienda de un esclavo,ni un esclavo que no haya tenido reyes en su familia.
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 easierDownload IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___
Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 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 Application Server v.1.0.1 based on Apache Geronimohttp://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 the problem was from:
http://thesource.ofallevil.com

Thanx,

-Fábio

On 6/27/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
> Hello:
> > 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.
> >
> TextBox or MaskedTextBox ??
>
>
>
> --
> Carlos Guzmán Álvarez
> Vigo-Spain
>
> http://carlosga.blogspot.com/
>
> No hay un solo rey que no descienda de un esclavo,
> ni un esclavo que no haya tenido reyes en su familia.
>
>
> 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 Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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ábio.

On 6/27/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
> Hello:
> > Any ideas?
> >
> Can you fill a dataset ( without using DataBinding on it ) and check the
> date value ??
> Can you send a test case to my private email ??
>
>
> --
> Carlos Guzmán Álvarez
> Vigo-Spain
>
> http://carlosga.blogspot.com/
>
> No hay un solo rey que no descienda de un esclavo,
> ni un esclavo que no haya tenido reyes en su familia.
>
>
> 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 Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Problems with Date Field

[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 stuff or the Firebird Provider...

The problem is kinda weird, for example.. if i type: 10/10/1980 in my
TextBox, when i use: DataAdapter.Update(DataSet), this date changes
to: 10/10/2006, the weird thing is that in my database it is recorded
as 1980, but shows up as 2006 on my screen after sending it to the
database, it is happening in all my Date Fields and with all kinds of
TextBoxes, Masked, not masked, customized...

Anyone have any idead what could be my problem?

Some people said that it would be the formating.. so i tried to add in
my BindContext FomattingEnable = true, and a FormatString like this:
"dd/MM/", but it didnt work either, the year keeps changing to
2006 after the update.

Any ideas?


Thanx in advance for any help.

-Fábio.

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 Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Connection String Builder Problem

[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 wrong.

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

[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 name and it worked...
So: DataSource = 192.168.0.1 didnt work,but: DataSource = MyServer works.Is it supposed to be this way?

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

[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 there any way to fix it?You can review what is the format of the Date in the Culture info of themain thread
and look if that can be the problem, but anyway it's not a problem onthe provider.--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/
"When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg )---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 easierDownload IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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>> It is removing the "0" (zero) from the month, is there a way to fix this?
What happens if you do the DataBinding against a Textbox instead of aMaskedTextbox ??--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/
"When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg )---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 easierDownload IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 type: 24/07/1984 it is recorded perfectly on the data.But when i need to show the data on the maskedtextbox, the data appears like this:
24/71/984It is removing the "0" (zero) from the month, is there a way to fix this?Thanx for any help.

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

[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 = ?";> this.cmdUpdate.Parameters.Add(new> FirebirdSql.Data.Firebird.FbParameter
 ("CLI_NOME",> FirebirdSql.Data.Firebird.FbDbType.VarChar, 40, "CLI_NOME"));> this.cmdUpdate.Parameters.Add(new> FirebirdSql.Data.Firebird.FbParameter("CLI_SOBRENOME",
> FirebirdSql.Data.Firebird.FbDbType.VarChar , 40, "CLI_SOBRENOME"));> this.cmdUpdate.Parameters.Add(new> FirebirdSql.Data.Firebird.FbParameter("CLI_COD",> FirebirdSql.Data.Firebird.FbDbType.Integer
, 0,> System.Data.ParameterDirection.Input , false, ((byte)(0)),> ((byte)(0)), "CLI_COD", System.Data.DataRowVersion.Current, null));> this.cmdUpdate.Parameters.Add(new> FirebirdSql.Data.Firebird.FbParameter
("VED_COD",> FirebirdSql.Data.Firebird.FbDbType.Integer , 0,> System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)),> "VED_COD", System.Data.DataRowVersion.Current, null));
If you use the placeholder for parameters ( ? ) you should define theparameters in the same order as they appear in the sql command text.--Carlos Guzmán ÁlvarezVigo-Spain
http://carlosga.blogspot.com/"When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg )---
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 easierDownload IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___
Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 seens fine.
Its weird cause i m checking for changes before doing the da.Update(ds) and i have changes in my dataset, but when i execute the DataAdapter.update(DataSet) it gives me this exception:
System.Data.DBConcurrencyException: An attempt to execute an INSERT,
UPDATE, or DELETE statement resulted in zero records affected.
   at FirebirdSql.Data.Firebird.FbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
   at Sistema.frmBase.GravarDados() in D:\Documents and
Settings\suporte\Meus documentos\Visual Studio
2005\Projects\SGC\Sistema de Gestão Comercial\frmBase.cs:line 122The weird thing is that it just happens with one field in my DB, and sometimes it works, sometimes dont, i cant find anything in particular that can make this occur, i already checked my update command parameters, already changed the field name, changed the field from INT to VARCHAR, but nothing seens to solve this.
Bellow is my code:This checks if i have changes in my form, if so it calls the GravarDados() method that will execute the update.private void btnGravar_Click(object sender, EventArgs e)
    {    this.BindingContext[ds, ds.Tables[0].TableName].EndCurrentEdit();    foreach (DataTable dt in ds.Tables)    {    foreach (DataRow dr in dt.Rows)    {
    dr.EndEdit();    }    }    if(ds.GetChanges() != null) {
    GravarDados();    } else {    MessageBox.Show("Nada para ser gravado!", "Status da gravação:", 
MessageBoxButtons.OK,MessageBoxIcon.Warning);    }    }This is the function that updates the database, its where i get the exception    protected void GravarDados() {    try
    {    da.Update(ds, ds.Tables[0].TableName);        DesabilitarCampos();    MessageBox.Show("Dados gravados corretamente!", "Status da gravação:", 
MessageBoxButtons.OK, MessageBoxIcon.Information);    }    catch (Exception ex)    {    MessageBox.Show(ex.ToString());    }        }
And here are my commands: //     // cmdDelete    //     this.cmdDelete.CommandText = "DELETE FROM CLIENTES WHERE CLI_COD = ?";    this.cmdDelete.Parameters.Add
(new FirebirdSql.Data.Firebird.FbParameter("CLI_COD", FirebirdSql.Data.Firebird.FbDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CLI_COD", System.Data.DataRowVersion.Current
, null));    //     // ds    //     //     // cmdInsert    //     this.cmdInsert.CommandText = "INSERT INTO CLIENTES (CLI_NOME ,CLI_SOBRENOME, VED_COD) VALUES (?,?,?)";
    this.cmdInsert.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter("CLI_NOME", FirebirdSql.Data.Firebird.FbDbType.VarChar, 40, "CLI_NOME"));    this.cmdInsert.Parameters.Add
(new FirebirdSql.Data.Firebird.FbParameter("CLI_SOBRENOME", FirebirdSql.Data.Firebird.FbDbType.VarChar, 40, "CLI_SOBRENOME"));    this.cmdInsert.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter
("VED_COD", FirebirdSql.Data.Firebird.FbDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VED_COD", System.Data.DataRowVersion.Current, null));    // 
    // cmdSelect    //     this.cmdSelect.CommandText = "SELECT CLI_COD,CLI_NOME,CLI_SOBRENOME, VED_COD  FROM CLIENTES";    //     // cmdUpdate    // 
    this.cmdUpdate.CommandText = "UPDATE CLIENTES SET CLI_NOME=?, CLI_SOBRENOME=?, VED_COD=? WHERE CLI_COD = ?";    this.cmdUpdate.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter
("CLI_NOME", FirebirdSql.Data.Firebird.FbDbType.VarChar, 40, "CLI_NOME"));    this.cmdUpdate.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter("CLI_SOBRENOME", FirebirdSql.Data.Firebird.FbDbType.VarChar
, 40, "CLI_SOBRENOME"));    this.cmdUpdate.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter("CLI_COD", FirebirdSql.Data.Firebird.FbDbType.Integer, 0, System.Data.ParameterDirection.Input
, false, ((byte)(0)), ((byte)(0)), "CLI_COD", System.Data.DataRowVersion.Current, null));    this.cmdUpdate.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter("VED_COD", FirebirdSql.Data.Firebird.FbDbType.Integer
, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((b

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

[Fabio Gomes]

Hi i changed my code a bit and now i m sure that the problem isnt with my update command.I noticed that every time i focused something else instead of the text boxes i was editing, my update worked, so if i do this:
    txtAtual.Focus();    this.BindingContext[ds.Tables[0]].EndCurrentEdit();    foreach(DataTable dt in ds.Tables) {    foreach(DataRow dr in 
dt.Rows) {    dr.EndEdit();    }    }    try {    da.Update(ds.Tables[0]);    } catch (Exception ex) {    MessageBox.Show
(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 <[EMAIL PROTECTED]
> wrote: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 {    this.BindingContext[ds.Tables[0]].EndCurrentEdit();    da.Update(ds,ds.Tables[0].TableName);    } catch (Exception ex) {

    MessageBox.Show(ex.ToString());    }I even tried this:   cmdUpdate.Parameters.Add("@CLI_COD", FbDbType.Integer);    cmdUpdate.Parameters.Add

("@CLI_NOME", FbDbType.VarChar);    cmdUpdate.Parameters.Add("@CLI_SOBRENOME", FbDbType.VarChar);And i tried to write the query in this way:UPDATE CLIENTES SET CLI_NOME= ?, CLI_SOBRENOME = ? WHERE CLI_COD = ?
And this way:UPDATE CLIENTES SET CLI_NOME= @CLI_NOME, CLI_SOBRENOME = @CLI_SOBRENOME WHERE CLI_COD = @CLI_CODWhat is pissing me off, is that i dont get ANY erros.And the problem isnt the connection, i tried: 
cn.Open() before the da.Update, and it gave me an error: Connection already opened.What is wrong with this?Thanx in advance for any help.

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

[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 {    this.BindingContext[ds.Tables[0]].EndCurrentEdit();    da.Update(ds,ds.Tables[0].TableName);    } catch (Exception ex) {
    MessageBox.Show(ex.ToString());    }I even tried this:   cmdUpdate.Parameters.Add("@CLI_COD", FbDbType.Integer);    cmdUpdate.Parameters.Add
("@CLI_NOME", FbDbType.VarChar);    cmdUpdate.Parameters.Add("@CLI_SOBRENOME", FbDbType.VarChar);And i tried to write the query in this way:UPDATE CLIENTES SET CLI_NOME= ?, CLI_SOBRENOME = ? WHERE CLI_COD = ?
And this way:UPDATE CLIENTES SET CLI_NOME= @CLI_NOME, CLI_SOBRENOME = @CLI_SOBRENOME WHERE CLI_COD = @CLI_CODWhat is pissing me off, is that i dont get ANY erros.And the problem isnt the connection, i tried: 
cn.Open() before the da.Update, and it gave me an error: Connection already opened.What is wrong with this?Thanx in advance for any help.

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

[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() + "'", cn);    try {        int i = (int) cmd.ExecuteScalar();    if(i > 0) {    this.Close();    }
    }On 4/27/06, Jiri Cincura <[EMAIL PROTECTED]> wrote:
On 28.4.2006 0:00 Jiri Cincura wrote:> are you getting still the error. If not, you have some bug in your code.> Try to use debugger to get the line number, where the null referenceAnd debugger also provides a lot of useful information.
--Jiri Cincurahttp://www.cincura.net/---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 easierDownload IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Fabio Gomes]

Thanx, but i dont think that my query is returning null, i even tried changing the query to "SELECT * FROM CLIENTES", but still i got the same error.On 4/27/06, 
Robert Simpson <[EMAIL PROTECTED]> wrote:
If you don't care about the ID, just SELECT COUNT(CLI_COD) FROM CLIENTES(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.net>Sent: Thursday, April 27, 2006 12:20 PMSubject: Re: [Firebird-net-provider] Getting a single value from thedatabase in C#This compiled but gave me this error when i executed the select:
System.NullReferenceException: Object reference not set to an instance of anobject.   at Sistema.frmLogin.btnOk_Click(Object sender, EventArgs e) inD:\Documents and Settings\suporte\Meus documentos\Visual Studio
2005\Projects\SGC\Sistema de Gestão Comercial\frmLogin.cs:line 30oh god.. why this have to be so complicated?here is my code:FbCommand cmd = new FbCommand("SELECT CLI_COD FROM CLIENTES
WHERE CLI_NOME='" + txtUsuario.ToString() + "'", cn);try {int 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)cmd.ExecuteScalar();>>> --> Jiri Cincura> http://www.cincura.net/>>
> ---> 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 Application Server v.1.0.1 based on Apache Geronimo> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> ___> Firebird-net-provider mailing list> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider>---
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 easierDownload IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___
Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Fabio Gomes]

This compiled but gave me this error when i executed the select:System.NullReferenceException: Object reference not set to an instance of an object.   at Sistema.frmLogin.btnOk_Click(Object sender, EventArgs e) in D:\Documents and Settings\suporte\Meus documentos\Visual Studio 2005\Projects\SGC\Sistema de Gestão Comercial\frmLogin.cs:line 30
oh god.. why this have to be so complicated?here is my code:    FbCommand cmd = new FbCommand("SELECT CLI_COD FROM CLIENTES WHERE CLI_NOME='" + txtUsuario.ToString() + "'", cn);
    try {    int 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)cmd.ExecuteScalar();--Jiri Cincurahttp://www.cincura.net/
---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 Application Server v.1.0.1 based on Apache Geronimohttp://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Fabio Gomes]

    FbCommand cmd = new FbCommand("SELECT CLI_COD FROM CLIENTES WHERE CLI_NOME='" + txtUsuario.ToString() + "'", cn);    int i = cmd.ExecuteScalar();Its simple, i just want to get a int value with the CLI_COD, but i dont know how to convert it, the error 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 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.Paste here the piece of code, so we'll be able to send you much betterreply.--Jiri Cincurahttp://www.cincura.net/
---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 Application Server v.1.0.1 based on Apache Geronimohttp://sel.as-us.falkag.net/sel?cmdlnk&kid0709&bid&3057&dat1642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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:> I tryied with cmd.ExecuteNonQuery(), but it seens that it just returns> the number of affected rows with a DELETE, UPDATE or INSERT, it aways
> returned -1 with my select.Use cmd.ExecuteScalar()--Oleg---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 easierDownload IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 this SELECT returned true or false.. i m used to code PHP and it is easy to know if a select found one or more rows or didnt find any in PHP.
I tryied with cmd.ExecuteNonQuery(), but it seens that it just returns the number of affected rows with a DELETE, UPDATE or INSERT, it aways returned -1 with my select.I m out of ideas, i even tryied to use a 
reader.read(), but it didnt work, i dont know why.Thanx for any help,-Fábio

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

[Fabio Gomes]

i tried this:                    DataTable dtTable = ds_cli.Tables[0];                    dtTable.PrimaryKey = dtTable.Columns[0];                    DataRow delete = dtTable.Rows.Find(txtCli_cod);                    
delete.Delete();But it gives me an error, how am i supposed to pass the 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 <[EMAIL PROTECTED]> wrote:

Hello:> Sorry.. what do mean changes before the update?Check if ds_cli.HasChanges is true if not the dataadapter will havenothing to update,did you have deleted the Row from the datatable right ??
--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/"When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg )
---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 will havenothing to update,did you have deleted the Row from the datatable right ??
--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/"When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg )
---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Fabio Gomes]

Nice, but are you using firebird? Does the book help you with firebird?Cause i m finding it too difficult to make simple things with firebird and C# :(On 4/11/06, 
Kevin Stanton <[EMAIL PROTECTED]> wrote:















I too am just learning C# and am going
through the "MS Visual C# 2005 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.sourceforge.net

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



 

Thanx,

I already know this site and it has good stuff, but i m new to C# and ADO.NET. and all the tutorials i find out there are
using SQL server, Acess Database or Oracle, i cant find anything about firebird
for begginners like me. 

Does this mean i should first learn sql server with C# and then migrate to
firebird? I ve been using firebird with php for quite some time now, so i m
used to it, but my main problem is to make it work with C#, i m trying to make
a simple form to add, delete and update some data into a single table, and i m
already stuck with it :( 



On 4/11/06, Ruben
Guinez <[EMAIL 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 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 any help,

Fábio.

















-- 
Rubén D. Guíñez Gutiérrez
Software Developer 





 

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

[Fabio Gomes]

Thanx,I already know this site and it has good stuff, but i m new to C# and ADO.NET. and all the tutorials i find out there are using SQL server, Acess Database or Oracle, i cant find anything about firebird for begginners like me.
Does this mean i should first learn sql server with C# and then migrate to firebird? I ve been using firebird with php for quite some time now, so i m used to it, but my main problem is to make it work with C#, i m trying to make a simple form to add, delete and update some data into a single table, and i m already stuck with it :(
On 4/11/06, Ruben Guinez <[EMAIL 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 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 any help,Fábio.

-- Rubén D. Guíñez GutiérrezSoftware Developer

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

[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 any help,Fábio.

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

[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){> try {> da_cli.DeleteCommand =
> con.CreateCommand();>> da_cli.DeleteCommand.CommandText = "DELETE FROM CLIENTES WHERE> CLI_COD = @cli_cod";>> da_cli.DeleteCommand.Parameters.Add("@cli_cod",
> codigo).SourceColumn = "CLI_COD";> da_cli.Update(ds_cli,> "CLIENTES");> ds_cli.AcceptChanges();
> MessageBox.Show("Record> deleted...");> } catch (Exception ex) {> MessageBox.Show(ex.ToString
());> }> } else {> MessageBox.Show("Record NOT deleted...");> }>> da_cli is my data Adapter and ds_cli is my DataSource, is something
> wrong with this?>The database has changes before the update ??--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/
"When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg )---This SF.Net
 email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcastand join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642___
Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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();                                          da_cli.DeleteCommand.CommandText = "DELETE FROM CLIENTES WHERE  CLI_COD = @cli_cod";                                          da_cli.DeleteCommand.Parameters.Add("@cli_cod", 
 codigo).SourceColumn = "CLI_COD";                                          da_cli.Update(ds_cli, "CLIENTES");                                          ds_cli.AcceptChanges();                                          
MessageBox.Show("Record deleted...");                          } catch (Exception ex) {                                  MessageBox.Show(ex.ToString());                          }                  } else { 
                         MessageBox.Show("Record NOT deleted...");                  }  da_cli is my data Adapter and ds_cli is my DataSource, is something  wrong with this?  My INSERT command works, here is the code: 
 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.InsertCommand.Parameters.Add("@cli_cod",  codigo).SourceColumn = "CLI_COD";                                  da_cli.InsertCommand.Parameters.Add("@cli_nome", 
 txtCli_nome.Text.ToString()).SourceColumn = "CLI_NOME";                                  da_cli.InsertCommand.Parameters.Add("@cli_sobrenome",  txtCli_sobrenome.Text.ToString()).SourceColumn = "CLI_SOBRENOME"; 
                                 da_cli.Update(ds_cli, "CLIENTES");                                  ds_cli.AcceptChanges();  The insert above works, and i cant figure out why the DELETE isnt 
 working, i already checked the codigo var, and its filled with the  correct number, but the command just won´t delete anything, and it  doesnt give me any exception.  thanx for any help. 

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

[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.InsertCommand.Parameters.Add("@cli_cod", FbDbType.Integer).Value = codigo;                   da_cli.InsertCommand.Parameters.Add("@cli_nome", FbDbType.VarChar).Value = txtCli_nome.Text.ToString();
                   da_cli.InsertCommand.Parameters.Add("@cli_sobrenome", FbDbType.VarChar).Value = txtCli_sobrenome.Text.ToString();                   da_cli.Update(ds_cli, "CLIENTES");                   ds_cli.AcceptChanges();
But i got the same error.Am i making it the right way? or is there another way to do this insert on my database? cause google isnt helping much in this case :(Anyway, thanx for the quick reply :)
On 4/7/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
Hello:> The error occur on the bold part, if i use: INSERT...VALUES('" +> txtCli_nome.Text.ToString() + "') it works, but if i use> Add("@cli_nome", txtCli_nome.Text.ToString()), it gives me that error,
> anyone knows why am i getting that?Try to add the parameters using the ctor that takes a FbDbtypeparameter, if it didn't work send a test case ( database included ) tomy private email for review.
--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/"When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg )
---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 reference not set to an instance of an object.   at FirebirdSql.Data.Firebird.FbDataAdapter.Update
(DataRow[] dataRows, DataTableMapping tableMapping)   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
   at Teste.cad_cli.Btn_salvarClick(Object sender, EventArgs e)I ll post and explain my code, cause i m really new to C# and i m learning by myself just google for stuff.. so i think i may be messing everything up, here we go.
To get the ID to insert on the table i m using this:        private void ClearFields() {            //Código Autoincremento            string sql = "SELECT GEN_ID(GEN_CLIENTES_ID,1) FROM RDB$DATABASE";
            FbCommand select = con.CreateCommand();            select.CommandText = sql;            FbDataReader reader = select.ExecuteReader();            while(reader.Read()) {                codigo = 
reader.GetInt32(0);            }            txtCli_cod.Text = codigo.ToString();            txtCli_nome.Text = "";            txtCli_sobrenome.Text = "";        }This gets the ID to insert on the table.. then i m using this to do the Insert:
        void Btn_salvarClick(object sender, System.EventArgs e)        {            DataTable dtTable = ds_cli.Tables[0];            DataRow newRow = dtTable.NewRow();                        newRow["CLI_COD"] = codigo;
            newRow["CLI_NOME"]   = txtCli_nome.Text;            newRow["CLI_SOBRENOME"]  = txtCli_sobrenome.Text;            dtTable.Rows.Add(newRow);            try {                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.InsertCommand.Parameters.Add("@cli_cod", codigo);
                   da_cli.InsertCommand.Parameters.Add("@cli_nome", txtCli_nome.Text.ToString());                   da_cli.InsertCommand.Parameters.Add("@cli_sobrenome", txtCli_sobrenome.Text.ToString());
                   da_cli.Update(ds_cli, "CLIENTES");                   ds_cli.AcceptChanges();
            } catch(Exception ex) {                                            txtPesq.Text = ex.ToString();            }The error occur on the bold part, if i use: INSERT...VALUES('" + txtCli_nome.Text.ToString() + "') it works, but if i use Add("@cli_nome", txtCli_nome.Text.ToString()), it gives me that error, anyone knows why am i getting that?
And also, am i doing the right thing here, or am i messing up and complicating everything?Thanx for any help or opinion,-Fábio

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

[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 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?Use gacutil to install the assembly in the GAC ... but i think you willneed to use the mono one.Or maybe SharpDevelop show have an option to browse for the assemblies
when adding a new reference to a project--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/---
This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcastand join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642___
Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 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 Álvarez <[EMAIL PROTECTED]> wrote:

Hello:> Hum.. where can i find info about how to build it? i just downloaded> the installer and installed it.

http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=development--Carlos Guzmán ÁlvarezVigo-Spain
http://carlosga.blogspot.com/
---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 Álvarez <[EMAIL PROTECTED]> wrote:
Hello:> Hum.. where can i find info about how to build it? i just downloaded> the installer and installed it.
http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=development--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/
---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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 guys help me out with some> information about using mono with firebird?In first place, nothing, it looks like a mono problem when doing the
strong name validation of the provider.Try to build the provider sources using mono and retry.--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/
---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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" compiles fine, but when i try to import a visual studio project or just connect with the firebird database it doesnt compile.
When i try to connect i get this error with mono:Exception System.IO.FileLoadException was thrown in debugee:
Strong name validation failed for assembly 'FirebirdSql.Data.Firebird'.This is my code:using System; using System.Data; using FirebirdSql.Data.Firebird; public class Test {    public static void Main(string[] args) {
        FbConnection myConnection1 = new FbConnection("User=SYSDBA;" +    "Password=masterkey;" +    "Database=/home/trab/SiadPHP/testes/siad.gdb;" +
    "DataSource=192.168.15.101 ;" +    "Port=3050;" +    "Dialect=3;" +    "Charset=ISO8859_1;");
          myConnection1.Open();          Console.WriteLine("Hello World");          Console.ReadLine();    }}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 guys help me out with some information about using mono with firebird?Any help is welcome,Thanx in advance.

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

[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 "192.168.15.101 ". --->> FirebirdSql.Data.Common.IscException: Exception of type> 'FirebirdSql.Data.Common.IscException' was thrown.>at FirebirdSql.Data.Client.Gds.GdsConnection.Connect (String
> dataSource, Int32 port, Int32 packetSize, Charset charset)>at> FirebirdSql.Data.Client.Gds.GdsDatabase.Attach(DatabaseParameterBuffer> dpb, String dataSource, Int32 port, String database)
>at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()>--- End of inner exception stack trace --->at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()>at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create
 ()>at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut()>at FirebirdSql.Data.FirebirdClient.FbPoolManager.GetConnection> (String connectionString)>at FirebirdSql.Data.FirebirdClient.FbConnection.Open
()>at ConsoleApplication1.Program.Main(String[] args) in D:\Documents> and Settings\suporte\Configurações locais\Dados de> aplicativos\Temporary Projects\ConsoleApplication1\Program.cs:line 25
So the error is giving in the method that performs the socketconnection, can you send the code you have used in your socket test case ??--Carlos Guzmán ÁlvarezVigo-Spain
http://carlosga.blogspot.com/---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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.GdsConnection.Connect
(String dataSource, Int32 port, Int32 packetSize, Charset charset)   at FirebirdSql.Data.Client.Gds.GdsDatabase.Attach(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database)
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()   --- End of inner exception stack trace ---
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()   at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create
()   at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut()   at FirebirdSql.Data.FirebirdClient.FbPoolManager.GetConnection
(String connectionString)   at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
   at ConsoleApplication1.Program.Main(String[] args) in D:\Documents and Settings\suporte\Configurações locais\Dados de aplicativos\Temporary Projects\ConsoleApplication1\Program.cs:line 25
And here is my code:using System;using System.Collections.Generic;using System.Text;using FirebirdSql.Data.FirebirdClient;using System.IO;namespace ConsoleApplication1{    class Program
    {    static void Main(string[] args)    {    string connectionString =    "User=SYSDBA;" +    "Password=masterkey;" +    "Database=/home/trab/SiadPHP/testes/siad.gdb;" +
    "DataSource=192.168.15.101 ;" +    "Port=3050;" +    "Dialect=3;" +    "Charset=ISO8859_1;";    
    FbConnection fbConn = new FbConnection(connectionString);    try    {    fbConn.Open();    }    catch (Exception e)    {    StreamWriter fwriter =   
File.CreateText(@"D:\teste.txt");    fwriter.WriteLine(e.ToString());    fwriter.Close();    }    }    }}On 3/17/06, 
Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
Hello:> Yes, i tried that and it connects.Ok.> 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.I need more info can you build the provider sources and do a debug tosee where it's being raised the exception, and can you send here thecomplete details of the exception, just catch it and do a ToString of
the exception.--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/---
This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcastand join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642___
Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
Hello:> 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 "Have you done yet a simple socket test in v2.0 to see if can connect tothat server in port 3050 ??--Carlos Guzmán Álvarez
Vigo-Spainhttp://carlosga.blogspot.com/---This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcastand join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642___Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[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# and Visual Studio Express 2005.Is it a bug or am i doing something wrong?
Cause the same code works with the 1.7 version, everything runs fine.Thanx for any help.-Fábio.