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

[Firebird-net-provider] Alpha 1.1 install corrupted

[Riaan N. <ri...@ko...>]

Hi,

I've just downloaded the install, source and doc files of the Alpha 1.1 =
version from SourceForge and have found that I cannot install, and am =
getting the following message:

"Invalid package size!

Package "FirebirdNETProvider1.1-Alpha1.exe" has been corrupted, =
installation impossible."

Also, looking through the docs, I see a class "FbDatabasesInfo", but I'm =
unable to find its source.  I've tried in both the Source zip file for =
this version and by checking out the latest version from CVS, but =
neither of these methods seem to give me any file containing the =
definition for this class.

Thank you and keep up the good work.

Best Regards,
Riaan Nagel
Software Engineer
Korbitec - Research and Development

RE: [Firebird-net-provider] Connection String parameters

[Alan M. <al...@me...>]

Hmmm, OK it's neither...
Server= works 
Host does not (in help file)
Datasource does not (in example code)

Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Alan McDonald
> Sent: Thursday, 5 June 2003 10:30 AM
> To: fir...@li...
> Subject: [Firebird-net-provider] Connection String parameters
> 
> 
> The aspx example included in the install uses "Datasource" as 
> localhost. The
> help file uses (lists) "Host" as the server source. Which is correct?
> Alan
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Connection String parameters

[Alan M. <al...@me...>]

The aspx example included in the install uses "Datasource" as localhost. The
help file uses (lists) "Host" as the server source. Which is correct?
Alan

RE: [Firebird-net-provider] Compilation Error

[Alan M. <al...@me...>]

Thanks Carlos,
I have managed to track down the tokenkey... now I get an INGDS excep=
tion
(see below):

Q1: Is the provider using fbclient.dll or gds32.dll by default?
(GDSException infers gds32.dll is being used)
Q2: The FbException mentions "localhost" - I have no such reference (=
or to
127.0.0.1) in my connection string or the config file. Where is this
localhost reference coming from?

thanks
Alan


GDSException: Exception of type FirebirdSql.Data.INGDS.GDSException w=
as
thrown.]
   FirebirdSql.Data.Firebird.ConnectionPool.Create(String connectionS=
tring)
+72
   FirebirdSql.Data.Firebird.ConnectionPool.CheckOut(String
connectionString) +443
   FirebirdSql.Data.Firebird.FbConnectionPool.GetConnection(String
connectionString) +24
   FirebirdSql.Data.Firebird.FbConnection.Open() +108

[FbException: Unable to complete network request to host "localhost".
]
   FirebirdSql.Data.Firebird.FbConnection.Open() +354
   ASP.NewFile_aspx.Connection() in E:\Data\DOTNET\NewFile.aspx:28
   ASP.NewFile_aspx.cmdConnect_Click(Object sender, EventArgs e) in
E:\Data\DOTNET\NewFile.aspx:38
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +83

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.=
RaisePo
stBackEvent(String eventArgument) +58
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData=
) +33
   System.Web.UI.Page.ProcessRequestMain() +1277

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf=
 Of
> Carlos Guzman Alvarez
> Sent: Thursday, 5 June 2003 12:13 AM
> To: Alan McDonald
> Cc: fir...@li...
> Subject: Re: [Firebird-net-provider] Compilation Error
>
>
> Hello:
>
> > what about the publickeytoken? Where does that come from?
>
> Huummmm .... try to see it in the Global Assembly cache ( i think y=
ou
> have installed the provider using the intallation existent on
> sourceforge :) )
>
>
>
>
> --
> Best regards
>
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>
> "No tengo dones especiales.S=F3lo soy apasionadamente curioso"
> Albert Einstein, cient=EDfico.
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The=
 best
> thread debugger on the planet. Designed with thread debugging featu=
res
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] (FbCommandBuilder) Object reference notsetto...

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

Hello:

> I think that provider don't need to release (dispose) commands in this case too. Client creates an instance of command and client must release this instance too. 

Huuummm i'm thinking i'm going only to dispose the FbStatment instance 
of FbCommand for allow freeing firebird server resources.





-- 
Best regards

Carlos Guzma'n A'lvarez
Vigo-Spain

"No tengo dones especiales.So'lo soy apasionadamente curioso"
Albert Einstein, cienti'fico.

Re: [Firebird-net-provider] Compilation Error

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

Hello:

> what about the publickeytoken? Where does that come from?

Huummmm .... try to see it in the Global Assembly cache ( i think you 
have installed the provider using the intallation existent on 
sourceforge :) )




-- 
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] Compilation Error

[Alan M. <al...@me...>]

I've updated the version number ot the one in the dll
1.0.1241.28320
this made on difference...
what about the publickeytoken? Where does that come from?
thanks
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Alan McDonald
> Sent: Wednesday, 4 June 2003 11:38 PM
> To: fir...@li...
> Subject: RE: [Firebird-net-provider] Compilation Error
>
>
> Hi,
> Yes - now I am... :-)
> but now I get dependenciy errors on this line
> Line 23:                 <add assembly="FirebirdSql.Data.Firebird,
> Version=1.0.1154.37639, Culture=neutral,
> PublicKeyToken=a39b891b3af74145" />
>
> Are my versions in sync?
> thanks
> Alan
>
>
>
> > -----Original Message-----
> > From: fir...@li...
> > [mailto:fir...@li...]On Behalf Of
> > Carlos Guzman Alvarez
> > Sent: Wednesday, 4 June 2003 11:26 PM
> > To: Alan McDonald
> > Cc: fir...@li...
> > Subject: Re: [Firebird-net-provider] Compilation Error
> >
> >
> > Hello:
> >
> > > I've just installed .NET Framework...
> > > and ASP>NET Webmatrix (if anyone else has tried it)
> > > I then installed then Firebird .NET Provider 1.0
> >
> > Are you using a web.config file ?? you need one, see example in
> > Examples\ASP.NET directory of the .NET provider installation
> >
> >
> > <?xml version="1.0" encoding="UTF-8" ?>
> >
> > <configuration>
> >
> >      <system.net>
> >      </system.net>
> >
> >      <system.web>
> >          <compilation>
> >              <assemblies>
> >                  <add assembly="FirebirdSql.Data.Firebird,
> > Version=1.0.1154.37639, Culture=neutral,
> > PublicKeyToken=a39b891b3af74145" />
> >              </assemblies>
> >          </compilation>
> >
> >
> > 	..................
> > 	..................
> >
> >
> >
> >      </system.web>
> >
> > </configuration>
> >
> >
> >
> > --
> > Best regards
> >
> > Carlos Guzmán Álvarez
> > Vigo-Spain
> >
> > "No tengo dones especiales.Sólo soy apasionadamente curioso"
> > Albert Einstein, científico.
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
> > thread debugger on the planet. Designed with thread debugging features
> > you've never dreamed of, try TotalView 6 free at www.etnus.com.
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

RE: [Firebird-net-provider] Compilation Error

[Alan M. <al...@me...>]

Hi,
Yes - now I am... :-)
but now I get dependenciy errors on this line
Line 23:                 <add assembly="FirebirdSql.Data.Firebird,
Version=1.0.1154.37639, Culture=neutral, PublicKeyToken=a39b891b3af74145" />

Are my versions in sync?
thanks
Alan



> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Carlos Guzman Alvarez
> Sent: Wednesday, 4 June 2003 11:26 PM
> To: Alan McDonald
> Cc: fir...@li...
> Subject: Re: [Firebird-net-provider] Compilation Error
>
>
> Hello:
>
> > I've just installed .NET Framework...
> > and ASP>NET Webmatrix (if anyone else has tried it)
> > I then installed then Firebird .NET Provider 1.0
>
> Are you using a web.config file ?? you need one, see example in
> Examples\ASP.NET directory of the .NET provider installation
>
>
> <?xml version="1.0" encoding="UTF-8" ?>
>
> <configuration>
>
>      <system.net>
>      </system.net>
>
>      <system.web>
>          <compilation>
>              <assemblies>
>                  <add assembly="FirebirdSql.Data.Firebird,
> Version=1.0.1154.37639, Culture=neutral,
> PublicKeyToken=a39b891b3af74145" />
>              </assemblies>
>          </compilation>
>
>
> 	..................
> 	..................
>
>
>
>      </system.web>
>
> </configuration>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
> "No tengo dones especiales.Sólo soy apasionadamente curioso"
> Albert Einstein, científico.
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Compilation Error

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

Hello:

> I've just installed .NET Framework...
> and ASP>NET Webmatrix (if anyone else has tried it)
> I then installed then Firebird .NET Provider 1.0

Are you using a web.config file ?? you need one, see example in 
Examples\ASP.NET directory of the .NET provider installation


<?xml version="1.0" encoding="UTF-8" ?>

<configuration>

     <system.net>
     </system.net>

     <system.web>
         <compilation>
             <assemblies>
                 <add assembly="FirebirdSql.Data.Firebird, 
Version=1.0.1154.37639, Culture=neutral, PublicKeyToken=a39b891b3af74145" />
             </assemblies>
         </compilation>


	..................
	..................



     </system.web>

</configuration>



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

[Firebird-net-provider] Compilation Error

[Alan M. <al...@me...>]

Hi,
I've just installed .NET Framework...
and ASP>NET Webmatrix (if anyone else has tried it)
I then installed then Firebird .NET Provider 1.0

Now in the class browser of Webmatrix, I can see the
FirecordSQL.Data.Firebird  class - it's in the same group as the System.Data
classes..

Now I run the C# sample with this header
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="FirebirdSql.Data.Firebird" %>
<script runat="server">

etc etc.


and I get an error:
Compiler Error Message: CS0246: The type or namespace name 'FirebirdSql'
could not be found (are you missing a using directive or an assembly
reference?)
Source Error:
Line 1:  <%@ Page Language="C#" %>
Line 2:  <%@ import Namespace="System.Data" %>
Line 3:  <%@ import Namespace="FirebirdSql.Data.Firebird" %>
Line 4:  <script runat="server">
Line 5:


Can someone tell me what I might be missing?

thanks
Alan
PS- I've tried copying the firebird dll to the framework directory just in
case but it makes no difference.

Re[2]: [Firebird-net-provider] (FbCommandBuilder) Object reference notsetto...

[Ivan - <pre...@bk...>]

I think that provider don't need to release (dispose) commands in this case too. Client creates an instance of command and client must release this instance too. 

> Ok i will try to review this tomorrow and release commands only when the 
> connection is disposed.

Re: [Firebird-net-provider] (FbCommandBuilder) Object reference notsetto ...

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

Hello:

> Yes I do.

Ok i will try to review this tomorrow and release commands only when the 
connection is disposed.





-- 
Best regards

Carlos Guzma'n A'lvarez
Vigo-Spain

"No tengo dones especiales.So'lo soy apasionadamente curioso"
Albert Einstein, cienti'fico.

Re[2]: [Firebird-net-provider] (FbCommandBuilder) Object reference notsetto ...

[Ivan - <pre...@bk...>]

Yes I do.

> 
> Hello:
> 
> > I've took a closer look at source code for provider, and found, that you're disposing all commands in FbConnection.Close method.
> > So, we need to recreate every command (FbCommand) after FbConnection.Close() calling. It seems to be a bug in provide, cause MSSQL provider works good in this situation.
> 
> Huummm are you using connection pooling or not ??
> 

> 

Re: [Firebird-net-provider] (FbCommandBuilder) Object reference notset to ...

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

Hello:

> I've took a closer look at source code for provider, and found, that you're disposing all commands in FbConnection.Close method.
> So, we need to recreate every command (FbCommand) after FbConnection.Close() calling. It seems to be a bug in provide, cause MSSQL provider works good in this situation.

Huummm are you using connection pooling or not ??




-- 
Best regards

Carlos Guzma'n A'lvarez
Vigo-Spain

"No tengo dones especiales.So'lo soy apasionadamente curioso"
Albert Einstein, cienti'fico.

Re[2]: [Firebird-net-provider] (FbCommandBuilder) Object reference notset to ...

[Ivan - <pre...@bk...>]

It's not working again.
Here's a full test code of my sample
FbConnection con = new FbConnection(ConnectionString);
con.Open();
FbTransaction tran = con.BeginTransaction();
FbDataAdapter ad = new FbDataAdapter(@"SELECT  * FROM TBL", con);
ad.SelectCommand.Transaction = tran;
DataSet ds = new DataSet();
ad.Fill(ds, "TBL1001625");
con.Close();
con.Open();
tran = con.BeginTransaction();
ad.SelectCommand.Connection = con;
ad.SelectCommand.Transaction = tran;
DataSet ds1 = new DataSet();
ad.Fill(ds1, "TBL1001625"); // <--Exception here
/*
"Object reference not set to an instance of an object"
source: FbCommand.cs - Prepare()
statement = new FbStatement(Connection,
              Transaction,
              Parameters,
              commands[actualCommand], //commands is null, actualCommand == -1

              CommandType);

*/
con.Close();

I've took a closer look at source code for provider, and found, that you're disposing all commands in FbConnection.Close method.
So, we need to recreate every command (FbCommand) after FbConnection.Close() calling. It seems to be a bug in provide, cause MSSQL provider works good in this situation.

> 
> Hello:
> 
> Add this new line too and test please ( i can't test now ):
> 
> tran = con.BeginTransaction();
> -----> ad.SelectCommand.Connection = con
> ad.SelectCommand.Transaction = tran;
> 
> 
> 
> 
> -- 
> Best regards
> 
> Carlos Guzma'n A'lvarez
> Vigo-Spain
> 
> "No tengo dones especiales.So'lo soy apasionadamente curioso"
> Albert Einstein, cienti'fico.
> 
> 

Re: [Firebird-net-provider] (FbCommandBuilder) Object reference not set to ...

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

HEllo:

> I'm using Release of FB.NET 1.0 provider. Database - firebird 1.5 (RC3), Dialect 1.


I'm using this code as test case and all is working as expected:

	FbConnection con = new FbConnection(connectionString);
	con.Open();
	FbTransaction tran = con.BeginTransaction();

	FbCommand command = new FbCommand(@"SELECT * FROM TEST_TABLE_01", con, 
tran);

	FbDataAdapter ad = new FbDataAdapter(command);
	DataSet ds = new DataSet();
	ad.Fill(ds, "TBL");

	FbCommandBuilder b = new FbCommandBuilder(ad);
	b.QuotePrefix = String.Empty;
	b.QuoteSuffix = String.Empty;
	
	ad.Update(ds, "TBL"); // <--- Exception goes here

	con.Close();


-- 
Best regards

Carlos Guzma'n A'lvarez
Vigo-Spain

"No tengo dones especiales.So'lo soy apasionadamente curioso"
Albert Einstein, cienti'fico.

[Firebird-net-provider] Re: (FbCommandBuilder) Object reference not set to ...

[Ivan - <pre...@bk...>]

I've forgot to write one line.
After 
con.Close();
There should be 
con.Open();
And the problem is still there.

[Firebird-net-provider] (FbCommandBuilder) Object reference not set to ...

[Ivan - <pre...@bk...>]

Is this behavior by-design or a bug ?

FbConnection con = new FbConnection(cs);
con.Open();
FbTransaction tran = con.BeginTransaction();
FbDataAdapter ad = new FbDataAdapter(@"SELECT * FROM TBL", con);
DataSet ds = new DataSet();
ad.Fill(ds, "TBL");
con.Close();
tran = con.BeginTransaction();
ad.SelectCommand.Transaction = tran;
FbCommandBuilder b = new FbCommandBuilder(ad);
b.QuotePrefix = String.Empty;
b.QuoteSuffix = String.Empty;

ad.Update(ds, "TBL1001625"); // <--- Exception goes here
/*
"Object reference not set to an instance of an object"
source: FbCommand.cs - Prepare()
statement = new FbStatement(Connection, 
              Transaction, 
              Parameters,
              commands[actualCommand], //commands is null, actualCommand == -1

              CommandType);	

*/
actually, it's not a bug in FbCommandBuilder, because we can change last line to
DataSet ds1 = new DataSet();
ad.Fill(ds1, "TBL");
and there will be an exception too.

I'm using Release of FB.NET 1.0 provider. Database - firebird 1.5 (RC3), Dialect 1.

Re: [Firebird-net-provider] Re:Storing Binary Data (not in a blob)

[Christopher W. <chr...@ad...>]

I'll try that...Thanks!


On Thu, 2003-05-29 at 13:47, Carlos Guzman Alvarez wrote:
> Hello:
> 
> > It doesn't seem that efficient, but I solved the problem by iterating 
> > over the byte[] contents in a loop and appending the result of 
> > (char)byte[i] to a StringBuilder instance.  
> 
> 
> Why do not try using Encoding.Default.GetString(...) ???
> 
> > 
> >                 FbDataReader reader = 
> > m_daSinks.SelectCommand.ExecuteReader();
> > 
> >                 byte[] buff1, buff2;
> >                 while( reader.Read() )
> >                 {
> > 
> >                     buff1 = ASCIIEncoding.Default.GetBytes( 
> > reader.GetString( 0 ) );  // Binary data is in first column
> > 
> >                     buff2 = new byte[ reader.GetInt16( 1 )];    // 
> > Actual Length of the binary data
> > 
> >                     Array.Copy( buff1, 0, buff2, 0, buff2.Length );
> > 
> >                     object[] vals = new Object[]{ reader.GetInt64(2), 
> > buff2, DateTime.Now, EventName };
> >                     ds.Tables["tb_sinks"].LoadDataRow( vals, true );
> >                 }
> > 
> >                 reader.Close();
> 
> 
> Huummmm ... anything like this
> 
> 
> 	int bufLen = 0;
> 	byte[] buff1, buff2;
> 	while( reader.Read() )
> 	{
> 		buff1 = new byte[reader.GetInt16( 1 )]
> 		// Use here the encoding you need
> 		Endcoding.Default.GetBytes(
> 		reader.GetString( 0 ), 0, buff1.Length, buff1, 0 );
> 
> 		object[] vals = new Object[]{ reader.GetInt64(2),
> 				buff2, DateTime.Now, EventName };
> 		ds.Tables["tb_sinks"].LoadDataRow( vals, true );
> 	}
> 
> 
> 
> 

Re: [Firebird-net-provider] Re:Storing Binary Data (not in a blob)

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

Hello:

> It doesn't seem that efficient, but I solved the problem by iterating 
> over the byte[] contents in a loop and appending the result of 
> (char)byte[i] to a StringBuilder instance.  


Why do not try using Encoding.Default.GetString(...) ???

> 
>                 FbDataReader reader = 
> m_daSinks.SelectCommand.ExecuteReader();
> 
>                 byte[] buff1, buff2;
>                 while( reader.Read() )
>                 {
> 
>                     buff1 = ASCIIEncoding.Default.GetBytes( 
> reader.GetString( 0 ) );  // Binary data is in first column
> 
>                     buff2 = new byte[ reader.GetInt16( 1 )];    // 
> Actual Length of the binary data
> 
>                     Array.Copy( buff1, 0, buff2, 0, buff2.Length );
> 
>                     object[] vals = new Object[]{ reader.GetInt64(2), 
> buff2, DateTime.Now, EventName };
>                     ds.Tables["tb_sinks"].LoadDataRow( vals, true );
>                 }
> 
>                 reader.Close();


Huummmm ... anything like this


	int bufLen = 0;
	byte[] buff1, buff2;
	while( reader.Read() )
	{
		buff1 = new byte[reader.GetInt16( 1 )]
		// Use here the encoding you need
		Endcoding.Default.GetBytes(
		reader.GetString( 0 ), 0, buff1.Length, buff1, 0 );

		object[] vals = new Object[]{ reader.GetInt64(2),
				buff2, DateTime.Now, EventName };
		ds.Tables["tb_sinks"].LoadDataRow( vals, true );
	}





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

[Firebird-net-provider] Re:Storing Binary Data (not in a blob)

[Christopher W. <chr...@ad...>]

Hi-

FYI to anyone interested:

It doesn't seem that efficient, but I solved the problem by iterating
over the byte[] contents in a loop and appending the result of
(char)byte[i] to a StringBuilder instance.  I set the FBType of the
parameter to Char and write the string to the database without a
problem.  I also write the actual length of the data to another column
because it represents a serialized object and must be deserialized into
an instance.  

The column that is defined as char(x) character set octets does allow
the delete statement that uses it in the where clause to work properly.

When I get the results of the select, I need to transform the string
representing the binary data into the datatable column format of
Base64Binary.  That rules out dataAdapter.Fill( dateSet ).  Instead  I
used the following code to load the data from the database table into
the dataset:

                FbDataReader reader =
m_daSinks.SelectCommand.ExecuteReader();

                byte[] buff1, buff2;
                while( reader.Read() )
                {

                    buff1 = ASCIIEncoding.Default.GetBytes(
reader.GetString( 0 ) );  // Binary data is in first column

                    buff2 = new byte[ reader.GetInt16( 1 )];    //
Actual Length of the binary data

                    Array.Copy( buff1, 0, buff2, 0, buff2.Length );

                    object[] vals = new Object[]{ reader.GetInt64(2),
buff2, DateTime.Now, EventName };
                    ds.Tables["tb_sinks"].LoadDataRow( vals, true );
                }

                reader.Close();


Any suggestions for improving this approach would be greatly
appreciated.

Regards,

Chris Whelan

[Firebird-net-provider] Re:Storing Binary Data (not in a blob)

[Christopher W. <chr...@ad...>]

Hi-

I also tried FbType of LongVarBinary which I had used successfully for
the blob insertion and I still receive a Invalid Cast exception...

Regards,

Chris Whelan

[Firebird-net-provider] Storing Binary Data (not in a blob)

[Christopher W. <chr...@ad...>]

Hello,

I am attempting to use the Firebird Net-Provider to store binary data
that can be included in a where clause.  I am modifying code that works
on MS SQL Server where the column is varbinary with a length of 4096. 
If I use a blob subtype binary, NetProvider works fine on the insert,
but I also want to be able to delete rows based on the value contained
in the binary data.  Someone please correct me if I am wrong, but the
firebird blob seems only for storage and retrieval and it does not
appear you can use it as a column in the where clause...

I researched it a bit on the web and I have seen the recommendation to
store binary data by using char(size) character set octets.  Apparently,
firebird won't perform any transliteration on the data and stores it in
its native binary format.  I have tried this solution using the
Net-Provider two different ways and in both cases it throws an Invalid
Cast exception.  I tried setting the FbType of the parameter to Char and
also setting it to Binary...

I was also wondering if I should use C# to somehow transform the byte[]
into a string representing the binary information...

Any suggestions on how to solve this problem would be greatly
appreciated.  

Regards,

Chris Whelan

[Firebird-net-provider] Logger support question

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

Hello:


I'm thinking on remove the logger classes from 1.1 source tree, how .NET 
framewowrk ships with a debugger and mono project has one in 
developement i think this will be no really needed any objection to this ??



-- 
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] [ANN] Firebird .NET Data Provider Release 1.0 for .NET Framework 1.0 available for download.

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

Hello:

Firebird .NET Data Provider Release 1.0 for .NET Framework 1.0 available 
for download.




You can download it here:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-NF1.0.exe?download





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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