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

[Firebird-net-provider] more commands

[Pavol S. <pa...@st...>]

can i use 2 fbCommands with one fbConnection and one fbTransaction
or
have i create separate connection or transaction for each fbCommand???

this example throws exception:
FbConnection dbConn = new FbConnection(fConnString);
try {
	dbConn.Open();
			
	FbTransaction dbTran = dbConn.BeginTransaction();
	if (fID < 0) {
		string genQuery = "SELECT GEN_ID(GENARTICLEID, 1) FROM RDB$DATABASE";
		FbCommand dbCmd2 = new FbCommand(genQuery, dbConn, dbTran);
		dbCmd2.ExecuteScalar();
	}
	FbCommand dbCmd = new FbCommand(query, dbConn, dbTran);
		
	dbCmd.Prepare();
	dbCmd.Parameters.Add("xID", fID);
	dbCmd.ExecuteNonQuery();
	dbTran.Commit();
}
finally {
	dbConn.Close();
}







and exception is:
Unhandled Exception: System.InvalidOperationException: Command 
Connection is not
  equal to Transaction Connection.
    at FirebirdSql.Data.Firebird.FbCommand.Prepare()
    at NovyCas.DBArticle.SaveArticle() in 
C:\Projekty\NetStarek\NovyCas\DBArticle
.cs:line 221
    at Tests.TestDBArticleCreateSaveGet() in 
C:\Projekty\NetStarek\Tests\Main.cs:
line 42
    at Tests.Main(String[] args) in 
C:\Projekty\NetStarek\Tests\Main.cs:line 61
Press any key to continue . . .

[Firebird-net-provider] question ExecuteScalar

[Pavol S. <pa...@st...>]

hi,

i have question:

what object is result of fbCommand.ExecuteScalar()???

directly how to cast this???

string genQuery = "SELECT GEN_ID(GENARTICLEID, 1) FROM RDB$DATABASE";
FbCommand dbCmd2 = new FbCommand(genQuery, dbConn, dbTran);
int fID = dbCmd2.ExecuteScalar(); <- ?????? cast to (int) is not working

p.

Re: [Firebird-net-provider] question

[Pavol S. <pa...@st...>]

Carlos Guzm=E1n =C1lvarez wrote:

> Hello:
>
>> i downloaded fresh CVS and i have problem with connection to database:
>>
>> it was working with older version :(
>>
>> using Firebird 1.5 beta1
>>
>> Unhandled Exception: System.TypeLoadException: Invalid PInvoke=20
>> metadata format.
>>    at FirebirdSql.Data.Firebird.ConnectionPool.Create(Byte dialect,=20
>> String chars
>> et, String role, String user, String password, String database)
>>    at FirebirdSql.Data.Firebird.ConnectionPool.CheckOut(Byte dialect,=20
>> String cha
>> rset, String role, String user, String password, String database,=20
>> Int64 lifetime
>> )
>>    at FirebirdSql.Data.Firebird.FbConnectionPool.GetConnection(Byte=20
>> dialect, Str
>> ing charset, String role, String user, String password, String=20
>> database, Int64 l
>> ifetime)
>>    at FirebirdSql.Data.Firebird.FbConnection.Open()
>>    at NovyCas.DBArticle.GetArticle(Int32 iID) in=20
>> C:\Projekty\NetStarek\NovyCas\D
>> BArticle.cs:line 157
>>    at NovyCas.DBArticle..ctor(Int32 iID) in=20
>> C:\Projekty\NetStarek\NovyCas\DBArti
>> cle.cs:line 136
>>    at Tests.TestDBArticleConstructor() in=20
>> C:\Projekty\NetStarek\Tests\Main.cs:li
>> ne 9
>>    at Tests.Main(String[] args) in=20
>> C:\Projekty\NetStarek\Tests\Main.cs:line 42
>
>
>
>
> Can you test it setting pooling to false and tell to me if it works or=20
> not??

with pooling=3Dfalse there is same exception

p.

Re: [Firebird-net-provider] parameters placeholders

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

Hello:

 > please make it that way i have to use @sign in parameter name in
 > ParamsCollection too
 >
 > parameters.Add("@myparam", 1)
 > not
 > parameters.Add("myparam", 1)
 > (this is not logic, but i think, that sql provider do it this way...)
 >
 > or you will have to write strong help for this...

I have commited to the CVS the first changes for allow this i will try 
to make some tests and add NUnit tests to the CVS later today.





Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] problem with connection

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

Hello:

> i think, that problem is not in Firebird itself, becouse when i use 
> netprovider alpha 3 or alpha 4 it is working, it is not working only 
> with new build from fresh cvs...
> 
> may be there is problem in connection string:
> 
> Database=c:\\PROJEKTY\\Databases\\ncmain.gdb;User=sysdba;Password=masterkey;Dialect=3;Charset=WIN1250;Server=127.0.0.1 
> 
> 
> and again this conn string work with older provider, but now with new :(
> there is that PInvoke metadata problem... I was checking sources and it 
> looks, that parsing is correct... I cannot go deeper in your source, 
> becouse i have problems debuging it (i dont like .net debuggers)
> 
> it is working with old provider, then i change reference to new provider 
> and that funny exception is raised...


Ok thanks i'm going to see it.



Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] problem with connection

[Pavol S. <pa...@st...>]

hi,

i think, that problem is not in Firebird itself, becouse when i use 
netprovider alpha 3 or alpha 4 it is working, it is not working only 
with new build from fresh cvs...

may be there is problem in connection string:

Database=c:\\PROJEKTY\\Databases\\ncmain.gdb;User=sysdba;Password=masterkey;Dialect=3;Charset=WIN1250;Server=127.0.0.1

and again this conn string work with older provider, but now with new :(
there is that PInvoke metadata problem... I was checking sources and it 
looks, that parsing is correct... I cannot go deeper in your source, 
becouse i have problems debuging it (i dont like .net debuggers)

it is working with old provider, then i change reference to new provider 
and that funny exception is raised...

thanx
p.

Re: [Firebird-net-provider] question

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

Hello:


> using Firebird 1.5 beta1

I have made some tests using Fb 1.5 beta 1 without problems in 
connection, you have the same problem connecting to Fb 1.0.x ??




Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] question

[Pavol S. <pa...@st...>]

i downloaded fresh CVS and i have problem with connection to database:

it was working with older version :(

using Firebird 1.5 beta1

Unhandled Exception: System.TypeLoadException: Invalid PInvoke metadata 
format.
    at FirebirdSql.Data.Firebird.ConnectionPool.Create(Byte dialect, 
String chars
et, String role, String user, String password, String database)
    at FirebirdSql.Data.Firebird.ConnectionPool.CheckOut(Byte dialect, 
String cha
rset, String role, String user, String password, String database, Int64 
lifetime
)
    at FirebirdSql.Data.Firebird.FbConnectionPool.GetConnection(Byte 
dialect, Str
ing charset, String role, String user, String password, String database, 
Int64 l
ifetime)
    at FirebirdSql.Data.Firebird.FbConnection.Open()
    at NovyCas.DBArticle.GetArticle(Int32 iID) in 
C:\Projekty\NetStarek\NovyCas\D
BArticle.cs:line 157
    at NovyCas.DBArticle..ctor(Int32 iID) in 
C:\Projekty\NetStarek\NovyCas\DBArti
cle.cs:line 136
    at Tests.TestDBArticleConstructor() in 
C:\Projekty\NetStarek\Tests\Main.cs:li
ne 9
    at Tests.Main(String[] args) in 
C:\Projekty\NetStarek\Tests\Main.cs:line 42

Re: [Firebird-net-provider] parameters placeholders

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

Hello:

> is there posibility use named parameters placeholders??? It is working 
> with question mark, but in more complex queries i need to use same 
> parameter more then once. something like IBX :parameterName

I can try to implemet it, i think that can be good to use the same 
format as in the
SQL Server Provider ( for compatibility :) ) using @parameterName, any 
thoughts??




Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] parameters placeholders

[Pavol S. <pa...@st...>]

hi,

is there posibility use named parameters placeholders??? It is working 
with question mark, but in more complex queries i need to use same 
parameter more then once. something like IBX :parameterName

thanx Pavol

Re: [Firebird-net-provider] AS3AP Benchmark results with single and multiuser tests passed.

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

Hello:

A last thing database have FORCED WRITES turned to OFF.





Best regards
Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] AS3AP Benchmark results with single and multiuser tests passed.

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

Hello:


I have passed the AS3AP benchmark to Firebird 1.0.2 using the Firebird 
ADO .NET Data provider,
including single and multiuser tests, attached to this email are the 
results.




Best regards
Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Interbase 5.x

[Leyne, S. <sl...@at...>]

Eduaro,

> Database=3D<DataBaseFile>;User=3D<user>;Password=3D<password>;Dialec
> t=3D1;Server=3D<se
> rver>

Try omitting the Dialect setting completely.

> Isn't the dialect=3D1 option the maintain compability with=20
> previous versions of IB 6.0 ?

True, but the setting is only meaningfull to IB 6.0, IB 5.x doesn't know
anything about the setting.

By the way, you should **really** upgrade to IB 5.6.  IB 5.5 was a very
poor excuse for a software lease -- full of bugs.


Sean

Re: [Firebird-net-provider] Interbase 5.x

[Eduardo B. <em...@ue...>]

Greetings

the connection string is something like this:

Database=<DataBaseFile>;User=<user>;Password=<password>;Dialect=1;Server=<se
rver>

I had try with dialect=3 and dialect=1 and both works in IB 6.0 but no
sucess with IB 5.5

Isn't the dialect=1 option the maintain compability with previous versions
of IB 6.0 ?


Thank's in advance
Eduaro Barbosa



----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Eduardo Barbosa" <em...@ue...>
Cc: <fir...@li...>
Sent: Friday, January 31, 2003 9:24 PM
Subject: Re: [Firebird-net-provider] Interbase 5.x


> Hello:
>
> > I 'had try the firebird .net provider with interbase 6.0 with no
problems.
> >
> > With Interbase 5.5 i have an error on connection.open() --> connection
> > refused
>
> I can´t test it with interbase 5.x but can you tell wich connection
> string are you using ??
>
>
> --
> 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:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> http://www.vasoftware.com
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>

Re: [Firebird-net-provider] Interbase 5.x

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

Hello:

> I 'had try the firebird .net provider with interbase 6.0 with no problems.
>  
> With Interbase 5.5 i have an error on connection.open() --> connection 
> refused

I can´t test it with interbase 5.x but can you tell wich connection 
string are you using ??


-- 
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 5.x

[Eduardo B. <em...@ue...>]

Greetings,
 
I 'had try the firebird .net provider with interbase 6.0 with no
problems.
 
With Interbase 5.5 i have an error on connection.open() --> connection
refused 
 
 
Can anyone give me a hint ???
 
 
greetings
 

Eduardo Barbosa

 

Re: [Firebird-net-provider] Slowdown with MissingSchemaAction.AddWithKey

[<car...@ho...>]

Hello:


> If I use MissingSchemaAction.AddWithKey before I do Adapter.Fill it can take
> up to four seconds to do the fill but when I don't use AddWithKey it takes
> much less than a second.  This occurs on a 1Ghz windows 2000 box with the
> database local and with a 750Ghz 98 box with the database remote.

Have you tested it with latest cvs canges?? continue to give the same 
times??



Best regards
Carlos Guzmán Álvarez
vigo-Spain

Re: [Firebird-net-provider] Problem with save using commandbuilder

[Christoph D. <cd...@ar...>]

Thanks.  Works well now.


Christoph
----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Christoph Donges" <cd...@ar...>
Cc: <fir...@li...>
Sent: Saturday, January 25, 2003 8:11 PM
Subject: Re: [Firebird-net-provider] Problem with save using commandbuilder


> Hello:
>
>
> > If I load a table into a grid and then change an item and save it is not
> > saved in the database.  Delete and add work ok.
> >
> >
> > Christoph
>
> Fixed, it´s an error in latest changes of GetSchemaTable, thanks very
much.
>
> --
> 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:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> http://www.vasoftware.com
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Problem with save using commandbuilder

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

Hello:


> If I load a table into a grid and then change an item and save it is not 
> saved in the database.  Delete and add work ok.
>  
>  
> Christoph

Fixed, it´s an error in latest changes of GetSchemaTable, thanks very much.

-- 
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] Slowdown with MissingSchemaAction.AddWithKey

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

Hello:

> Are you seeing the same kind of results.  Is there anything that can be done
> to speed up this process?

I get good times, but i´m not sure if i´m making the correct test, i´m 
making this:

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

	FbCommand			command		= new FbCommand("select * from EMPLOYEE", 
connection, transaction);

	FbDataAdapter		adapter		= new FbDataAdapter(command);
	FbCommandBuilder	builder		= new FbCommandBuilder(adapter);
					
	DataSet ds1 = new DataSet();

	adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
	adapter.Fill(ds1, "EMPLOYEE");
			
	adapter.Dispose();
	builder.Dispose();
	command.Dispose();
		
	connection.Close();


With this MissingSchemaAction set to MissingSchemaAction.AddWithKey 
FbDataReader.GetScemaTable will be called and without it not, this is 
the only difference that i found.


-- 
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] FbCommand problem ?

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

Hello:


> Unhandled Exception: 
> FirebirdSql.Data.Firebird.FbException: Dynamic SQL 
> Error
> SQL error code = -502
> Attempt to reopen an open cursor

Fixed in CVS, now when a DataReader is closed the FbStatement of his 
FbCommand will be closed too.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

[Firebird-net-provider] FbCommand problem ?

[Dumitru P. <pop...@ya...>]

The code:

FbDataAdapter myDA = new FbDataAdapter();

DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();

// setup myDA ...

myDA.Fill(ds1);
myDA.Fill(ds2); // <-- exception

generates an exception:

Unhandled Exception: 
FirebirdSql.Data.Firebird.FbException: Dynamic SQL 
Error
SQL error code = -502
Attempt to reopen an open cursor



__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

[Firebird-net-provider] Slowdown with MissingSchemaAction.AddWithKey

[Christoph D. <cd...@ii...>]

Thanks for the great database driver!

If I use MissingSchemaAction.AddWithKey before I do Adapter.Fill it can take
up to four seconds to do the fill but when I don't use AddWithKey it takes
much less than a second.  This occurs on a 1Ghz windows 2000 box with the
database local and with a 750Ghz 98 box with the database remote.

It seems to work fine on an 1.7Ghz XP box with the database local.

Are you seeing the same kind of results.  Is there anything that can be done
to speed up this process?


Christoph

Re: [Firebird-net-provider] Using MS VS.NET with Firebird Net Provider

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

Hello:

> Hello,
> 
> I've been using the Firebird NetProvider programatically and it works 
> fine.  I'm just wondering though -- how do I make it appear under the 
> "Server Explorer's Data Connections"?  When I right click that treeview 
> item, I get the "Data Link Properties" dialog box which lists several 
> OLE DB Providers and the native SQL Server Connection tab.  How do I 
> "register" the Firebird NetProvider on this dialog box (assuming its 
> possible)?

As i know this can only be made with OleDb....




-- 
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] Performance tests - Comparision between Firebird 1.0 and Firebird 1.5 Alpha 5 ( Windows 2000 )

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

Hello:


I have made a comparision between Firebird 1.0 and Firebird 1.5 Alpha 5 
( Windows 2000 ), the results are attached to the email as a PDF file, i 
will try now to port Multi USer Tests.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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