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

Re: [Firebird-net-provider] Does it run on Pocket Windows?

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

Hello:

> Can I use the provider on Pocket Windows (using the .NET compact framework)?

As i know there are people using it with the .NET Compact Framework and 
VS 2003, but personally i have no tested it because i don't have the VS 
2003, if you want, try it and tell us the problems you have using it 
with on a Pocket :)






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Does it run on Pocket Windows?

[Karsten S. <st...@ai...>]

Can I use the provider on Pocket Windows (using the .NET compact framework)?

Thanks
Karsten

[Firebird-net-provider] Does it run on Pocket Windows?

[Karsten S. <st...@ai...>]

Can I use the provider on Pocket Windows (using the .NET compact framework)?

Thanks
Karsten

RE: [Firebird-net-provider] [ANN] Firebird .NET Data Provider Announced in FreshMeat

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

Why is it at freshmeat? Is it no longer going to be at sourceforge?
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf=
 Of
> Carlos Guzman Alvarez
> Sent: Friday, 27 June 2003 4:17 AM
> To: Firebird .Net Provider
> Subject: [Firebird-net-provider] [ANN] Firebird .NET Data Provider
> Announced in FreshMeat
>
>
> Hello:
>
> The last release of the .NET Data Provider was announced at FreshMe=
at
> you can see it here (thanks to Marius Popa Adrian for his feedback)=
:
>
>
> http://freshmeat.net/projects/firebird.netdataprovider/?topic_id=
=3D66
>
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Par=
tner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commis=
sion!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.=
php
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] [ANN] Firebird .NET Data Provider Announced in FreshMeat

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

Hello:

> Why is it at freshmeat? Is it no longer going to be at sourceforge?

It's and will be at sourceforge, at freshmeat will be only a new place 
for announces of new releases ( if you see the annopunce at fresmeat has 
links to sourceforge :D ).







-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] [ANN] Firebird .NET Data Provider Announced in FreshMeat

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

Hello:

The last release of the .NET Data Provider was announced at FreshMeat 
you can see it here (thanks to Marius Popa Adrian for his feedback):


http://freshmeat.net/projects/firebird.netdataprovider/?topic_id=66






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Re: What enumeration do I use against "ProviderType" when using "ExecuteReader" with Behavior "SchemaOnly | KeyInfo"

[<CAR...@te...>]

Hello=3A

=3E I can=27t post the exact code (non-disclosure contracts
=3E prevent me)=2C but here=27s the =22psuedo-code=22 example
=3E (unchecked=2C so I don=27t even know if this actually
=3E compiles) of what=27s happening=3A

No problem=2C with the sample code you have sent is more than needed =3A)=


=3E Once I get the datatable (similar to your C=23 example)=2C
=3E I have this=3A
=3E =

=3E for (short c=3D0=3Bc=3Cc=5Fcount=3Bc++)
=3E        =7B
=3E         DataColumn * col =3D columns-=3Eget=5FItem( c )=3B
=3E         Object *o =3D row-=3Eget=5FItem( col )=3B
=3E =

=3E         switch( Type=3A=3AGetTypeCode( o-=3EGetType() ) )
=3E           =7B
=3E =2E=2E=2E// enumerating the various typecodes from
=3E TypeCode=3A=3ADecimal=2C etc=2E (they all work as expected)
=3E =

=3E =2E=2E// for the =22DataType=22 column=2C this case fires=2E=2E=2E
=3E =

=3E             case TypeCode=3A=3AObject=3A
=3E              =7B Type *t =3D o-=3EGetType()=3B
=3E                n =3D Type=3A=3AGetTypeCode(t)=3B
=3E                // n is always 1
=3E              =7D
=3E             break=3B

Huummm i can=27t test it now ( i will try it later today )=2C but in firs=
t =

place think in that DataType column already has a Type value ( =

System=2EString=2C System=2EArray=2C System=2EInt32=2C etc=2E=2E=2E)




--
Best regards
Carlos Guzm=E1n =C1lvarez
Vigo-Spain

[Firebird-net-provider] Re: What enumeration do I use against "ProviderType" when using "ExecuteReader" with Behavior "SchemaOnly | KeyInfo"

[Jason V. <jas...@ya...>]

From your previous answer, which now that I look at it
I should have been able to find myself, using the
FbType enumeration corrects the problem for me.

However, I'm writing in C++, using the interop
services within a single managed C++ module (the rest
of the application is unmanaged), so the behavior
could be different because of this.

I can't post the exact code (non-disclosure contracts
prevent me), but here's the "psuedo-code" example
(unchecked, so I don't even know if this actually
compiles) of what's happening:

Once I get the datatable (similar to your C# example),
I have this:

for (short c=0;c<c_count;c++)
        {
         DataColumn * col = columns->get_Item( c );
         Object *o = row->get_Item( col );

         switch( Type::GetTypeCode( o->GetType() ) )
           {
...// enumerating the various typecodes from
TypeCode::Decimal, etc. (they all work as expected)

..// for the "DataType" column, this case fires...

             case TypeCode::Object:
              { Type *t = o->GetType();
                n = Type::GetTypeCode(t);
                // n is always 1
              }
             break;

           }



In this example, what I get is an "Object", from which
I get a type, and then a typecode. I'm not sure why -
it's the only field that does this (the ProviderType
gives me a number, as expected), and I've not yet
checked the MsSQL2000 version (I'm doing both side by
side) to see if it does the same thing - I think it
does (which would suggest the problem isn't your
provider).



__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Re: [Firebird-net-provider] What enumeration do I use against "ProviderType" when using "ExecuteReader" with Behavior "SchemaOnly | KeyInfo"

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

Hello:

> Indeed, it appears to provide "Object" which is then
> used to get a "Type" and from that I call
> "GetTypeCode" = always returns 1 on the sample
> databases that come with Firebird (Employee.gdb).

I'm making a test and all seems to work as expected, can you tell me if 
this is a correct test case:

	FbConnection connection = new FbConnection(connectionString);
	connection.Open();
	FbTransaction transaction = connection.BeginTransaction();

	FbCommand command = new FbCommand("Select * from test_table_01", 
connection, transaction);

	FbDataReader reader = 
command.ExecuteReader(CommandBehavior.KeyInfo|CommandBehavior.SchemaOnly);

	DataTable schema = reader.GetSchemaTable();

	foreach (DataRow row in schema.Rows)
	{
		foreach (DataColumn column in schema.Columns)
		{
			Console.WriteLine("{0} = {1}", column.ColumnName, row[column.Ordinal]);
		}
	}


	connection.Close();


In my test:

"DataType" column has the correct System type.
"ProviderType" column has the correct FbType value.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] What enumeration do I use against "ProviderType" when using "ExecuteReader" with Behavior "SchemaOnly | KeyInfo"

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

Hello:

> DataType seems to be 1 in all cases, 

I will try to see this later today.

> What table of types should I be using?

Try using FbType






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] What enumeration do I use against "ProviderType" when using "ExecuteReader" with Behavior "SchemaOnly | KeyInfo"

[Jason V. <jas...@ya...>]

When I perform the "ExecuteReader" with behavior
options set to "SchemaOnly | KeyInfo", I get a
DataTable that lists all the columns resulting for a
query, but I can't make sense out of the "DataType"
and "ProviderType" entries. DataType seems to be 1 in
all cases, whereas I get various values for
"ProviderType" - but that doesn't seem to correctly
match values from the DbType or TypeCode enumerations.

What table of types should I be using?

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Re: [Firebird-net-provider] Re: Freshmeat Question

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

Hello:

> You have to register the project on the fresmeat  (first create a user for that)
> and after they aproove it you can announce the new releases  

I'm registered yet i will submit the project info later today, thanks 
very much :)






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Re: Freshmeat Question

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

Hello:

> You have to register the project on the fresmeat  (first create a user for that)
> and after they aproove it you can announce the new releases  

Ok , thanks very much.






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: Freshmeat Question

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

You have to register the project on the fresmeat  (first create a user for =
that)
and after they aproove it you can announce the new releases =20

On Mon, 23 Jun 2003 19:30:57 +0200
Carlos Guzman Alvarez <car...@te...> wrote:

> Hello:
>=20
> > do you have a freshmeat project where to put the news ?=20
> > it could be nice to have a page there :)=20
>=20
> There are any special to do for announce the new version of Firebird=20
> .NET Data provider ( 1.1 Alpha 2 ) at freshmeat ?? :D
>=20
>=20
>=20
> Thanks in advance
>=20
>=20
>=20
> --=20
> Best regards
>=20
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain

[Firebird-net-provider] Freshmeat Question

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

Hello:

> do you have a freshmeat project where to put the news ? 
> it could be nice to have a page there :) 

There are any special to do for announce the new version of Firebird 
.NET Data provider ( 1.1 Alpha 2 ) at freshmeat ?? :D



Thanks in advance



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.1 Alpha 2 ( for .NET 1.0 ) available for download.

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

Hello:


Hello:

Firebird .NET Data Provider 1.1 Alpha 2 ( for .NET 1.0 ) available for 
download.


Release Changes:


Alpha 2 ( 2003-06-23 )
------- --------------

- Updated API Reference documentation.

- BugFixes.

- Added Firebird Events API Support, see KNOWN.TXT ( Thanks to Tedd for 
his help and feedback ).

- Added a new example in VB.NET contributed by Andrew C. Goodall.


         ---------------------------------------------------



You can view the changelog at:

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


You can download binarys ( for Windows and .NET Framework 1.1 ) at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.1-Alpha2.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.1-Alpha2-Src.zip?download


You can download documentation at:

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





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Error of "Invalid PInvoke metadata format" with Firebird.Net Data Provider

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

Hello:

> FirebirdSql.Data.Firebird: 1.1.1253.20777
> DotNet Framework
> * 1.0.2914
> * 1.0.3705
> * 1.1.4322
> Firebird_1_5
> 
> 
> Any suggestions?


The .NET provider 1.1 was built with .NET Framework 1.1, are you using 
VS 2002 ?? ( VS 2002 works only with .NET Framework 1.0 )




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Error of "Invalid PInvoke metadata format" with Firebird.Net Data Provider

[Glenn S. <gm...@ro...>]

Hi
I just installed the Firebird.Net Data Provider and using their=20
ASP.Net example with the security.fdb database and it comes up with the =
below error.
I tried the same thing with IB6 and get the same error.
I can use Easysoft ODBC driver & IB6 with ASP.Net.

Error: Invalid PInvoke metadata format.

It bombs on the=20
myConnection.Open();

Stact Trace
[TypeLoadException: Invalid PInvoke metadata format.]
   FirebirdSql.Data.Firebird.ConnectionPool.Create(String =
connectionString) +72
   FirebirdSql.Data.Firebird.ConnectionPool.CheckOut(String =
connectionString) +443
   FirebirdSql.Data.Firebird.FbConnectionPool.GetConnection(String =
connectionString) +32
   FirebirdSql.Data.Firebird.FbConnection.Open() +108
   ASP.CSharpExample_aspx.Connection() in C:\Program =
Files\FirebirdNETProvider1.1\examples\ASP.NET\CSharpExample.aspx:29
   ASP.CSharpExample_aspx.cmdConnect_Click(Object sender, EventArgs e) =
in C:\Program =
Files\FirebirdNETProvider1.1\examples\ASP.NET\CSharpExample.aspx:40
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   =
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.Rais=
ePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler =
sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) =
+33
   System.Web.UI.Page.ProcessRequestMain() +1263

Win2000
IE: v6.02
FirebirdSql.Data.Firebird: 1.1.1253.20777
DotNet Framework
* 1.0.2914
* 1.0.3705
* 1.1.4322
Firebird_1_5


Any suggestions?
Thanks
Glenn

Re: [Firebird-net-provider] Stored Proc execution question

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

Hello:

> I'm easy on this...
> I'm afraid I rarely use this syntax in the world of ASP, I use
> MyConnection.Execute("EXECUTE STORED PROCEDURE(..")
> since it reduces overhead a little more than having to create parameters
> etc.
> 
> Doesn't the old ADO way of doing it mean that the @ID parameter is not
> explicit either?
> doesn't the old way go something like
> 
> command.CommandType = CommandType.StoredProcedure;
> command.CommandText = "SP_NAME";
> 
> then you create and add the parameters to the command


I'm reviewing how the Sql Server provider works and seems that you are 
right:


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingstoredprocedureswithcommand.asp





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Stored Proc execution question

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

I'm easy on this...
I'm afraid I rarely use this syntax in the world of ASP, I use
MyConnection.Execute("EXECUTE STORED PROCEDURE(..")
since it reduces overhead a little more than having to create parameters
etc.

Doesn't the old ADO way of doing it mean that the @ID parameter is not
explicit either?
doesn't the old way go something like

command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_NAME";

then you create and add the parameters to the command


Alan


> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Carlos Guzman Alvarez
> Sent: Saturday, 21 June 2003 8:11 PM
> To: Firebird .Net Provider
> Subject: [Firebird-net-provider] Stored Proc execution question
>
>
> Hello:
>
>
> Now the CommandText for execute an stored proc needs to have the EXECUTE
> PROCEDURE and the begin:
>
>
> 	command.CommandType = CommandType.StoredProcedure;
>     	command.CommandText = "EXECUTE PROCEDURE SP_NAME(@ID)";
>
> I'm thinking in add a change to the 1.1 branch for allow stored proc to
> be executed as:
>
> 	command.CommandType = CommandType.StoredProcedure;
> 	command.CommandText = "SP_NAME(@ID)";
>
> And add a check to the CommandText when the CommandType =
> CommandType.StoredProcedure for see if it's needed to add the EXECUTE
> PROCEDURE string at the begining automatically.
>
>
>
> Any thoughts ????
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

[Firebird-net-provider] Stored Proc execution question

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

Hello:


Now the CommandText for execute an stored proc needs to have the EXECUTE 
PROCEDURE and the begin:


	command.CommandType = CommandType.StoredProcedure;
    	command.CommandText = "EXECUTE PROCEDURE SP_NAME(@ID)";

I'm thinking in add a change to the 1.1 branch for allow stored proc to 
be executed as:

	command.CommandType = CommandType.StoredProcedure;
	command.CommandText = "SP_NAME(@ID)";

And add a check to the CommandText when the CommandType = 
CommandType.StoredProcedure for see if it's needed to add the EXECUTE 
PROCEDURE string at the begining automatically.



Any thoughts ????



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] where to get .net provider and examples

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

Yeh thanks - I had to make sure, I have two servers on the same box -=
 wanted
to know which one was actually responding.
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf=
 Of
> Carlos Guzman Alvarez
> Sent: Saturday, 21 June 2003 8:06 PM
> To: Alan McDonald
> Cc: Firebird .Net Provider
> Subject: Re: [Firebird-net-provider] where to get .net provider and
> examples
>
>
> Hello:
>
> > Does the gds client incorporated into the provider support custom=
 port
> > numbers for the connection?
>
>
> Yes you can specify one in the connection string, iusing the Port e=
lement:
>
> string connectionString =3D
> =09"User=3DSYSDBA;"=09=09=09+
> =09"Password=3Dmasterkey;"=09=09+
> =09@"Database=3DEMPLOYEE.GDB;" =09+
> =09"DataSource=3Dlocalhost;"=09=09+
> =09"Port=3D3060;"=09=09=09+=09<--------------
> =09"Dialect=3D3;"=09=09=09+
> =09"Charset=3DNONE;"=09=09=09+
> =09"Role=3D;"=09=09=09+
> =09"Connection lifetime=3D15;"=09+
> =09"Pooling=3Dfalse;"=09=09+
> =09"Packet Size=3D8192";
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Par=
tner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commis=
sion!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.=
php
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] where to get .net provider and examples

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

Hello:

> Does the gds client incorporated into the provider support custom port
> numbers for the connection?


Yes you can specify one in the connection string, iusing the Port element:

string connectionString =
	"User=SYSDBA;"			+
	"Password=masterkey;"		+
	@"Database=EMPLOYEE.GDB;" 	+				
	"DataSource=localhost;"		+
	"Port=3060;"			+	<--------------
	"Dialect=3;"			+
	"Charset=NONE;"			+
	"Role=;"			+
	"Connection lifetime=15;"	+
	"Pooling=false;"		+
	"Packet Size=8192";





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] where to get .net provider and examples

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

Carlos,
Does the gds client incorporated into the provider support custom port
numbers for the connection?

Alan

Re: [Firebird-net-provider] where to get .net provider and examples

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

Hello:

> Here's and undate to the examples I gave with the html section and some
> comments:
> 
> Here's some examples in VB one for a reader, a dataadapter, and a
> ExecuteNonQuery. I save the result to an xml file that I can use later
> instead of pounding the database with more queries.  Note on the
> ExecuteNonQuery you have to have a Commit to get it to work unlike SQL
> Client or OleDb Client.


Attached to this email is a modified version of your sample ( nice 
sample !! ) that works with the EMPLOYEE.GDB database that ships with 
Firebird i'm going to add it to the CVS :D, thanks very much






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain