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

Re: [Firebird-net-provider] Problems using instclient.exe with msvcrt.dll - sorry

[Corneliu T. <cor...@ya...>]

Sorry my mistake ... I pick the wrong list, my intention was  to post the
message in firebird-suport list.

Thank you, for your time :-)

"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
> >  I spent 2 days to find what is the probleme why my program don't find
the
> > gds32.dll on a computer with win98 ... at that time I used FB 1.5 CR7.
If I
> > use the "stub" version of gds32.dll my prog don't start(runtime error
217
> > ar xxxx), if I rename fbclient.dll in gds32.dll  then library can't be
> > loaded...(err mesage is "gds32.dll not found"- it was in the right place
all
> > the time).
>
> Report this problem in the firebird devel or firebird-support lists (the
> .net data provider doesn't use the firebird client library ;))
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Convert BLOB to string

[martin <mc...@we...>]

Hi Carlos,

After making the change to the sp all worked well. Thank you for pointing
out that error.
I had IB EXPERT build the procedure and did not spot the difference in BLOB
SUB_TYPE.

cheers

martin

Re: [Firebird-net-provider] Convert BLOB to string

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

Hello:

> CREATE PROCEDURE SP_EE_GET_GROUP_DESCRIPTION (
>     ID INTEGER)
> RETURNS (
>     DISPLAY_DESCRIPTION BLOB SUB_TYPE 0 SEGMENT SIZE 80)
 > ...

Huummmm ... try to change this to :


CREATE PROCEDURE SP_EE_GET_GROUP_DESCRIPTION (
     ID INTEGER)
RETURNS (
     DISPLAY_DESCRIPTION BLOB SUB_TYPE 1 SEGMENT SIZE 80)
...

Re: [Firebird-net-provider] Convert BLOB to string

[Martin <mc...@we...>]

Hi,

I have now tried the C# code below using the cast that was provided.
I still get an exception of

    "Specified cast is not valid."

the C# code that I have used is shown below. The stored procedure that I am
using is shown below also.
There is definatly a record comming back. at least if I use a fbdatareader
and loop then the loop only ueses a single record.
I am not sure how to get the value back from a data reader.
It seems strange that the cast works for you and not me I am using RC2.

Thanks again for any advice.

cheers

martin.

try
   {
    Context.Trace.Warn("Page_Load","Entered function");
    FirebirdSql.Data.Firebird.FbConnection objConn = new
FirebirdSql.Data.Firebird.FbConnection();
    FirebirdSql.Data.Firebird.FbCommand objCMD = new
FirebirdSql.Data.Firebird.FbCommand();
    objConn.ConnectionString =
"Database=C:\\Inetpub\\wwwroot\\nz\\_database\\RESTOREDB.GDB;User=SYSDBA;Pas
sword=masterkey;Dialect=3;Server=localhost;Pooling=false;";
    objConn.Open();
    objCMD.Connection = objConn;
    Context.Trace.Write("Page_Load","connection is open");
    objCMD.CommandText = "SP_EE_GET_GROUP_DESCRIPTION";
       objCMD.CommandType = CommandType.StoredProcedure;
    FirebirdSql.Data.Firebird.FbParameter P1 = new
FirebirdSql.Data.Firebird.FbParameter();
       P1.Direction = ParameterDirection.Input;
       P1 = objCMD.Parameters.Add("@ID", 87);
    FirebirdSql.Data.Firebird.FbDataReader dr;
    dr = objCMD.ExecuteReader();
    string value = (string)objCMD.ExecuteScalar();
    objConn.Close();
    Context.Trace.Warn("Page_Load","Exited function");
   }
   catch (Exception ex)
   {
    Context.Trace.Warn("Excepetion thrown");
    Context.Trace.Write(ex.Message);
   }

store procedure text

CREATE PROCEDURE SP_EE_GET_GROUP_DESCRIPTION (
    ID INTEGER)
RETURNS (
    DISPLAY_DESCRIPTION BLOB SUB_TYPE 0 SEGMENT SIZE 80)
AS
BEGIN
  FOR
    SELECT EE_SP_NAME.DISPLAY_DESCRIPTION
    FROM EE_SP_SCHEDULE
       INNER JOIN EE_SP_NAME ON (EE_SP_SCHEDULE.EE_SP_NAME_ID =
EE_SP_NAME.ID)
    WHERE
       (
          (EE_SP_SCHEDULE.ID = :ID)
       )
    INTO :DISPLAY_DESCRIPTION
  DO
  BEGIN
    SUSPEND;
  END
END






""Martin"" <mc...@we...> wrote in message
news:bu79g2$38v$1...@ne......
> Hi,
>
> I am using .net provider 1.5 RC2.
> I am using vb.net code. The line that is throwing the exception is
>
> strDesciption = CType(objCMD.ExecuteScalar(), String)
>
> and the exception description is
>
> Cast from type 'Byte()' to type 'String' is not valid.
>
> I have checked that a record is being broght back. Perhaps I have the cast
> syntax wrong...
>
> The full code that I am using is below. If I comment the cat out and just
> use
>
> objCMD.ExecuteScalar()
>
> then all works fine.
>
> I am executing a stored procedure. and the full code that I am using is
> below for reference.
>
>
> cheers
>
> martin.
>
>
>
> Try
>             Dim objConn As FirebirdSql.Data.Firebird.FbConnection = New
> FirebirdSql.Data.Firebird.FbConnection
>             Dim objCMD As FirebirdSql.Data.Firebird.FbCommand = New
> FirebirdSql.Data.Firebird.FbCommand
>             Dim objTran As FirebirdSql.Data.Firebird.FbTransaction
>             objConn.ConnectionString =
>
System.Configuration.ConfigurationSettings.AppSettings("DbConnectionString")
>             objConn.Open()
>             objCMD.Connection = objConn
>             objTran = objConn.BeginTransaction()
>             objCMD.Transaction = objTran
>             objCMD.CommandText = "SP_EE_GET_GROUP_DESCRIPTION"
>             objCMD.CommandType = CommandType.StoredProcedure
>             Dim P1 As New FirebirdSql.Data.Firebird.FbParameter
>             P1.Direction = ParameterDirection.Input
>             P1 = objCMD.Parameters.Add("@ID", 87)
>             Dim strDesciption As String 'Variable to hold the description
> string that will be returned
>
>             strDesciption = CType(objCMD.ExecuteScalar(), String)
> <<<<<<<<<<<<<<<<<<<<---------  THROWS EXCEPTION
>
>
>             objCMD.Dispose()
>             objTran.Commit()
>             objTran.Dispose()
>             objConn.Close()
>         Catch ex As Exception
>             Trace.Write(ex.Message())
>         End Try
>
>
>
>
>
>
> "Carlos Guzmán Álvarez" <car...@te...> wrote in message
> news:400...@te......
> > Hello:
> >
> > > BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE
> >
> > It's correct, which version of the .NET Data Provider are you using ??
> >
> > I have tested this with 1.5, and runs fine:
> >
> > FbConnection connection = new FbConnection(connectionString);
> > connection.Open();
> >
> > string sql = "select clob_field from test where int_field = 1";
> >
> > FbCommand command = new FbCommand(sql, connection);
> >
> > string value = (string)command.ExecuteScalar();
> >
> > connection.Close();
> >
> >
> >
> >
> > --
> > Best regards
> >
> > Carlos Guzmán Álvarez
> > Vigo-Spain
> >
> >
> >
> > -------------------------------------------------------
> > The SF.Net email is sponsored by EclipseCon 2004
> > Premiere Conference on Open Tools Development and Integration
> > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> > http://www.eclipsecon.org/osdn
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
>
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Convert BLOB to string

[Martin <mc...@we...>]

Hi,

I am using .net provider 1.5 RC2.
I am using vb.net code. The line that is throwing the exception is

strDesciption = CType(objCMD.ExecuteScalar(), String)

and the exception description is

Cast from type 'Byte()' to type 'String' is not valid.

I have checked that a record is being broght back. Perhaps I have the cast
syntax wrong...

The full code that I am using is below. If I comment the cat out and just
use

objCMD.ExecuteScalar()

then all works fine.

I am executing a stored procedure. and the full code that I am using is
below for reference.


cheers

martin.



Try
            Dim objConn As FirebirdSql.Data.Firebird.FbConnection = New
FirebirdSql.Data.Firebird.FbConnection
            Dim objCMD As FirebirdSql.Data.Firebird.FbCommand = New
FirebirdSql.Data.Firebird.FbCommand
            Dim objTran As FirebirdSql.Data.Firebird.FbTransaction
            objConn.ConnectionString =
System.Configuration.ConfigurationSettings.AppSettings("DbConnectionString")
            objConn.Open()
            objCMD.Connection = objConn
            objTran = objConn.BeginTransaction()
            objCMD.Transaction = objTran
            objCMD.CommandText = "SP_EE_GET_GROUP_DESCRIPTION"
            objCMD.CommandType = CommandType.StoredProcedure
            Dim P1 As New FirebirdSql.Data.Firebird.FbParameter
            P1.Direction = ParameterDirection.Input
            P1 = objCMD.Parameters.Add("@ID", 87)
            Dim strDesciption As String 'Variable to hold the description
string that will be returned

            strDesciption = CType(objCMD.ExecuteScalar(), String)
<<<<<<<<<<<<<<<<<<<<---------  THROWS EXCEPTION


            objCMD.Dispose()
            objTran.Commit()
            objTran.Dispose()
            objConn.Close()
        Catch ex As Exception
            Trace.Write(ex.Message())
        End Try






"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
> > BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE
>
> It's correct, which version of the .NET Data Provider are you using ??
>
> I have tested this with 1.5, and runs fine:
>
> FbConnection connection = new FbConnection(connectionString);
> connection.Open();
>
> string sql = "select clob_field from test where int_field = 1";
>
> FbCommand command = new FbCommand(sql, connection);
>
> string value = (string)command.ExecuteScalar();
>
> connection.Close();
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Convert BLOB to string

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

Hello:

> BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE

It's correct, which version of the .NET Data Provider are you using ??

I have tested this with 1.5, and runs fine:

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

string sql = "select clob_field from test where int_field = 1";

FbCommand command = new FbCommand(sql, connection);

string value = (string)command.ExecuteScalar();

connection.Close();




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Convert BLOB to string

[Martin <mc...@we...>]

Thanks for that, I am a little confusesd.
I'm not sure what the sub type has to do with it. Does this mean that I can
retrive the data directly if  it has a subtype of text??

I have never used the "Encoding" classes before. Do these classes belong to
.net framework or firebirdsql.
I would appreciate knowing the full namespace of the classes to use then I
can start looking through the documentation.
Any pointers on articles that may be helpful in doing such a thing is
appreciated  (it is totally new to me.)



just for back ground this is the create statement for my table

CREATE TABLE EE_SP_NAME (
    ID                   PK_ID NOT NULL,
    PROCEDURE_NAME       VC80 NOT NULL,
    DISPLAY_TEXT         VC80 NOT NULL,
    DISPLAY_DESCRIPTION  BLOB_TEXT_DATA NOT NULL,
    CREATED              TIMESTAMP_NOW NOT NULL
);

the definition of the blob text domain is

BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE

cheers

martin



"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
> > I am retrieving a BLOB field from a firebird db via .net provider 1.5
> >
> > I am using ExecuteScalar() to get the first single result from execution
of
> > the stored procudure I am trying to retrieve the value like so
>
> It's a blob field with subtype text ?? if not the provider will return
> an array of bytes and you will need to convert it to an string using the
> Encoding classes.
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Convert BLOB to string

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

Hello:

> I am retrieving a BLOB field from a firebird db via .net provider 1.5
> 
> I am using ExecuteScalar() to get the first single result from execution of
> the stored procudure I am trying to retrieve the value like so

It's a blob field with subtype text ?? if not the provider will return 
an array of bytes and you will need to convert it to an string using the 
Encoding classes.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Convert BLOB to string

[Martin <mc...@we...>]

Hi,

I am retrieving a BLOB field from a firebird db via .net provider 1.5

I am using ExecuteScalar() to get the first single result from execution of
the stored procudure
I am trying to retrieve the value like so

Dim strDesciption As Byte
strDesciption = objCMD.ExecuteScalar()   <---  this line throws an
exception..

I am then trying to put the result into a string -- but execution does not
get this far so  don't know if it is correct

Return strDesciption.ToString()

I am getting a "System.InvalidCastException"  (produced by the
ExecuteScalar() line)

message "Cast from type 'Byte()' to type 'Byte' is not valid."

I would appreciate any advice on how to avoid this error and be able to
return the string from the blob field my dot net code as a string

many thanks in advance.

martin.

Re: [Firebird-net-provider] Problems using instclient.exe with msvcrt.dll ver. 5.00.7128

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

Hello:
>  I spent 2 days to find what is the probleme why my program don't find the
> gds32.dll on a computer with win98 ... at that time I used FB 1.5 CR7. If I
> use the "stub" version of gds32.dll my prog don't start(runtime error 217
> ar xxxx), if I rename fbclient.dll in gds32.dll  then library can't be
> loaded...(err mesage is "gds32.dll not found"- it was in the right place all
> the time).

Report this problem in the firebird devel or firebird-support lists (the 
.net data provider doesn't use the firebird client library ;))





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Problems using instclient.exe with msvcrt.dll ver. 5.00.7128

[Corneliu T. <cor...@ya...>]

Hello,

 I don't know if this is the right place to report this kind of problem....
Installation problem.

 I'm trying to install  Fb client on a sistem with win98 (not win98 SE).
instclient.exe generate an error in module msvcrt.dll, but in win98 SE not.
So I replace msvcrt.dll version from win98 with win98SE and the problem
disappear.
 It seems that instclient.exe from the FB 1.5 RC8 will not work with
msvcrt.dll version 5.00.7128
    but with msvcrt.dll ver 6.10.9359.0 will work well.

 I spent 2 days to find what is the probleme why my program don't find the
gds32.dll on a computer with win98 ... at that time I used FB 1.5 CR7. If I
use the "stub" version of gds32.dll my prog don't start(runtime error 217
ar xxxx), if I rename fbclient.dll in gds32.dll  then library can't be
loaded...(err mesage is "gds32.dll not found"- it was in the right place all
the time).

I hope this bug was not reported until now, and other users will know how to
deal that type of problem.


Corneliu T.

Re: [Firebird-net-provider] error on opening FBConnection

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

Hello:

> I am new to ASP.NET and the Firebird Data Provider.   I have Win2k, MS 
> .NET 1.1 runtime and sdk, Firebird 1.5 and Firebird .NET Data Provider 
> 1.5 installed  and I am trying to access my Firebird database from an 
> ASP.NET page but I am not able to make a connection. 

Huummm i don't know what can be the problem :) , can you make a test 
using a Console Application ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] error on opening FBConnection

[Dan B. <Br...@YA...>]

I am new to ASP.NET and the Firebird Data Provider.   I have Win2k, MS =
.NET 1.1 runtime and sdk, Firebird 1.5 and Firebird .NET Data Provider =
1.5 installed  and I am trying to access my Firebird database from an =
ASP.NET page but I am not able to make a connection. =20

Is there are more setup/configuration documentation/examples available =
other than what came with the 1.5 provider?

I get the following error even when accessing the sample pages =
(VBNetExample.aspx, CSharpExample.aspx) that came with the 1.5 data =
provider:
An operation on a socket could not be performed because the system =
lacked sufficient buffer space or because a queue was full=20
Description: An unhandled exception occurred during the execution of the =
current web request. Please review the stack trace for more information =
about the error and where it originated in the code.=20

Exception Details: System.Net.Sockets.SocketException: An operation on a =
socket could not be performed because the system lacked sufficient =
buffer space or because a queue was full

Source Error:=20

Line 24:    =20
Line 25:         myConnection =3D new FbConnection(myConnectionString)
Line 26:         myConnection.Open()
Line 27:    =20
Line 28:         myTxn =3D myConnection.BeginTransaction()=20

Source File: c:\inetpub\wwwroot\BG\VBNetExample.aspx    Line: 26=20

Stack Trace:=20

[SocketException (0x2747): An operation on a socket could not be =
performed because the system lacked sufficient buffer space or because a =
queue was full]
   System.Net.Sockets.Socket.InitializeSockets() +735
   System.Net.Sockets.Socket..cctor() +19

[TypeInitializationException: The type initializer for =
"System.Net.Sockets.Socket" threw an exception.]
   System.Net.Sockets.Socket.InitializeSockets() +0
   System.Net.Dns..cctor() +53

[TypeInitializationException: The type initializer for "System.Net.Dns" =
threw an exception.]
   System.Net.Dns.Resolve(String hostName) +0
   FirebirdSql.Data.Firebird.Gds.GdsAttachment.Connect() +35
   FirebirdSql.Data.Firebird.Gds.GdsDbAttachment.Attach() +45
   FirebirdSql.Data.Firebird.FbDbConnection.Connect() +63
   FirebirdSql.Data.Firebird.FbConnection.Open() +191
   ASP.VBNETExample_aspx.Connect() in =
c:\inetpub\wwwroot\BG\VBNetExample.aspx:26
   ASP.VBNETExample_aspx.Page_Load(Object Sender, EventArgs E) in =
c:\inetpub\wwwroot\BG\VBNetExample.aspx:36
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +731
=20



Thanks,

Dan Brown
YADA Systems, Inc.

Re: [Firebird-net-provider] connet to embedded server

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

Hello:

> How can you create a database with the netprovider 1.6 is that possible??

Using FbConnection.CreateDatabase method.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] connet to embedded server

[Sander B. <sbo...@es...>]

How can you create a database with the netprovider 1.6 is that possible??



"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
>  > And must I run the fbserver.exe when I try 2 access
>  > the database? Or just don't need that anymore?
>
>
> Sorry i left this without answer in my previous email
> You need to download the Firebird Embedded Server:
>
>
http://prdownloads.sourceforge.net/firebird/Firebird-1.5.0.4201_RC8_embed_win32.zip?download
>
> Using ServerType=1 in the connection string the provider will use the
> fbembed.dll (you need to have it in the path), if you use ServerType=0
> the provider will try to work against a Super or Classic Server
> installation.
>
>
>
>
> -- 
> Best regards
>
> Carlos Guzmán álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] connet to embedded server

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

Hello:

 > And must I run the fbserver.exe when I try 2 access
 > the database? Or just don't need that anymore?


Sorry i left this without answer in my previous email
You need to download the Firebird Embedded Server:

http://prdownloads.sourceforge.net/firebird/Firebird-1.5.0.4201_RC8_embed_win32.zip?download

Using ServerType=1 in the connection string the provider will use the 
fbembed.dll (you need to have it in the path), if you use ServerType=0 
the provider will try to work against a Super or Classic Server 
installation.




-- 
Best regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] connet to embedded server

[Sander B. <sbo...@es...>]

That is it?

My current connection string looks like this

"User=SYSDBA;Password=maserkey;Dialect=3;Server=localhost;Pooling=False;";

but server=localhost in it what must I do with that?? And must I run the
fbserver.exe when I try 2 access the database? Or just don't need that
anymore?

Sander



"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
> > i have got the newest firebird (from the sf website) and compiled etc
etc. I
> > download .netprovider 1.6 and now i wanna connect 2 a database with
> > .netprovider 1.6.
> > There is no new manual right available for 1.6 so that is way i'm asking
it
> > hehe.
> > Can somebody show me some source of connection string retrieving data
from a
> > embedded firebird server. i'm coding in C#
>
> You need to add to the connection string:
>
> ServerType=1
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] connet to embedded server

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

Hello:

> i have got the newest firebird (from the sf website) and compiled etc etc. I
> download .netprovider 1.6 and now i wanna connect 2 a database with
> .netprovider 1.6.
> There is no new manual right available for 1.6 so that is way i'm asking it
> hehe.
> Can somebody show me some source of connection string retrieving data from a
> embedded firebird server. i'm coding in C#

You need to add to the connection string:

	ServerType=1



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] connet to embedded server

[Sander B. <sbo...@es...>]

hello,

i have got the newest firebird (from the sf website) and compiled etc etc. I
download .netprovider 1.6 and now i wanna connect 2 a database with
.netprovider 1.6.
There is no new manual right available for 1.6 so that is way i'm asking it
hehe.
Can somebody show me some source of connection string retrieving data from a
embedded firebird server. i'm coding in C#

Thx!

Sander

Re: [Firebird-net-provider] embedded server

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

Hello:

> Is it correct that the embedded server only accepts one connection?
> How will this work with .NET Provider connection pooling?

I have done a little test on this, opening 10 connections without 
problem, the code (i think it's correct, the connection string is always 
the same):

FbConnection[] connections = new FbConnection[10];

for (int i = 0; i < connections.Length; i++)
{
	connections[i] = new FbConnection(connectionString);
	connections[i].Open();
}

for (int i = 0; i < connections.Length; i++)
{
	connections[i].Close();
}



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] embedded server

[Tom <ja...@ma...>]

Is it correct that the embedded server only accepts one connection?

How will this work with .NET Provider connection pooling?


Regards
Thomas

[Firebird-net-provider] [ANN] Firebird .NET Data Provider team has a new member

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

Hello:

Abel Eduardo Pereira (from Portugal) has joined to the Firebird .NET 
Data Provider team.

His first contribution is an excellent SQL Script parser and executor 
that will replace the actual FbScript class in the 1.6 sources (Sources 
are in the CVS yet).



--
Best Regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] Select statements and transactions

[Martin <mc...@we...>]

Hi,

I have found that if I run at least 1 call to the database without the
"pooling=false" addition to the connection string then locking of the .gdb
file will occur and I will not be able to delete the file after running my
dot net code.

however as soon as I chage the connection string in web.config to include
the "pooling=false" in the connection string and run a query, agaist the
previously locked file, then the connection pool seems to be cleared.
I not sure if this is because the dot.net project has been recompiled
becasue of the change to web.config or not.

anyway, my problem is solved, but if you do any "cleanPool" functionality to
"fbConnection" then I for one would be interested in using it.

cheers

martin.


"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
> > This has worked brilliantly, I am now able to delete the file after
running
> > my dot net code. Thank you.
>
> :)
>
> > This particular problem has brought up the issue of the benefits of
using
> > connection pooling on a firebird db.
> > If say I had a busy website using a firebird db as a back end, that was
> > using connection pooling and was visited by a fair amont of people.
>
> Huuummmm a thing you can test is to try to use the Connection Lifetime
> parameter in the connection string, for see if it can help.
>
> > Then supposing I needed to take the website down for a short period of
time,
> > say for routine maintenance, I would have a whole pile of open
connections
> > in my database.
> > I guess that I would need to close the connections gracefully, I'm not
sure
> > how I would do this.
>
> Huummm you can try to create a static method in FbConnection, called for
> example CleanPool, for clean all the connections in the pool, if there
> are more people interested on this i can make it in the provider sources
> :), i can try to review too if there are anything arround this in the
> .NET Framework 1.1 and 1.2 documentation.
>
> > This situation could arise if say a problem arose on my production site
and
> > I wanted to shut my production site down for a while and copy the
production
> > database to my development server, Firstly stoping the firebird service
on
> > the production server. Stopping the service would report "Overlapping
I/O
> > operation."
>
> Huummm if you want to do backups you can do that without make a shutdown
> of the server, but i don't know if you mean this type of maintenance
> tasks :)
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Select statements and transactions

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

Hello:

> This has worked brilliantly, I am now able to delete the file after running
> my dot net code. Thank you.

:)

> This particular problem has brought up the issue of the benefits of using
> connection pooling on a firebird db.
> If say I had a busy website using a firebird db as a back end, that was
> using connection pooling and was visited by a fair amont of people.

Huuummmm a thing you can test is to try to use the Connection Lifetime 
parameter in the connection string, for see if it can help.

> Then supposing I needed to take the website down for a short period of time,
> say for routine maintenance, I would have a whole pile of open connections
> in my database.
> I guess that I would need to close the connections gracefully, I'm not sure
> how I would do this.

Huummm you can try to create a static method in FbConnection, called for 
example CleanPool, for clean all the connections in the pool, if there 
are more people interested on this i can make it in the provider sources 
:), i can try to review too if there are anything arround this in the 
.NET Framework 1.1 and 1.2 documentation.

> This situation could arise if say a problem arose on my production site and
> I wanted to shut my production site down for a while and copy the production
> database to my development server, Firstly stoping the firebird service on
> the production server. Stopping the service would report "Overlapping I/O
> operation."

Huummm if you want to do backups you can do that without make a shutdown 
of the server, but i don't know if you mean this type of maintenance 
tasks :)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Select statements and transactions

[Martin <mc...@we...>]

Hi Carlos,

This has worked brilliantly, I am now able to delete the file after running
my dot net code. Thank you.


This particular problem has brought up the issue of the benefits of using
connection pooling on a firebird db.
If say I had a busy website using a firebird db as a back end, that was
using connection pooling and was visited by a fair amont of people.
Then supposing I needed to take the website down for a short period of time,
say for routine maintenance, I would have a whole pile of open connections
in my database.
I guess that I would need to close the connections gracefully, I'm not sure
how I would do this.

This situation could arise if say a problem arose on my production site and
I wanted to shut my production site down for a while and copy the production
database to my development server, Firstly stoping the firebird service on
the production server. Stopping the service would report "Overlapping I/O
operation."

anyway, I know the above is not a .net question and probably hightlights my
limited understanding of firebird, it's just got me wondering, that all.

Thanks agian for helping me out.

cheers

martin.





"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
> > Is connection pooling just turned on in the connection string or is
there a
> > .net setting to do this.
>
> This is done using the connection string:
>
> Pooling=false
>
> Try this and comment the results please :):
>
> <add key="DbConnectionString"
>
value="Database=C:\\Inetpub\\wwwroot\\NZ\\_database\\RESTOREDB.GDB;User=SYSD
BA;
> Password=masterkey;Dialect=3;Server=localhost;Pooling=false"/>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>