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

Re: [Firebird-net-provider] exception by fb1.5 win beta4

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

Hello:

> string myInsertQuery = "INSERT INTO PROJECT(proj_id, proj_name, product)
> Values('test', '.Net Provider', 'N/A')";

proj_id field accepts only uppercase values try using:

string myInsertQuery = "INSERT INTO PROJECT(proj_id, proj_name, product)
Values('TEST', '.Net Provider', 'N/A')";




-- 
Un saludo

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] exception by fb1.5 win beta4

[Karl S. <web...@st...>]

Hello all,

Konfiguration:
fb 1.5 win beta4
latest .net-provider
.net sdk 1.1



the following sourcecode works fine for the select-statement, but makes an
exception at the insert-statement. With firebird 1.02, the code went fine

Sure, there's no 'test' in the table

Thanks,
KS

using System;

using FirebirdSql.Data.Firebird;

class MainClass

{

public static void Main(string[] args)

{


// If the connection string is null, use a default.

string myConnectionString =
"Database=C:\Employee.gdb;User=SYSDBA;Password=masterkey;Dialect=3;Server=lo
calhost";

FbConnection myConn = new FbConnection(myConnectionString);

myConn.Open();



string mySelectQuery = "SELECT * FROM employee";

FbTransaction mynewTxn = myConn.BeginTransaction();

FbCommand myCommand = new FbCommand(mySelectQuery, myConn, mynewTxn);


// myConn.Open();

FbDataReader myReader = myCommand.ExecuteReader();


try

{

while (myReader.Read())

{

Console.WriteLine(myReader.GetValue(0) + " " + myReader.GetValue(2));

}

}

finally

{

// always call Close when done reading.

myReader.Close();

}

string myInsertQuery = "INSERT INTO PROJECT(proj_id, proj_name, product)
Values('test', '.Net Provider', 'N/A')";

FbCommand myFbCommand = new FbCommand(myInsertQuery, myConn, mynewTxn);


int result = myFbCommand.ExecuteNonQuery();

mynewTxn.Commit;

myConn.Close();



Console.WriteLine(result);

}

}


Unhandled Exception: FirebirdSql.Data.Firebird.FbException: validation error
for
 column PROJ_ID, value "test "
 ---> FirebirdSql.Data.INGDS.GDSException: Exception of type
FirebirdSql.Data.IN
GDS.GDSException was thrown.
   at FirebirdSql.Data.Firebird.FbStatement.Execute()
   at FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery()
   --- End of inner exception stack trace ---
   at FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery()
   at MainClass.Main(String[] args) in c:\Dokumente und
Einstellungen\Administra
tor\Eigene Dateien\SharpDevelop Projects\hjghj\Main.cs:line 47
Drücken Sie eine beliebige Taste . . .

RE: [Firebird-net-provider] interbase user physical connection not disconnecting.

[Andrew G. <ag...@jc...>]

Thanks.
Pooling=3DFalse;=20
In the connectionstring did the trick.

:)
Andrew.

-----Original Message-----
From: Carlos Guzman Alvarez [mailto:car...@te...]=20
Sent: Friday, March 14, 2003 11:10
To: Andrew Goodall
Cc: fir...@li...
Subject: Re: [Firebird-net-provider] interbase user physical connection not
disconnecting.


Hello:

> Thank you all for the previous help you have provided - you have been a=
=20
> real help getting me up and going. I can now select, update, insert, etc=
=20
> as desired from my asp.net webform to my interbase db.
>=20=20
> My question is concerning the physical disconnecting from the database.=
=20
> In my code I make sure I dispose the Transaction, Command and Close the=
=20
> Connection.
> Everything appears to be fine, I receive no exceptions on the dotnet=20
> side. But when I go to Interbase I view the connected users it still=20
> shows the user connected.
> The user will only disconnect after I recycle IIS 5.0.
>=20=20
> Any ideas why the user will not disconnect from the database?
> Is this related to connection pooling and/or garbage collection in dotnet?
>=20=20
> Below are snipets of VB.Net code examples I use to connect and disconnect.


This seems to be a problem with Connection Pooling, you can set in=20
connection string the Connection Pooling off, default is on, or change=20
the Connection Lifetime, default is 0.







--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain

"No tengo dones especiales.S=F3lo soy apasionadamente curioso"
Albert Einstein, cient=EDfico.

Re: [Firebird-net-provider] interbase user physical connection not disconnecting.

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

Hello:

> Thank you all for the previous help you have provided - you have been a 
> real help getting me up and going. I can now select, update, insert, etc 
> as desired from my asp.net webform to my interbase db.
>  
> My question is concerning the physical disconnecting from the database. 
> In my code I make sure I dispose the Transaction, Command and Close the 
> Connection.
> Everything appears to be fine, I receive no exceptions on the dotnet 
> side. But when I go to Interbase I view the connected users it still 
> shows the user connected.
> The user will only disconnect after I recycle IIS 5.0.
>  
> Any ideas why the user will not disconnect from the database?
> Is this related to connection pooling and/or garbage collection in dotnet?
>  
> Below are snipets of VB.Net code examples I use to connect and disconnect.


This seems to be a problem with Connection Pooling, you can set in 
connection string the Connection Pooling off, default is on, or change 
the Connection Lifetime, default is 0.







-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] interbase user physical connection not disconnecting.

[Andrew G. <ag...@jc...>]

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

Re: [Firebird-net-provider] Object reference not set to an instance of

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

Hello:

>What i want to ask is on linux the net provider is working on Mono ?
>
>  
>
Well, i don't test the latest sources with it , because i have no time 
for it, but i will test it before release RC 1, but it needs to work :)

>> There is a documentation on howto use it  ?

No but there are a makefile for build the sources.





Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Object reference not set to an instance of

[Marius P. A. <ma...@re...>]

surprise surprise :) only with SQ[HeL]L Server and ole db providers ... 

What i want to ask is on linux the net provider is working on Mono ?
There is a documentation on howto use it  ?


On Fri, 14 Mar 2003 10:16:36 +0800
Dick Chiang <di...@me...> wrote:

> I don't think you can.  Those wizards seem to only work with the 
> built-in Microsoft SQL Server and OLE DB Providers.

Re: [Firebird-net-provider] Object reference not set to an instance of

[Dick C. <di...@me...>]

I don't think you can.  Those wizards seem to only work with the 
built-in Microsoft SQL Server and OLE DB Providers.


Bill Todd wrote:
> 
> On Thu, 13 Mar 2003 01:23:26 +0000 (UTC), rc...@mo... (Dick
> Chiang) wrote:
> 
> 
>>I think it would help if you provide the code snippet that performs the
>>operation below.  Also, I have found no compelling advantage of putting
>>the Fbxxxxxx on the Toolbox and dropping them onto the form during
>>design time.  I think using the Fbxxxxxx commands programmatically is
>>more flexible and gives you more control.
> 
> 
> There is no code. The steps I described were all performed in the
> Visual Studio IDE. If you create the adapter and command components in
> code how do you use the Create DataSet wizard to create a typed
> DataSet?
> --
> Bill
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open! 
> Get cracking and register here for some mind boggling fun and 
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] example from help functions not

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

Hello:

> BTW, exist there any example code for newbies like me, how to work with
> firebird and the .net-provider.
> That would be a big help people like me :-)


There are some little examples in CVS, see:

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/firebird/Net-Provider/examples/


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] example from help functions not

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

Hello:

> BTW, exist there any example code for newbies like me, how to work with
> firebird and the .net-provider.
> That would be a big help people like me :-)


See in CVS at:

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/firebird/Net-Provider/examples/


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] example from help functions not

[Karl S. <web...@st...>]

"Carlos Guzman Alvarez" <car...@te...> schrieb im Newsbeitrag
news:3E7...@te......
> Hello:
>
> You only need to add a commit before close connection:
>

Yes, that was it.

Thanks, KS

PS: Teaching database in school, why wasn't it myself, you could give the
answer ;-)


BTW, exist there any example code for newbies like me, how to work with
firebird and the .net-provider.
That would be a big help people like me :-)

Re: [Firebird-net-provider] example from help functions not

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

Hello:

You only need to add a commit before close connection:

public void InsertRow(string myConnectionString)
{
	//	If the connection string is null, use a default.
	if(myConnectionString == "")
	{
		myConnectionString = "Database=C:\\PROGRAM
FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;User=SYSDBA;Password=masterkey;Diale
ct=3;Server=localhost";
	}

	FbConnection myConn = new FbConnection(myConnectionString);

	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();

	myTxn.Commit();	<---
	myConn.Close();
}







-- 
Best Regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] example from help functions not

[Karl S. <web...@st...>]

Hi all,

as a newbie to .net
i installed the .net sdk from microsoft, your latest .net-provider and
sharpdevelop.
Firebird is 1.02

Trying some minimalistic examples from your help-file, i have a problem with
the insert statement.

select-example works fine, but when I try this insert-example, there's  just
nothing in the database. No new recordset, nothing.
The example works without any error, when i invoke it.

Any hints


Thanks

KS

public void InsertRow(string myConnectionString)
{
	//	If the connection string is null, use a default.
	if(myConnectionString == "")
	{
		myConnectionString = "Database=C:\\PROGRAM
FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;User=SYSDBA;Password=masterkey;Diale
ct=3;Server=localhost";
	}

	FbConnection myConn = new FbConnection(myConnectionString);

	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();
}

Re: [Firebird-net-provider] Object reference not set to an instance of

[Bill T. <bi...@no...>]

On Thu, 13 Mar 2003 01:23:26 +0000 (UTC), rc...@mo... (Dick
Chiang) wrote:

>I think it would help if you provide the code snippet that performs the
>operation below.  Also, I have found no compelling advantage of putting
>the Fbxxxxxx on the Toolbox and dropping them onto the form during
>design time.  I think using the Fbxxxxxx commands programmatically is
>more flexible and gives you more control.

There is no code. The steps I described were all performed in the
Visual Studio IDE. If you create the adapter and command components in
code how do you use the Create DataSet wizard to create a typed
DataSet?
--
Bill

Re: [Firebird-net-provider] Cannot install provider in Visual Studio .NET

[Bill T. <bi...@no...>]

The following worked for me.

Right click the Data panel and choose Customize Toolbox. Click the
.NET tab then click the browse button. Browse to the Firebird provider
directory and select the DLL.


--
Bill

[Firebird-net-provider] Cannot install provider in Visual Studio .NET

[Fabiano C. <fa...@da...>]

I have installed the Firebird managed provider without error. However,
I cannot get the components to appear on the Data panel in Visual
Studio .NET. Can someone point me to some instructions?

Re: [Firebird-net-provider] Object reference not set to an instance of an object.

[Dick C. <rc...@mo...>]

I think it would help if you provide the code snippet that performs the
operation below.  Also, I have found no compelling advantage of putting
the Fbxxxxxx on the Toolbox and dropping them onto the form during
design time.  I think using the Fbxxxxxx commands programmatically is
more flexible and gives you more control.

Dick


Bill Todd wrote:
> 
> Using Visual Studio .NET I have a C# project with a FbConnection,
> FbDataAdapter and FbCommand added to a form at design time. The
> connection is to the IB 7 sample EMPLOYEE.IB database. The connection
> opens without error.
> 
> The FbCommand.CommandText property contains the message "Object
> reference not set to an instance of an object." and I cannot enter a
> SELECT statement. The Connection property is set to the FbConnection
> and CommandType is set to Text.
> 
> If I attempt to open the CommandText property editor I get a very long
> error message. I can post a screen shot if it helps.
> 
> Any suggestions?
> 
> Thanks,
> --
> Bill
> 
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Object reference not set to an instance of an object.

[Bill T. <bi...@no...>]

Using Visual Studio .NET I have a C# project with a FbConnection,
FbDataAdapter and FbCommand added to a form at design time. The
connection is to the IB 7 sample EMPLOYEE.IB database. The connection
opens without error.

The FbCommand.CommandText property contains the message "Object
reference not set to an instance of an object." and I cannot enter a
SELECT statement. The Connection property is set to the FbConnection
and CommandType is set to Text.

If I attempt to open the CommandText property editor I get a very long
error message. I can post a screen shot if it helps.

Any suggestions?

Thanks,
--
Bill

Cancel "[Firebird-net-provider] Cannot install provider in Visual Studio"

[<bi...@no...>]

--
Bill

[Firebird-net-provider] Cannot install provider in Visual Studio

[Bill T. <bi...@no...>]

I have installed the Firebird managed provider without error. However,
I cannot get the components to appear on the Data panel in Visual
Studio .NET. Can someone point me to some instructions?

Thanks,

Bill
--
Bill

Re: [Firebird-net-provider] aspxDelphi.net STORE runing on Interbase / Firebird (Delphi + asp.net)!

[Zarko G. <http://delphi.about.com> <del...@ab...>]

Hm,

Because the whole process took cca 2 months of my time... :(

BUT, I'll help as much as I can if somenone has some specific answers!

.............................................
Zarko Gajic, webmaster to
aspxDelphi.net - bringing the world of
ASP.NET to Delphi developers
http://www.aspxdelphi.net
email: web...@as...
.............................................
""Rob Segerink"" <seg...@no...> wrote in message
news:b4mt2s$j8i$1...@ne......
> Great! But why not give the source away
> just like to C# and Vb versions of this
> IBuySpy store, so that we all can learn from it ?
>
> greetings,
>
> Rob Segerink
>
> ""Zarko Gajic <http://delphi.about.com>"" <del...@ab...>
> schreef in bericht news:b4mgsu$d5b$1...@ne......
> > Hi, great news to all concerned:
> >
> > http://www.aspxdelphi.net
> >
> > aspxDelphi.net STORE uses Delphi for .NET and was developed from IBuySpy
> > store SDK. The IBuySpy Store Solution Kit is an e-commerce storefront
> > selling fictional spy equipment - available from ASP.NET. aspxDelphi.net
> > STORE is a fictitious "click and mortar" retailer that sells ultra-cool
> spy
> > gear on its Web site. A lighthearted look at some very serious
> requirements,
> > aspxDelphi.net STORE demonstrates how extraordinarily simple it is to
> create
> > powerful, scalable applications and services for the .NET platform.
> >
> > aspxDelphi.net STORE runs on the following databases:
> >
> > . Interbase / Firebird using the ADO.NET Data Provider for Firebird and
> > Interbase databases provider by Carlos Guzmán Álvarez
> >
> > . Microsoft SQL Server and MSDE
> >
> > .............................................
> > Zarko Gajic, webmaster to
> > aspxDelphi.net - bringing the world of
> > ASP.NET to Delphi developers
> > http://www.aspxdelphi.net
> > email: web...@as...
> > .............................................
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by:Crypto Challenge is now open!
> > Get cracking and register here for some mind boggling fun and
> > the chance of winning an Apple iPod:
> > http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] aspxDelphi.net STORE runing on Interbase / Firebird (Delphi + asp.net)!

[Rob S. <seg...@no...>]

Great! But why not give the source away
just like to C# and Vb versions of this
IBuySpy store, so that we all can learn from it ?

greetings,

Rob Segerink

""Zarko Gajic <http://delphi.about.com>"" <del...@ab...>
schreef in bericht news:b4mgsu$d5b$1...@ne......
> Hi, great news to all concerned:
>
> http://www.aspxdelphi.net
>
> aspxDelphi.net STORE uses Delphi for .NET and was developed from IBuySpy
> store SDK. The IBuySpy Store Solution Kit is an e-commerce storefront
> selling fictional spy equipment - available from ASP.NET. aspxDelphi.net
> STORE is a fictitious "click and mortar" retailer that sells ultra-cool
spy
> gear on its Web site. A lighthearted look at some very serious
requirements,
> aspxDelphi.net STORE demonstrates how extraordinarily simple it is to
create
> powerful, scalable applications and services for the .NET platform.
>
> aspxDelphi.net STORE runs on the following databases:
>
> . Interbase / Firebird using the ADO.NET Data Provider for Firebird and
> Interbase databases provider by Carlos Guzmán Álvarez
>
> . Microsoft SQL Server and MSDE
>
> .............................................
> Zarko Gajic, webmaster to
> aspxDelphi.net - bringing the world of
> ASP.NET to Delphi developers
> http://www.aspxdelphi.net
> email: web...@as...
> .............................................
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

[Firebird-net-provider] aspxDelphi.net STORE runing on Interbase / Firebird (Delphi + asp.net)!

[Zarko G. <http://delphi.about.com> <del...@ab...>]

Hi, great news to all concerned:

http://www.aspxdelphi.net

aspxDelphi.net STORE uses Delphi for .NET and was developed from IBuySpy
store SDK. The IBuySpy Store Solution Kit is an e-commerce storefront
selling fictional spy equipment - available from ASP.NET. aspxDelphi.net
STORE is a fictitious "click and mortar" retailer that sells ultra-cool spy
gear on its Web site. A lighthearted look at some very serious requirements,
aspxDelphi.net STORE demonstrates how extraordinarily simple it is to create
powerful, scalable applications and services for the .NET platform.

aspxDelphi.net STORE runs on the following databases:

. Interbase / Firebird using the ADO.NET Data Provider for Firebird and
Interbase databases provider by Carlos Guzmán Álvarez

. Microsoft SQL Server and MSDE

.............................................
Zarko Gajic, webmaster to
aspxDelphi.net - bringing the world of
ASP.NET to Delphi developers
http://www.aspxdelphi.net
email: web...@as...
.............................................

[Firebird-net-provider] Re: finalising the problem of FbDataReader

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

Hello:

> I've managed to alter one function to return DataTable and it works quite
> well...
> 
> Now about FbDataReader,  if I rewrite the function ending to:
> ...
>  Result := myCommand.ExecuteReader(CommandBehavior.CloseConnection);
>  myTransaction.Commit;
> ...
> 
> then the error is "Dynamic SQL Error SQL error code = -504 Cursor unknown"
> and the transaction seems to be open.


Thanks, fixed in CVS, see that using CommandBehavior.CloseConnection 
,when you close the reader the transaction is rollbacked and the 
connection closed.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Delphi and stored Proc

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

Sorry

 > I'm making test with C# without here is my test case:

should be :

I'm making test with C# without problems here is my test case: