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

Re: [Firebird-net-provider] next problem

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

The firebrd.net project is mine.  It works by linking against the firebird c
libaries in a dll that is a mix of managed and unmanaged c++.  That dll is
then called by the provider which is written in vb.net.

It works and it was the best way I could think of to do it at the time but
it isn't the cleanest implemenation.


Christoph

----- Original Message -----
From: "Pavol Starek - PSZ" <pa...@st...>
To: <fir...@li...>
Cc: "Carlos Guzmán Álvarez" <car...@te...>
Sent: Monday, November 18, 2002 9:13 PM
Subject: Re: [Firebird-net-provider] next problem


> hi,
>
> when you plan to release patch??? any way, are you often commiting changes
> to CVS??? Is there bug fix for that record size problem???
>
> what are CVS parameters??? On source forge i found only Firebird.NET (a
.net
> data provider): CVS but it looks strange... I think that it is not correct
> project... So send me please server path and module name...
>
>
> Your pooling is nice, but it works only while assembly is in use... when
one
> project ends and garbage collector decide to trash your net provider, pool
> is flushed and destroyed... So if i want to create ASP.NET page i have to
> link assembly to global.asax and in this situation i can use only
> STAThreading... As i wrote, i have more than 20k hits to database in hour
it
> is more than 5 in sec... but sometimes it is more then 15hits/s... simple
i
> cannot use STAThreading... if i link assembly to each page, it is released
> each time processing of page is done... again useless for me...
> Im not forcing you to that... My be there is space for me...
>
> i know that you are making your assembly System.Data compatible and
therefor
> there are that overloads. I know that they are needed, but documentation
is
> not clear in this way... again may be space for me...
>
> thanx
> p.
>
> ----- Original Message -----
> From: "Carlos Guzmán Álvarez" <car...@te...>
> To: "Pavol Starek - PSZ" <pa...@st...>; "Firebird .Net Provider"
> <fir...@li...>
> Sent: Monday, November 18, 2002 11:39 AM
> Subject: Re: [Firebird-net-provider] next problem
>
>
> > Hello:
> >
> >  > Can you release a patch or something??? I have now time to play with
> > this assembly, so i can do lot of tests...
> >
> > I´m thinking on release an Alpha 4 version.
> >
> >  > next thing is: do you plan make it System.EnterpriseServices allowed
> > it is
> >  > important for performance... I plan to use your component on big
> ASP.NET
> >  > site (more than 20k hits a hour), but now it is unusable (pooling not
> >  > working as i have to do)...
> >  > My site was writen using COM+ objects in delphi. it was fast stable
and
> >  > scalable, but developing take to log, becouse you need to take care
> about
> >  > com+ logic more than your aplication logic... Net brings easy way how
> to
> >  > develob COM+ compliant assemblies and it is cool.
> >  > I can rewrite your code to make it thread safe, but it will be hard
for
> >  > me... very hard... without your help... And for now im not .NET guru,
> > so my
> >  > code will be not very nice...
> >
> >
> > I have no planned this, at this moment my intention is to have the
> > pooling working well. Here is an example on how the pooling is working
now
> :
> >
> >      FbConnection myConnection1 = new
FbConnection(GetConnectionString());
> >      FbConnection myConnection2 = new
FbConnection(GetConnectionString());
> >      FbConnection myConnection3 = new
FbConnection(GetConnectionString());
> >
> >      // Open two connections.
> >      Console.WriteLine ("Open two connections.");
> >      myConnection1.Open();
> >      myConnection2.Open();
> >
> >      // Now there are two connections in the pool that matches the
> > connection string.
> >      // Return the both connections to the pool.
> >      Console.WriteLine ("Return both of the connections to the pool.");
> >      myConnection1.Close();
> >      myConnection2.Close();
> >
> >      // Get a connection out of the pool.
> >      Console.WriteLine ("Open a connection from the pool.");
> >      myConnection1.Open();
> >
> >      // Get a second connection out of the pool.
> >      Console.WriteLine ("Open a second connection from the pool.");
> >      myConnection2.Open();
> >
> >      // Open a third connection.
> >      Console.WriteLine ("Open a third connection.");
> >      myConnection3.Open();
> >
> >      // Return the all connections to the pool.
> >      Console.WriteLine ("Return all three connections to the pool.");
> >      myConnection1.Close();
> >      myConnection2.Close();
> >      myConnection3.Close();
> >
> > What are the params of your connection string???
> >
> >  > Next thing is, that documentation is greate (very complex), but
> > somethimes
> >  > it is not good :-)  you done there lot of overloaded methods and
> >  > constructors and not all are working in any way of use...
> >
> >
> > Why?? All overloaded constructors are needed, if you see documentation
> > of SqlClient, OleDb or ODBC .Net data providers you will see probably
> > the same.
> >
> >  > Some examples are obsolete (you have there examples without
> > transactions) and so... I want to help you with
> >  > this project. May be i can start with documentation but you have to
say
> >  > exactly what to do, not only say that do something... i cannot swim,
> > so you
> >  > cannot throw me in to a pool...
> >
> >
> >
> > I have reviewed thew examples of:
> >
> > - FbConnection
> > - FbDataReader
> > - FbDataAdapter
> > - FbCommandBuilder
> > - FbCommand
> >
> > and i vahe it commited to the CVS.
> >
> >
> > Best regards
> > Carlos Guzmán Álvarez
> > Vigo-Spain
> >
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: To learn the basics of securing
> your web site with SSL, click here to get a FREE TRIAL of a Thawte
> Server Certificate: http://www.gothawte.com/rd524.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] next problem

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

Hello:

> hi,
>
> when you plan to release patch??? any way, are you often commiting changes
> to CVS??? Is there bug fix for that record size problem???


It´s updated in the CVS.

>
>
> what are CVS parameters??? On source forge i found only Firebird.NET 
> (a .net
> data provider): CVS but it looks strange... I think that it is not correct
> project... So send me please server path and module name...


http://sourceforge.net/cvs/?group_id=9028

Module Net-Provider.

> Your pooling is nice, but it works only while assembly is in use... 
> when one
> project ends and garbage collector decide to trash your net provider, pool
> is flushed and destroyed... So if i want to create ASP.NET page i have to
> link assembly to global.asax and in this situation i can use only
> STAThreading... As i wrote, i have more than 20k hits to database in 
> hour it
> is more than 5 in sec... but sometimes it is more then 15hits/s... 
> simple i
> cannot use STAThreading... if i link assembly to each page, it is released
> each time processing of page is done... again useless for me...
> Im not forcing you to that... My be there is space for me...


Can help to this if i use MarshalByRefObject on the the pool??

> i know that you are making your assembly System.Data compatible and 
> therefor
> there are that overloads. I know that they are needed, but 
> documentation is
> not clear in this way... again may be space for me...


Why is not clear?? (i want to make it the mos clearly as possible), i 
think CHM is very nice.



Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] next problem

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

hi,

when you plan to release patch??? any way, are you often commiting changes
to CVS??? Is there bug fix for that record size problem???

what are CVS parameters??? On source forge i found only Firebird.NET (a .net
data provider): CVS but it looks strange... I think that it is not correct
project... So send me please server path and module name...


Your pooling is nice, but it works only while assembly is in use... when one
project ends and garbage collector decide to trash your net provider, pool
is flushed and destroyed... So if i want to create ASP.NET page i have to
link assembly to global.asax and in this situation i can use only
STAThreading... As i wrote, i have more than 20k hits to database in hour it
is more than 5 in sec... but sometimes it is more then 15hits/s... simple i
cannot use STAThreading... if i link assembly to each page, it is released
each time processing of page is done... again useless for me...
Im not forcing you to that... My be there is space for me...

i know that you are making your assembly System.Data compatible and therefor
there are that overloads. I know that they are needed, but documentation is
not clear in this way... again may be space for me...

thanx
p.

----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Pavol Starek - PSZ" <pa...@st...>; "Firebird .Net Provider"
<fir...@li...>
Sent: Monday, November 18, 2002 11:39 AM
Subject: Re: [Firebird-net-provider] next problem


> Hello:
>
>  > Can you release a patch or something??? I have now time to play with
> this assembly, so i can do lot of tests...
>
> I´m thinking on release an Alpha 4 version.
>
>  > next thing is: do you plan make it System.EnterpriseServices allowed
> it is
>  > important for performance... I plan to use your component on big
ASP.NET
>  > site (more than 20k hits a hour), but now it is unusable (pooling not
>  > working as i have to do)...
>  > My site was writen using COM+ objects in delphi. it was fast stable and
>  > scalable, but developing take to log, becouse you need to take care
about
>  > com+ logic more than your aplication logic... Net brings easy way how
to
>  > develob COM+ compliant assemblies and it is cool.
>  > I can rewrite your code to make it thread safe, but it will be hard for
>  > me... very hard... without your help... And for now im not .NET guru,
> so my
>  > code will be not very nice...
>
>
> I have no planned this, at this moment my intention is to have the
> pooling working well. Here is an example on how the pooling is working now
:
>
>      FbConnection myConnection1 = new FbConnection(GetConnectionString());
>      FbConnection myConnection2 = new FbConnection(GetConnectionString());
>      FbConnection myConnection3 = new FbConnection(GetConnectionString());
>
>      // Open two connections.
>      Console.WriteLine ("Open two connections.");
>      myConnection1.Open();
>      myConnection2.Open();
>
>      // Now there are two connections in the pool that matches the
> connection string.
>      // Return the both connections to the pool.
>      Console.WriteLine ("Return both of the connections to the pool.");
>      myConnection1.Close();
>      myConnection2.Close();
>
>      // Get a connection out of the pool.
>      Console.WriteLine ("Open a connection from the pool.");
>      myConnection1.Open();
>
>      // Get a second connection out of the pool.
>      Console.WriteLine ("Open a second connection from the pool.");
>      myConnection2.Open();
>
>      // Open a third connection.
>      Console.WriteLine ("Open a third connection.");
>      myConnection3.Open();
>
>      // Return the all connections to the pool.
>      Console.WriteLine ("Return all three connections to the pool.");
>      myConnection1.Close();
>      myConnection2.Close();
>      myConnection3.Close();
>
> What are the params of your connection string???
>
>  > Next thing is, that documentation is greate (very complex), but
> somethimes
>  > it is not good :-)  you done there lot of overloaded methods and
>  > constructors and not all are working in any way of use...
>
>
> Why?? All overloaded constructors are needed, if you see documentation
> of SqlClient, OleDb or ODBC .Net data providers you will see probably
> the same.
>
>  > Some examples are obsolete (you have there examples without
> transactions) and so... I want to help you with
>  > this project. May be i can start with documentation but you have to say
>  > exactly what to do, not only say that do something... i cannot swim,
> so you
>  > cannot throw me in to a pool...
>
>
>
> I have reviewed thew examples of:
>
> - FbConnection
> - FbDataReader
> - FbDataAdapter
> - FbCommandBuilder
> - FbCommand
>
> and i vahe it commited to the CVS.
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>

Re: [Firebird-net-provider] next problem

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

Hello:

 > Can you release a patch or something??? I have now time to play with 
this assembly, so i can do lot of tests...

I´m thinking on release an Alpha 4 version.

 > next thing is: do you plan make it System.EnterpriseServices allowed 
it is
 > important for performance... I plan to use your component on big ASP.NET
 > site (more than 20k hits a hour), but now it is unusable (pooling not
 > working as i have to do)...
 > My site was writen using COM+ objects in delphi. it was fast stable and
 > scalable, but developing take to log, becouse you need to take care about
 > com+ logic more than your aplication logic... Net brings easy way how to
 > develob COM+ compliant assemblies and it is cool.
 > I can rewrite your code to make it thread safe, but it will be hard for
 > me... very hard... without your help... And for now im not .NET guru, 
so my
 > code will be not very nice...


I have no planned this, at this moment my intention is to have the 
pooling working well. Here is an example on how the pooling is working now :

     FbConnection myConnection1 = new FbConnection(GetConnectionString());
     FbConnection myConnection2 = new FbConnection(GetConnectionString());
     FbConnection myConnection3 = new FbConnection(GetConnectionString());

     // Open two connections.
     Console.WriteLine ("Open two connections.");
     myConnection1.Open();
     myConnection2.Open();

     // Now there are two connections in the pool that matches the 
connection string.
     // Return the both connections to the pool.
     Console.WriteLine ("Return both of the connections to the pool.");
     myConnection1.Close();
     myConnection2.Close();

     // Get a connection out of the pool.
     Console.WriteLine ("Open a connection from the pool.");
     myConnection1.Open();

     // Get a second connection out of the pool.
     Console.WriteLine ("Open a second connection from the pool.");
     myConnection2.Open();

     // Open a third connection.
     Console.WriteLine ("Open a third connection.");
     myConnection3.Open();

     // Return the all connections to the pool.
     Console.WriteLine ("Return all three connections to the pool.");
     myConnection1.Close();
     myConnection2.Close();
     myConnection3.Close();

What are the params of your connection string???

 > Next thing is, that documentation is greate (very complex), but 
somethimes
 > it is not good :-)  you done there lot of overloaded methods and
 > constructors and not all are working in any way of use...


Why?? All overloaded constructors are needed, if you see documentation 
of SqlClient, OleDb or ODBC .Net data providers you will see probably 
the same.

 > Some examples are obsolete (you have there examples without 
transactions) and so... I want to help you with
 > this project. May be i can start with documentation but you have to say
 > exactly what to do, not only say that do something... i cannot swim, 
so you
 > cannot throw me in to a pool...



I have reviewed thew examples of:

- FbConnection
- FbDataReader
- FbDataAdapter
- FbCommandBuilder
- FbCommand

and i vahe it commited to the CVS.


Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] next problem

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

Can you release a patch or something??? I have now time to play with this
assembly, so i can do lot of tests...

next thing is: do you plan make it System.EnterpriseServices allowed it is
important for performance... I plan to use your component on big ASP.NET
site (more than 20k hits a hour), but now it is unusable (pooling not
working as i have to do)...
My site was writen using COM+ objects in delphi. it was fast stable and
scalable, but developing take to log, becouse you need to take care about
com+ logic more than your aplication logic... Net brings easy way how to
develob COM+ compliant assemblies and it is cool.
I can rewrite your code to make it thread safe, but it will be hard for
me... very hard... without your help... And for now im not .NET guru, so my
code will be not very nice...

Next thing is, that documentation is greate (very complex), but somethimes
it is not good :-)  you done there lot of overloaded methods and
constructors and not all are working in any way of use... for example i
think, that most offen question will be that Object reference not set to an
instance of an object. I was able to solve this by my hand, becouse i know
how firebird work and i checked your code so i knew that transactions are
missing... but many peole is not so far... Some examples are obsolete (you
have there examples without transactions) and so... I want to help you with
this project. May be i can start with documentation but you have to say
exactly what to do, not only say that do something... i cannot swim, so you
cannot throw me in to a pool...

p.

p.



----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Pavol Starek" <pa...@st...>
Cc: <fir...@li...>
Sent: Monday, November 18, 2002 10:27 AM
Subject: Re: [Firebird-net-provider] next problem


> Hello:
>
>  >  i solved problem... it was my stupidnes... charset have to be 1250 not
>  > 1252.
>  >  it is hard make program without IDE...
>
>
>
> :)), yo can get an IDE for Windows here:
>
> http://www.icsharpcode.net/OpenSource/SD/default.asp
>
> If you are using Linux you can see:
>
> http://www.jext.org/home.html
> http://www.jedit.org/
> http://csde.sourceforge.net/
>
>  >  but i have new problem:
>  >
>  >  Unhandled Exception: FirebirdSql.Data.Firebird.FbException: invalid
> sqlind
>  >  value
>  >  : -1658821521
>  >     at FirebirdSql.Data.Firebird.FbResultset.Fetch()
>  >     at FirebirdSql.Data.Firebird.FbDataReader.Read()
>  >
>  >  where that value is varying...
>  >
>  >  thrown at first evaluating of expression
>  >   while (fbData.Read()) {
>  >  ...
>  >  }
>  >
>  >  here is metadata:
>  >
>  >  CREATE TABLE "ARTICLES"
>  >  (
>  >    "ID" INTEGER NOT NULL,
>  >    "NADNADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "NADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "PEREX" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "TEXT" VARCHAR(32000) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "VYDANIE" INTEGER,
>  >    "KATEGORIA" CHAR(5) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "DATUM" DATE
>  >  );
>  >
>  >  here is script:
>  >  select first x skip y ID, TEXT from ARTICLES order by ID
>  >
>  >  exception is thrown no depend ox x, y... problem is not in recor,
> because
>  > in
>  >  select first 3 skip 1 ID, TEXT from ARTICLES order by ID is exception
>  >  present but
>  >  in
>  >  select first 2 skip 2 ID, TEXT from ARTICLES order by ID is not...
>  >
>  >  i tried lot of combinations and i see that there is problem if sum of
>  >  lengths of rows is higher then some value (highest working i found was
>  > aprox
>  >  4298).
>  >  it dont read rwcords with size bigger then 4298 too...
>
> Ok, thanks, i have it solved now, there is a problem with sockets reading.
>
>  >  sumary:
>  >  i think, tha there is some problem with geting record bigger than
> 4298 b or
>  >  set of rows with sum size greater then 4298b while fetching rows.
>  >
>  > sorry if my questions and problems are stupid, but i like this
> assembly and
>  > i want to use it, so by patient with me...
>
>
> No problem :)
>
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>

Re: [Firebird-net-provider] next problem

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

Hello:

 >  i solved problem... it was my stupidnes... charset have to be 1250 not
 > 1252.
 >  it is hard make program without IDE...



:)), yo can get an IDE for Windows here:

http://www.icsharpcode.net/OpenSource/SD/default.asp

If you are using Linux you can see:

http://www.jext.org/home.html
http://www.jedit.org/
http://csde.sourceforge.net/

 >  but i have new problem:
 >
 >  Unhandled Exception: FirebirdSql.Data.Firebird.FbException: invalid 
sqlind
 >  value
 >  : -1658821521
 >     at FirebirdSql.Data.Firebird.FbResultset.Fetch()
 >     at FirebirdSql.Data.Firebird.FbDataReader.Read()
 >
 >  where that value is varying...
 >
 >  thrown at first evaluating of expression
 >   while (fbData.Read()) {
 >  ...
 >  }
 >
 >  here is metadata:
 >
 >  CREATE TABLE "ARTICLES"
 >  (
 >    "ID" INTEGER NOT NULL,
 >    "NADNADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
 >    "NADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
 >    "PEREX" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
 >    "TEXT" VARCHAR(32000) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
 >    "VYDANIE" INTEGER,
 >    "KATEGORIA" CHAR(5) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
 >    "DATUM" DATE
 >  );
 >
 >  here is script:
 >  select first x skip y ID, TEXT from ARTICLES order by ID
 >
 >  exception is thrown no depend ox x, y... problem is not in recor, 
because
 > in
 >  select first 3 skip 1 ID, TEXT from ARTICLES order by ID is exception
 >  present but
 >  in
 >  select first 2 skip 2 ID, TEXT from ARTICLES order by ID is not...
 >
 >  i tried lot of combinations and i see that there is problem if sum of
 >  lengths of rows is higher then some value (highest working i found was
 > aprox
 >  4298).
 >  it dont read rwcords with size bigger then 4298 too...

Ok, thanks, i have it solved now, there is a problem with sockets reading.

 >  sumary:
 >  i think, tha there is some problem with geting record bigger than 
4298 b or
 >  set of rows with sum size greater then 4298b while fetching rows.
 >
 > sorry if my questions and problems are stupid, but i like this 
assembly and
 > i want to use it, so by patient with me...


No problem :)



Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] next problem

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

Hi,

 i solved problem... it was my stupidnes... charset have to be 1250 not
1252.
 it is hard make program without IDE...

 but i have new problem:

 Unhandled Exception: FirebirdSql.Data.Firebird.FbException: invalid sqlind
 value
 : -1658821521
    at FirebirdSql.Data.Firebird.FbResultset.Fetch()
    at FirebirdSql.Data.Firebird.FbDataReader.Read()

 where that value is varying...

 thrown at first evaluating of expression
  while (fbData.Read()) {
 ...
 }

 here is metadata:

 CREATE TABLE "ARTICLES"
 (
   "ID" INTEGER NOT NULL,
   "NADNADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "NADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "PEREX" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "TEXT" VARCHAR(32000) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "VYDANIE" INTEGER,
   "KATEGORIA" CHAR(5) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "DATUM" DATE
 );

 here is script:
 select first x skip y ID, TEXT from ARTICLES order by ID

 exception is thrown no depend ox x, y... problem is not in recor, because
in
 select first 3 skip 1 ID, TEXT from ARTICLES order by ID is exception
 present but
 in
 select first 2 skip 2 ID, TEXT from ARTICLES order by ID is not...

 i tried lot of combinations and i see that there is problem if sum of
 lengths of rows is higher then some value (highest working i found was
aprox
 4298).
 it dont read rwcords with size bigger then 4298 too...

 sumary:
 i think, tha there is some problem with geting record bigger than 4298 b or
 set of rows with sum size greater then 4298b while fetching rows.

sorry if my questions are stupid, but i like this assembly and i want to use
it, so be patient with me...
 thanx
 p.

[Firebird-net-provider] next problem

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

Hi,

 i solved problem... it was my stupidnes... charset have to be 1250 not
1252.
 it is hard make program without IDE...

 but i have new problem:

 Unhandled Exception: FirebirdSql.Data.Firebird.FbException: invalid sqlind
 value
 : -1658821521
    at FirebirdSql.Data.Firebird.FbResultset.Fetch()
    at FirebirdSql.Data.Firebird.FbDataReader.Read()

 where that value is varying...

 thrown at first evaluating of expression
  while (fbData.Read()) {
 ...
 }

 here is metadata:

 CREATE TABLE "ARTICLES"
 (
   "ID" INTEGER NOT NULL,
   "NADNADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "NADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "PEREX" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "TEXT" VARCHAR(32000) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "VYDANIE" INTEGER,
   "KATEGORIA" CHAR(5) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
   "DATUM" DATE
 );

 here is script:
 select first x skip y ID, TEXT from ARTICLES order by ID

 exception is thrown no depend ox x, y... problem is not in recor, because
in
 select first 3 skip 1 ID, TEXT from ARTICLES order by ID is exception
 present but
 in
 select first 2 skip 2 ID, TEXT from ARTICLES order by ID is not...

 i tried lot of combinations and i see that there is problem if sum of
 lengths of rows is higher then some value (highest working i found was
aprox
 4298).
 it dont read rwcords with size bigger then 4298 too...

 sumary:
 i think, tha there is some problem with geting record bigger than 4298 b or
 set of rows with sum size greater then 4298b while fetching rows.

sorry if my questions and problems are stupid, but i like this assembly and
i want to use it, so by patient with me...
 thanx
 p.

[Firebird-net-provider] once again

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

sorry for this post, but im not sure that my previous question reached this
list so:

(BTW: why this post is not archived??? may be that my question was already
answered)


Hi,

i have little problem with:
Unhandled Exception: FirebirdSql.Data.Firebird.FbException: arithmetic
exception, numeric overflow, or string truncation

i use win1252 coding and slovak collation...
i have set in connection string
Pooling=true;Charset=WIN1252

i think, that i have to set something like culture for my app, but nothing i
tried worked...

pooling is not working too... because connection open takes more then 1
sec...

using alpha 3...

I think, that autor is not english native, so it is probable, that pronlem
is on my side, but i dont know where...

thanx
pavol

Re: [Firebird-net-provider] problem

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

Hello:

> i have little problem with:
> Unhandled Exception: FirebirdSql.Data.Firebird.FbException: arithmetic
> exception, numeric overflow, or string truncation
>
> i use win1252 coding and slovak collation...
> i have set in connection string
> Pooling=true;Charset=WIN1252


Making what?? What is the charset of the database??

> pooling is not working too... because connection open takes more then 1

> sec...


A sample on how connection pooling work (at this moment connection 
pooling can have problems :) ):

			FbConnection myConnection1 = new FbConnection(GetConnectionString());
			FbConnection myConnection2 = new FbConnection(GetConnectionString());
			FbConnection myConnection3 = new FbConnection(GetConnectionString());

			// Open two connections.
			Console.WriteLine ("Open two connections.");
			myConnection1.Open();
			myConnection2.Open();

			// Now there are two connections in the pool that matches the 
connection string.
			// Return the both connections to the pool.
			Console.WriteLine ("Return both of the connections to the pool.");
			myConnection1.Close();
			myConnection2.Close();

			// Get a connection out of the pool.
			Console.WriteLine ("Open a connection from the pool.");
			myConnection1.Open();

			// Get a second connection out of the pool.
			Console.WriteLine ("Open a second connection from the pool.");
			myConnection2.Open();

			// Open a third connection.
			Console.WriteLine ("Open a third connection.");
			myConnection3.Open();

			// Return the all connections to the pool.
			Console.WriteLine ("Return all three connections to the pool.");
			myConnection1.Close();
			myConnection2.Close();
			myConnection3.Close();



>
> using alpha 3...
>
> I think, that autor is not english native, so it is probable, that
> pronlem is on my side, but i dont know where...


I´m spanish.




Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] problem

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

Hi,

i have little problem with:
Unhandled Exception: FirebirdSql.Data.Firebird.FbException: arithmetic
exception, numeric overflow, or string truncation

i use win1252 coding and slovak collation...
i have set in connection string
Pooling=true;Charset=WIN1252

i think, that i have to set something like culture for my app, but nothing i
tried worked...

pooling is not working too... because connection open takes more then 1
sec...

using alpha 3...

I think, that autor is not english native, so it is probable, that pronlem
is on my side, but i dont know where...

thanx
pavol

[Firebird-net-provider] problem

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

Hi,

i have little problem with:
Unhandled Exception: FirebirdSql.Data.Firebird.FbException: arithmetic =
exception, numeric overflow, or string truncation

i use win1252 coding and slovak collation...
i have set in connection string=20
Pooling=3Dtrue;Charset=3DWIN1252

i think, that i have to set something like culture for my app, but =
nothing i tried worked...

pooling is not working too... because connection open takes more then 1 =
sec...

using alpha 3...

I think, that autor is not english native, so it is probable, that =
pronlem is on my side, but i dont know where...

thanx=20
pavol

Re: [Firebird-net-provider] FB.Net Provider Error

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

Hello:


> I'm just trying simple updates to a table. (Same query that is in Help
> on FbConnection)


The examples was wrong try this:

	
		FbConnection  myConn = new FbConnection(connectionString);
		
		myConn.Open();

		FbTransaction myTxn  = myConn.BeginTransaction();
		string		 myInsertQuery = "INSERT INTO PROJECT(proj_id, proj_name, 
product) Values ('FBNP', '.Net Provider', 'N/A')";
		FbCommand	 myFbCommand   = new FbCommand(myInsertQuery, myConn, myTxn);
				
		myFbCommand.ExecuteNonQuery();
		myConn.Close();

		Console.ReadLine();		


I have modified the example and updated the CVS, thanks.


 >>I put this question on IBSupport and I was old to post it to this 
 >>email address. Where do I read the reply to this posting?

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


Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FB.Net Provider Error

[Sandeep C. <sa...@cf...>]

I'm using FB.Net provider to connect to a database. I can connect to 
the database, but when I try to execute a query I get this error

"Object reference not set to an instance of an object".

I'm just trying simple updates to a table. (Same query that is in Help
on FbConnection)

What am I doing wrong?

I put this question on IBSupport and I was old to post it to this email
address. Where do I read the reply to this posting?

Regards

Sandeep

[Firebird-net-provider] Support for Parameters with NULL as value

[Jojakim S. <JS...@de...>]

Hello!
I modified the files FbParameter.cs and FbStatement.cs so that it is
possible to pass a System.DBNull.Value to the FbParameter.Value property in
order to enable support for NULL values in input parameters.

I included the diffs of the two files.

-- Joja

[Firebird-net-provider] ANN: Firebird .Net provider Alpha 3 is available for testing.

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

Hello:

Firebird .Net provider Alpha 3 is available for testing.


You can view the changelog at:

https://sourceforge.net/project/shownotes.php?release_id=121926


You can download binarys at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-Alpha3-Bin.zip?download

You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-Alpha3-Src.zip?download

You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-Alpha3-Doc.zip?download


CVS Tag:

NP1_0_Alpha3


Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: Implementation of isc_database_info function

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

Hello:

> Hello,
>
> I just implemented missing function isc_database_info from the
> GDS_Impl.cs: (with little modified declaration)


Thanks very much for this, i already upload the changes to the CVS, and 
i have added the database info constants to GDS.cs( i maintain the 
original declaration )

> I would like to make some helper function and properties for easy
> retrieving all information items too, but I don't know, if these should
> be members of the FBConnection class or we can create a separate class
> for them (e.g FBDatabaseInformation). Currently FB 1.0 has about 35
> usefull information items which can be retrieved from the engine using
> this system call.


Huummm. i think that can be better to have a separate file for this, you 
want to get all info otems or only some of it???, if i can help tell to 
me :)))

>
> Hope this code should be usefull for your project...

Yes it´s very useful :))), thanks very much.

> --
>   Tom Antony (t.a...@se...)



> P.S Sorry for my horrible english, I just learning...


I´m spanish and my english is very very bad :)))))

[Firebird-net-provider] Firebird .Net provider Alpha 2 is available for testing.

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

Hello:

Firebird .Net provider Alpha 2 is available for testing.


You can view the changelog at:

http://sourceforge.net/project/shownotes.php?release_id=118912


You can download binarys at:

http://prdownloads.sourceforge.net/firebird/Firebird-NetProvider-1.0_Alpha2.zip?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/Firebird-NetProvider-1.0_Alpha2_Source.zip?download


Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Test : Do not answer

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

This is a test

Re: [Firebird-net-provider] First Time

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

Hello:


The problem with the connection string in the Alpha 1 is that it´s Case 
sensitive ( Database != database ), this is solved in CVS sources, can 
you send your connection string??, i think this weekend would be 
released a Alpha2 version with all recent changes.



Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] First Time

[Dave V. d. E. <da...@gr...>]

Hi everyone,

I installed the .net provider, but can't get it to work with Firebird on =
a Linux server. Something about ConnectionString property not within the =
expected range or something.

Anyone else got it to work?

Dave

Re: [Firebird-net-provider] small change request to FbConnection.ConnectionString.set

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

Hello:

> If I use SQLServer for instance the parameters names of the 
> ConnectionString
> are not case sensitive.
> I think this way some casing typos could be avoid.
>
> what do you think?


Good idea, thanks :))

Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] small change request to FbConnection.ConnectionString.set

[Jorge S. <jh...@ne...>]

Hi,

I thing it would be a good idea to change the following code of the
"set"ConnectionString
from:


switch(values[0])
{
    case "Database":
        db = values[1];
        break;

    case "User":
        user = values[1];
        break;
    ....
}

to

switch(values[0].ToUpper())
{
    case "DATABASE":
        db = values[1];
        break;

    case "USER":
        user = values[1];
        break;
    ....
}

If I use SQLServer for instance the parameters names of the ConnectionString
are not case sensitive.
I think this way some casing typos could be avoid.

what do you think?

Bye

Jorge Sousa

[Firebird-net-provider] Error Setting ConnectionString

[Jorge S. <jh...@ne...>]

Hi,

Whenever I try to setup the ConnectionString I get an exception

Unhandled Exception: System.ArgumentException: Value does not fall within
the expected range.
   at FirebirdOrg.Data.FirebirdSql.FbConnection.set_ConnectionString(String
value)
   at TestApp.Main(String[] args) in
P:\Patches\Interbase\DotNetProvider\source\
TestApp\TestApp.cs:line 4

----------  Sample code-------------
01:  FbConnection conn = new FbConnection();

02:  //string database = "F:\\RID\\Data\\CIID_Desenv.gdb";
03:  string database = @"F:\RID\Data\CIID_Desenv.gdb";

04:  conn.ConnectionString = "Database=" + database +
";User=SYSDBA;Password=masterkey;Dialect=3;Server=kaneda;Charset=ISO8859_1";

05:  conn.Open();


So my problem right now is how to set the ConnectionString.

if I run the TestApp supplied in the ZIP everything runs fine.

Any hint?

I'll try to get the source from CVS and try to understand what am i doing
wrong.


Jorge Sousa

Re: [Firebird-net-provider] Examples?

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

Hello:

> 
> No, that source is only available from the project CVS.  I'm sure Carlos
> (the maintainer) will note this for the next build/release.
> 

:), if it´s of interest i can make a separate package with the source of 
the provider.



Best regards
Carlos Guzmán Álvarez
Vigo-España