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

[Firebird-net-provider] NET Provider, stored procedures

[Lee C. <lee...@ad...>]

Ok Carlos,

You're problably getting sick of me by now.  The method finally executed =
without an error, but it did not put any data into the database.  Also i =
try to call commit after the call to the database and it gives me an =
error saying its busy, open, fetching.

Lee

Re: [Firebird-net-provider] Connecting to embedded Firebird

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

Hello:

> do you have any plans to allow connection to the local embedded firebird
> server? 

No at this moment i will think on it for the future :)


> I know it is handled via the client DLL library and .net provider
> uses the network protocol, but it would be extremely helpful to be able to
> use the provider for both network and local connections.

You can connect to a local server using localhost as server.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Connecting to embedded Firebird

[Dan L. <tes...@at...>]

Carlos,

do you have any plans to allow connection to the local embedded firebird
server? I know it is handled via the client DLL library and .net provider
uses the network protocol, but it would be extremely helpful to be able to
use the provider for both network and local connections.

Re: [Firebird-net-provider] NET Provider (stored procedures)

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

Hello:

 > 0 is not valid, so i just embrace it within a string which is same thing?


The third parameters needs to be the SourceColumn not the value.


Try this:

command.Parameters.Add("@userloginname", FbType.VarChar).Value = "Lee";
command.Parameters.Add("@userloginpass", FbType.VarChar).Value = "Pass";
command.Parameters.Add("@userloginid", FbType.Integer).Value = 0;
command.Parameters.Add("@userprivilegeid", FbType.SmallInt).Value = 0;

command.Parameters["@userloginid"].Direction=ParameterDirection.Output;
command.Parameters["@userprivilegeid"].Direction=ParameterDirection.Output;




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] NET Provider (stored procedures)

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

Hello:

> FbParameterCollection param = new FbParameterCollection();

Huummm .... be careful with this that will be no more possible with 1.5
version of the Firebird .NET Data provider ( as in SqlClient provider ).


> param.Add( new FbParameter("@userloginname", 
> FirebirdSql.Data.Firebird.FbType.VarChar, "Lee"));
> 
> param.Add( new FbParameter("@userloginpass", 
> FirebirdSql.Data.Firebird.FbType.VarChar, "Pass"));
> 
> int result = sql.ExecuteNonQuery(connectionString, 
> CommandType.StoredProcedure, "LOGINUSER", param);
> 
> *What am I doing wrong?  Thank you!*


I can't test it now but try adding the output parameters too:

param.Add( new FbParameter("@userloginname", FbType.VarChar, "Lee"));
param.Add( new FbParameter("@userloginpass", FbType.VarChar, "Pass"));

param.Add( new FbParameter("@userloginid", FbType.Integer, 0));
param.Add( new FbParameter("@userprivilegeid", FbType.SmallInt, 0));


param[@userloginid].Direction = ParameterDirection.Output;
param[@userprivilegeid].Direction = ParameterDirection.Output;





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] NET Provider (stored procedures)

[Lee C. <lee...@ad...>]

I am having trouble getting a stored procedure to execute properly.  =
Below is my stored procedure definition and my code definition.

STOREDPROCEDURE =3D CREATE PROCEDURE LOGINUSER (
    USERLOGINNAME VARCHAR(255),
    USERLOGINPASS VARCHAR(255))
RETURNS (
    USERLOGINID INTEGER,
    USERPRIVILEGEID SMALLINT)

=20

public int ExecuteNonQuery(string aConnectionString, CommandType =
aCommandType, string aCommandText, FbParameterCollection aParams)

{

using (FbConnection connection =3D new FbConnection(aConnectionString))

{

connection.Open();


FbTransaction trans =3D connection.BeginTransaction();

FbCommand command =3D new FbCommand(aCommandText, connection, trans);

command.CommandType =3D aCommandType;

SetParameters(command.Parameters, aParams);

//command.Prepare();


return command.ExecuteNonQuery();

}=20

}



I call my code (ExecuteNonQuery) like this:

string connectionString =3D

"User=3DSYSDBA;" +

"Password=3Dmasterkey;" +

"Database=3Dc:\\program files\\Marathon\\Projects\\login.gdb;" +

"Server=3Dw2k-server;" +

"Port=3D3050;" +

"Dialect=3D3;" +

"Charset=3DNONE;" +

"Role=3D;" +

"Connection lifetime=3D15;" +

"Pooling=3Dtrue;" +

"Packet Size=3D8192";


SqlAccess sql =3D new SqlAccess();

FbParameterCollection param =3D new FbParameterCollection();

param.Add( new FbParameter("@userloginname", =
FirebirdSql.Data.Firebird.FbType.VarChar, "Lee"));

param.Add( new FbParameter("@userloginpass", =
FirebirdSql.Data.Firebird.FbType.VarChar, "Pass"));

int result =3D sql.ExecuteNonQuery(connectionString, =
CommandType.StoredProcedure, "LOGINUSER", param);

What am I doing wrong?  Thank you!

[Firebird-net-provider] NET Provider Pooling

[Lee C. <lee...@ad...>]

Carlos,

Just for your information, in your NET Provider docs it says that you do =
not currently support connection pooling.  Also I had a question about =
pooling.  In the docs it says FbConnection.Open() gets an "open" =
connection from the pool if available.  Now in one of the pooling =
examples shipped with the NET Provider it shows new connections being =
made, and then closed.  It says that closing the connection releases it =
back to the pool.  This would mean they are "closed" connections now.  =
How does this work?

Thanks,

Lee

Re: [Firebird-net-provider] Where to place documentation comments ( for 1.5 sources )

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

Hello:
> Although external files are more difficult to be maintained I prefer the
> second choice.
> This improve readibility of the code and allow other people to modify the
> documentation without working on source files.

Thanks for the answer, i was thinking to in make a mix :) putting the 
<summary> tags in the source code and <remarks> and <examples> in 
external files, but i have not take a decision yet :) i'm working now on 
database schema classes when i finish it i will start with documentation 
reorganization





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Where to place documentation comments ( for 1.5 sources )

[Alessandro P. <pet...@in...>]

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F1...@te......

> At this moment the 1.5 sources that i have in my local tree doesn't have
> documentation comments. i'm thinking where to place it:
>
> 1- In source files.
>
> 2- In external files ( as in 1.0 and 1.1 versions )
>

Although external files are more difficult to be maintained I prefer the
second choice.
This improve readibility of the code and allow other people to modify the
documentation without working on source files.

Just my 2c.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Unable to complete network request... It drives me mad.

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

Hello:

> my Configruation
> RH9 + Apache 2.0.46 + mono 0.25 + mod_mono 0.3.7 + Firebird 1.5 RC 3
> 
> I compiled the mod_mon with mono 0.25.
> 
> I worte a little aspx apllication that does it's job with mono's XSP Server.
> But I get an exception when I try to use it with apache + mod_mon.
> At the first lock it may be a problem of apache and/or mod_mon. I tried to
> verfy that it is "not" a problem of the Apache-Server and mod_mon it: I
> worte a simple TCP/IP-Echo-Server  (simple writes the received string to the
> console) and a aspx page wich sends a string to the EchoServer. It works.
> My question - why is the Firebird Provider unable to connect to the Firebird
> server? Any Idea?

Have you asked this at mono devel list ?? I think it's better place 
place for this question :) I'm going to try to install Apache and 
mod_mono later this week.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Unable to complete network request... It drives me mad.

[Soernt P. <soe...@t-...>]

Hello Carlos,

my Configruation
RH9 + Apache 2.0.46 + mono 0.25 + mod_mono 0.3.7 + Firebird 1.5 RC 3

I compiled the mod_mon with mono 0.25.

I worte a little aspx apllication that does it's job with mono's XSP Server.
But I get an exception when I try to use it with apache + mod_mon.
At the first lock it may be a problem of apache and/or mod_mon. I tried to
verfy that it is "not" a problem of the Apache-Server and mod_mon it: I
worte a simple TCP/IP-Echo-Server  (simple writes the received string to the
console) and a aspx page wich sends a string to the EchoServer. It works.
My question - why is the Firebird Provider unable to connect to the Firebird
server? Any Idea?

Best Regards

Sörnt

The Error Message:

FirebirdSql.Data.Firebird.FbException: Unable to complete network request to
host "192.168.2.1".
 ---> FirebirdSql.Data.INGDS.GDSException: Exception of type
FirebirdSql.Data.INGDS.GDSException was thrown.
in <0x002f7> 00 FirebirdSql.Data.NGDS.isc_db_handle_impl:Connect ()
in <0x0005e> 00 FirebirdSql.Data.NGDS.GDS:connect
(FirebirdSql.Data.NGDS.isc_db_handle_impl,FirebirdSql.Data.NGDS.AttachInfo)
in <0x000a3> 00 FirebirdSql.Data.NGDS.GDS:isc_attach_database
(FirebirdSql.Data.NGDS.AttachInfo,FirebirdSql.Data.INGDS.isc_db_handle,Fireb
irdSql.Data.INGDS.IParameterBuffer)
in <0x00050> 00 FirebirdSql.Data.NGDS.GDS:isc_attach_database
(string,FirebirdSql.Data.INGDS.isc_db_handle,FirebirdSql.Data.INGDS.IParamet
erBuffer)
in <0x00064> 00 FirebirdSql.Data.NGDS.GDS:isc_attach_database
(string,FirebirdSql.Data.INGDS.isc_db_handle,FirebirdSql.Data.INGDS.IParamet
erBuffer)
in <0x00438> 00 FirebirdSql.Data.Firebird.FbIscConnection:Open ()
in <0x00114> 00 FirebirdSql.Data.Firebird.FbConnection:Open ()
--- End of inner exception stack trace ---

in <0x0029d> 00 FirebirdSql.Data.Firebird.FbConnection:Open ()
in <0x00038> 00 atHome.bsAdHocQuery:get_Transaction ()
in <0x0002d> 00 atHome.bsAdHocQuery:InitCommand (string)
in <0x0007d> 00 atHome.jukebox:initNewSearch ()
in <0x0000a> 00 atHome.jukebox:btnSearch_Click (object,System.EventArgs)
in <0x0006b> 01 System.MulticastDelegate:invoke_void_object_EventArgs
(object,System.EventArgs)
in <0x000a0> 00 System.Web.UI.WebControls.Button:OnClick (System.EventArgs)
in <0x00054> 00
System.Web.UI.WebControls.Button:System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent (string)
in <0x00016> 00 System.Web.UI.Page:RaisePostBackEvent
(System.Web.UI.IPostBackEventHandler,string)
in <0x0004c> 00 System.Web.UI.Page:RaisePostBackEvents ()
in <0x0010d> 00 System.Web.UI.Page:ProcessRequest (System.Web.HttpContext)
in <0x001b9> 00 .ExecuteHandlerState:Execute ()
in <0x00052> 00 .StateMachine:ExecuteState (IStateHandler,bool&)

Re: [Firebird-net-provider] NET Provider remote connections

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

Hello:

> Thanks guys.  Is there a description of available connection string options
> in the firebird NET Provider?

You can download the documentation package here:

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

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.1-Alpha2-Doc.zip
	



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] NET Provider remote connections

[Lee C. <lee...@ad...>]

Thanks guys.  Is there a description of available connection string options
in the firebird NET Provider?

Thank you!

----- Original Message ----- 
From: "Carlos Guzman Alvarez" <car...@te...>
To: "Lee Connell" <lee...@ad...>
Cc: <fir...@li...>
Sent: Sunday, July 20, 2003 4:30 AM
Subject: Re: [Firebird-net-provider] NET Provider remote connections


> Hello:
>
> > *string connectionString =
> > "User=SYSDBA;" +
> > "Password=masterkey;" +
> > "Database=\\w2k-server\\c:\\program files\\firebird\\login.gdb;" +
> > "DataSource=192.168.0.11;" +
> > "Port=3050;" +
> > "Dialect=3;" +
> > "Charset=NONE;" +
> > "Role=;" +
> > "Connection lifetime=15;" +
> > "Pooling=true;" +
> > "Packet Size=8192";*
>
>
> Which version of the NET Provider are you using ??
>
> Try using:
>
> Database=c:\\program files\\firebird\\login.gdb;
> Server=192.168.0.11
>
>
> -- 
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: VM Ware
> With VMware you can run multiple operating systems on a single machine.
> WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the
> same time. Free trial click here: http://www.vmware.com/wl/offer/345/0
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] NET Provider remote connections

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

Hello:

> *string connectionString =
> "User=SYSDBA;" +
> "Password=masterkey;" +
> "Database=\\w2k-server\\c:\\program files\\firebird\\login.gdb;" +
> "DataSource=192.168.0.11;" +
> "Port=3050;" +
> "Dialect=3;" +
> "Charset=NONE;" +
> "Role=;" +
> "Connection lifetime=15;" +
> "Pooling=true;" +
> "Packet Size=8192";*


Which version of the NET Provider are you using ??

Try using:

Database=c:\\program files\\firebird\\login.gdb;
Server=192.168.0.11


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] NET Provider remote connections

[Lee C. <lee...@ad...>]

Carlos,

I am having a problem using the NET Provider for framework 1.1.  I =
cannot get it to connect to a remote database on my network.  It keeps =
telling me cannot connect to host "localhost".  Below is the parameters =
I am using, I tried all different combinations of assigning the remote =
host.  What am I doing wrong here?

string connectionString =3D
"User=3DSYSDBA;" +
"Password=3Dmasterkey;" +
"Database=3D\\w2k-server\\c:\\program files\\firebird\\login.gdb;" +
"DataSource=3D192.168.0.11;" +
"Port=3D3050;" +
"Dialect=3D3;" +
"Charset=3DNONE;" +
"Role=3D;" +
"Connection lifetime=3D15;" +
"Pooling=3Dtrue;" +
"Packet Size=3D8192";

Thanks,

Lee

[Firebird-net-provider] Where to place documentation comments ( for 1.5 sources )

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

Hello:


At this moment the 1.5 sources that i have in my local tree doesn't have 
documentation comments. i'm thinking where to place it:

	1- In source files.

	2- In external files ( as in 1.0 and 1.1 versions )


Both have godd and bad things, comments and ideas are wellcome!! :)





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Does Firebird provider support 6.x Open Source Interbase on W2K?

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

Hello:

> I am running a mixed environment of Classic W2K and .Net W2K on a 
> server.   Currently use the IBOLEDB driver to interface to Interbase 6.X 
> Open Source in Classic and .NET ODBC provider through EasySoft ODBC on 
> the .NET side.   Would like to replace the ODBC link with an Interbase 
> ADO.Net provider capability.  Can the Firebird.Net provider do this?

I have no tested it with interbase 6.x, but i think it will work 
thinking in that it works with Firebird 1.0






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Does Firebird provider support 6.x Open Source Interbase on W2K?

[stevyn d. <sr...@ya...>]

Hello:
 
I am running a mixed environment of Classic W2K and .Net W2K on a server.   Currently use the IBOLEDB driver to interface to Interbase 6.X Open Source in Classic and .NET ODBC provider through EasySoft ODBC on the .NET side.   Would like to replace the ODBC link with an Interbase ADO.Net provider capability.  Can the Firebird.Net provider do this?
 
regards,
stevyn


This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law.  If the reader of this message is not the intended you are hereby notified
that any dissemination, distribution or copying of this 
communication is strictly prohibited.

---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

Re: [Firebird-net-provider] Compiled from CVS Source...

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

Hello:

> you are right - the source was Version 1.0. Downloaded the 1.1
> ("branch-release-1-1") and compiled the Provider.
> surprise, surprise: now my test app is working - even with
> ".Parameters["XYZ"].Value". Thanks a lot

Actual sources in 1.0 branch have some changes that i have no tested yet 
:), i will test it before a new release if there are one for this branch  :)





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Compiled from CVS Source...

[Soernt P. <soe...@t-...>]

Hello Carlos,

you are right - the source was Version 1.0. Downloaded the 1.1
("branch-release-1-1") and compiled the Provider.
surprise, surprise: now my test app is working - even with
".Parameters["XYZ"].Value". Thanks a lot

Best regards

Sörnt


"Carlos Guzman Alvarez" <car...@te...> schrieb im Newsbeitrag
news:3F1...@te......
> Hello:
>
> > I attached my test application. The last line it displays at the console
is
> > "try open connection".
> > Source Version - hmmm. I am new to the cvs system. I installed
"TortoiseCVS"
> > connected to
> > ":pserver:ano...@cv...:/cvsroot/firebird" and
downloaded
> > the module "Net-Provider".
> > Which Source Version? - I thought the current 1.1 - right?
>
> Huummm i think you have downloaded the 1.0, you can get 1.1 fro the
> branch "branch-release-1-1".
>
>
> -- 
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: VM Ware
> With VMware you can run multiple operating systems on a single machine.
> WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the
> same time. Free trial click here: http://www.vmware.com/wl/offer/345/0
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] .NET Provider for .NET 1.1

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

Hello:

> I am sorry I was thinking incorrectly.  

No problem :).

> One more question, does the Connection.Open() method block if no connections
> are available in the pool and the max connections are in use in the pool?

At this moment there are no limit for the number of connections in the pool.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] .NET Provider for .NET 1.1

[Lee C. <lee...@ad...>]

Carlos,

I am sorry I was thinking incorrectly.  Some reason I was thinking you're
only allowed 1 connection per connection string when not using a pool :)
One more question, does the Connection.Open() method block if no connections
are available in the pool and the max connections are in use in the pool?

----- Original Message ----- 
From: "Carlos Guzman Alvarez" <car...@te...>
To: "Lee Connell" <lee...@ad...>
Cc: <fir...@li...>
Sent: Friday, July 18, 2003 2:55 AM
Subject: Re: [Firebird-net-provider] .NET Provider for .NET 1.1


> Hello:
>
> > HI Carlos,
> >
> > In a post ([ANN] Firebird .NET Data Provider 1.1 Alpha 2 ( for .NET 1.0
> > ) available for download.) you wrote
>  >
>  > You can download binarys ( for Windows and .NET Framework 1.1 ) at:
>
> It's a mistake, sorry :)
>
> > Also I noticed when i set 'Pooling=false' and creating 2 instances of
> > FDbConnection with the same connection string, then calling Open() on
> > both instances, it does not fire an error.  Isn't it suppose to fire an
> > error saying that the connection is already in use?  Is this a bug or ?
>
> Why ?? Are different instances and are dirfferent connections :)
>
>
> -- 
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>

Re: [Firebird-net-provider] Compiled from CVS Source...

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

Hello:

> I attached my test application. The last line it displays at the console is
> "try open connection".
> Source Version - hmmm. I am new to the cvs system. I installed "TortoiseCVS"
> connected to
> ":pserver:ano...@cv...:/cvsroot/firebird" and downloaded
> the module "Net-Provider".
> Which Source Version? - I thought the current 1.1 - right?

Huummm i think you have downloaded the 1.0, you can get 1.1 fro the 
branch "branch-release-1-1".


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Compiled from CVS Source...

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

Hello:

> Ups, I forgot the source code...

Thanks i will try to see it later today.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Compiled from CVS Source...

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

Hello:

> I attached my test application. The last line it displays at the console is
> "try open connection".
> Source Version - hmmm. I am new to the cvs system. I installed "TortoiseCVS"
> connected to
> ":pserver:ano...@cv...:/cvsroot/firebird" and downloaded
> the module "Net-Provider".
> Which Source Version? - I thought the current 1.1 - right?

Huummm i think you have downloaded the 1.0, you can get 1.1 fro the 
branch "branch-release-1-1".


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain