Hi,
There is exception message in Firebird .NET provider:
"Connection must valid and open"
I'm not big expert in English, but I think it should be changed to:
"Connection must be valid and open"
P.S. I see that it comes from Microsoft's .NET providers template:
http://msdn.microsoft.com/en-us/li
sasha wrote:
> Today i tried to connect to stopped server (FB 2.1 RC1) and got en error:
>
> FirebirdSql.Data.FirebirdClient.FbException: No message for error code
> 335544721 found.
It looks like the same is happening with any error. 2.5alpha2 provider
shows digital error codes instead of mes
Jiri Cincura wrote:
>> linux makefile in the sources archive is broken - it looks like it was
>
> I think, it generates wrong file at all. :) The makefile isn't
> maintained long time (new files etc.). I'm looking for some global
> solution...
Why do you think about nant? It allows building for
Jiri Cincura wrote:
the new version of FirebirdClient (ADO.NET Data Provider) is available
for download: http://firebirdsql.org/index.php?op=files&id=netprovider
linux makefile in the sources archive is broken - it looks like it was
edited with some html editor. I've attached fixed version. I
Jiri Cincura wrote:
>> reader.HasRows()". About the breaking change, do you really think is
>> anybody relying on a method that always return true? And if it was the
>
> Not always. From some time it returns true only for selects. But it
> cannot be changed in a second, no matter how it's now,
Dean Harding wrote:
> Instead of just returning true, couldn't you just attempt to fetch the
> first row? If there's no row, you can return false. If there's a row,
> you'll fetch it (and you'll have to cache it so the first call to
> MoveNext() works) and return true.
It sounds very reasonabl
Aitor Gómez González wrote:
> which one? I've tried several ones "NONE", "UNICODE_FSS",... with no
> success.
I believe that UNICODE_FSS is deprecated, use UTF8 instead.
--
Oleg
-
This SF.net email is sponsored by: Micro
Jiri Cincura wrote:
>> On my LAN the same code is OK. This issue just happens
>> on my VPN clients and just with Date/DateTime fields.
>
> So it's the problem of VPN. FirebirdClient has no idea, that you're
> using VPN or any other tunel. The connection is done in same way.
Moreover, I'm using O
Oleg Deribas (JIRA) wrote:
> After error in transaction with "INSERT ... RETURNING" clause, and
> then rollback, any further transactions are failing with "invalid
> request handler" exception.
It looks like the same bug appears with non-selectable procedures calle
Versions: 2.5.0 Alpha 1
Environment: Latest .NET Provider 2.5 from
http://netprovider.cincura.net/ (12-Jan-2008)
Firebird 2.1 RC1 x86_64 on Suse Linux
Reporter: Oleg Deribas
Assignee: Jiri Cincura
Attachments: FirebirdTest.cs
After error in transaction with
Carlos Guzmán Álvarez wrote:
> FirebirdClient 2.1.0 for .NET 2.0 is available for download.
>
> Download information can be found here:
> http://www.firebirdsql.org/index.php?op=files&id=netprovider
Will there be version compiled with mono?
BTW this page: http://firebirdsql.org/index.php?op=de
I've just tested my simple application with provider 2.5.0alpha1 and
Firebird 2.1beta1 via relatively slow connection (VPN over 512/128Kbit
ADSL). Average ping to the firebird host from the application host is
433ms with this connection.
Just replacing FirebirdClient-2.0.1 with FirebirdClient-
Hello,
Mercea Paul said the following on 02.07.2007 21:08:
> Could Fb.Net Provider have release number specific to Firebird server?
> If Current provider support all facilities for FB 2.1 Beta 1, could have
> same release number as fb server (2.1)? It's more easy to know what provider
> is compat
Hello,
Sean said the following on 11.06.2007 23:57:
> I am using FB 1.5.4 and ADO.NET provider 2.0.1. The select doesn't have
> explicit transaction.
I'd recommend always using explicit transactions.
And use FbTransactionOptions.Read | FbTransactionOptions.ReadCommitted
for read-only transact
Hello,
Jiri Cincura said the following on 02.05.2007 13:29:
>> FirebirdSql.Data.Client.Embedded -> FirebirdSql.Data.Client.Native
>
> Should be in this word "embedded" too? To not confuse programmers.
Native protocol implementation could be used to access regular (not
embedded) servers also. S
Hello,
Carlos Guzmán Álvarez said the following on 01.05.2007 15:36:
> For the new GDS implementation, my first thought is that we can make all
> the public methods on the current GDS implementation virtual, and
> override ( and rewrite ) them in the new GDS implementation
Shouldn't these two
Hello,
sasha said the following on 28.02.2007 12:07:
> 2) As i understood from sources windows "fbclient.dll" called
> "libfbclient.so" on linux, so for same mono program i'll need different
> versions of provider for windows and linux.
It is not the case, as mono provides a library mapping me
Hello,
sasha said the following on 08.01.2007 20:31:
>> Change just record you have updated.
>
> Again.
> 3) Right click on table adapter and choose "Add query"
Oops. You didn't mention any right clicks before. I don't use right
clicks when coding, so, sorry, I can't advice here ;-)
--
Oleg
Hello,
sasha said the following on 08.01.2007 16:58:
>> How do you generate insert commands? I doubt that you could generate
>> INSERT ... RETURNING command, as .NET provider should support firebird
>> versions older than 2.0, so you should use INSERT ... RETURNING manually.
>
> And make refresh
Hello,
sasha said the following on 08.01.2007 15:57:
>> Use IDataAdapter's RowUpdated event.
>
> And whar next? Fill new dataset and merge it with existing?
It's up to you ;-)
>> Why would you need this when you could use INSERT ... RETURNING?
>
> It's not clear for me how to return values fr
Hello,
sasha said the following on 08.01.2007 15:26:
> 1) For example i posted UPDATE command for record. Some fields of record
> was changed in triggers inside databse, so i need refresh record from
> database right after update. In delphi i has RefresSQL command for this.
>
> How does it wor
Hello,
Carlos Guzmán Álvarez said the following on 24.12.2006 14:16:
>> But NHibernate has FirebirdClientDriver only in 1.2 version which is
>> currently is beta.
> Yes, but i think it should be possible to get the nhibernate stable
> sources add the FirebirdClientDriver to them
> and do the bui
Hello,
Carlos Guzmán Álvarez said the following on 24.12.2006 12:23:
> NHibernate has 2 drivers for the firebird provider one FirebirdDriver (
> 17 and previous versions of the provider)
> and FirebirdClientDriver ( for 2.0+)
But NHibernate has FirebirdClientDriver only in 1.2 version which is
Hello,
Jiri Cincura said the following on 15.12.2006 10:35:
> You're absolutely wrong. OleDb isn't for others.
And it is true.
> If you want to be right in ADO.NET, you have to use native providers
> (MS SQL, Oracle, FB, ...) and avoid using common (Ole, ODBC, ...).
> For independent code, you
Hello,
bear007 said the following on 13.12.2006 8:26:
I'd add read-only transaction options to the code in order to lower
server's load:
> FbCommand cmd = new FbCommand();
> cmd.CommandText = "Select * from Table where POSTAL_CODE = 84652";
> cmd.Connection = conn;
cmd.Transaction = conn.BeginT
There is isc_dpb_num_buffers parameter in the Firebird API which allows
to specify number of cache buffers when connecting to database. It is
very usable with classic server, so it is possible to have separate
connection with large cache for big tasks.
Is this parameter supported in .NET provider
Hello,
Carlos Guzmán Álvarez said the following on 20.10.2006 20:33:
>> Maybe it is time to include it in the mono's build? Now it is possible
>> to have 1.7.x provider for mono 1.0 profile, and 2.0.x provider for the
>> mono 2.0 profile...
> For we will need to talk with miguel or request it in
Hello,
Carlos Guzmán Álvarez said the following on 27.10.2006 17:33:
> Next release will be 2.1.0.
There are some changes in 2.1 firebird was made to improve remote
protocol speed. It was mentioned in the 25 May 2006 record here:
http://www.firebirdsql.org/index.php?op=devjournal&id=djarchive&
Hello,
Carlos Guzmán Álvarez said the following on 27.10.2006 19:20:
>> Carlos, could you please look at DNET-68 issue in tracker.
>> I've created simplistic testcase and attached all needed files to see
>> the bug.
>
> It should be fixed in CVS now.
Thanks, Carlos. I'm not sure why, but source
Hello,
Carlos Guzmán Álvarez said the following on 27.10.2006 17:33:
> Next release will be 2.1.0.
Carlos, could you please look at DNET-68 issue in tracker.
I've created simplistic testcase and attached all needed files to see
the bug.
--
Oleg
Hello,
Carlos Guzmán Álvarez said the following on 20.10.2006 20:33:
>> And it said that 1.1.18 is last release before Mono 1.2.
> Huummm v2.0 sources looks as building fine with the latest mono ... i'm
> going to run the
> nunit test suite now ... if it runs fine next versions will have mono
>
Hello,
Carlos Guzmán Álvarez said the following on 02.09.2006 20:55:
> I have no problem with that, while i think it's better to include only
> the v2.0 of the provider
> in the mono 2.0 profile, but anyway i think that should be decided by
> the mono people.
I've tried today to build provider
Hello,
I'm wondering about how provider handles connection pooling if there are
connections with the different roles from the same application?
I think in Firebird role handling is different from MS SQL server, here
role should be specified in connection string, and role is in fact
property of co
Hello,
Carlos Guzmán Álvarez said the following on 06.10.2006 17:36:
> I'm thinking on doing a change in the provider to make a trim on char
> values returned by selectable commands.
I don't think it is good idea. It would just add hidden logic to the
provider. If I will need such a behavior -
Hello,
John Smith said the following on 05.10.2006 21:37:
> Ok all of my routines that access the database do call the dispose method.
> The problem still seems to exist. There is only 1 database connection to the
> database right now but there are multiple threads accessing the Connection.
>
Hello,
Jiri Cincura said the following on 03.10.2006 14:35:
>> It would be nice to have builds for both 1.7 and 2.0 branches for all
>> supported platforms - netcf2.0, mono 1.1 and 2.0 profiles ... ;-)
>
> If you provide some machine with mono, there's no problem. ;)
If you're using nant, it co
Hello,
Jiri Cincura said the following on 01.10.2006 0:39:
> Now you can find on http://netprovider.cincura.net , weekly builds of
> ADO.NET provider from 2.0 sources. DDEX provider. And BDP (.NET 1.1).
>
> Any comments or reports are welcome.
It would be nice to have builds for both 1.7 and 2
Hello,
Jiri Cincura said the following on 07.09.2006 4:54:
>> System.DllNotFoundException: Unable to load DLL 'fbembed': The specified
>> module
>> could not be found. (Exception from HRESULT: 0x8007007E).
>
> System is not able to load the library. Put it into some dir, where your
> framework
Hello,
Emiliano Sutil said the following on 06.09.2006 14:12:
> isnt there any way to use Firebird 2.0 with mono to solve this or is
> better that I use Firebird 1.0 and use the clases without the visual
> components?
You can use firebird 2.0 with mono via provider 1.7.
Personally, I've never u
Hello,
Emiliano Sutil said the following on 06.09.2006 13:33:
> If I run the application without mono it runs ok. So is there any
> incompatibilty with Firebird provider and mono?
It is currently possible to use provider's 1.7 version with mono.
--
Oleg
---
Hello,
Carlos Guzmán Álvarez said the following on 02.09.2006 20:04:
>> No news here? I've checked recently released mono 1.1.17 but it seems
>> that there are not firebird provider for mono 2.0 profile yet ;-(
>>
> http://lists.ximian.com/pipermail/mono-devel-list/2006-August/019919.html
Tha
Hello,
Carlos Guzmán Álvarez said the following on 20.08.2006 12:44:
>> They've tried to do it, and it compiles now, but they removed it from
>> compile process for mono 2.0 profile just because it have the same
>> AssemblyVersion for both profiles.
>>
>> See comments to revisions 63892 and 63919
Hello,
Carlos Guzmán Álvarez said the following on 09.08.2006 18:11:
>> But is it possible to compile at least old 1.7.1 provider with gmcs?
>>
> Haven' t tested it but i think it should be possible to do so.
They've tried to do it, and it compiles now, but they removed it from
compile proces
Hello,
Carlos Guzmán Álvarez said the following on 03.07.2006 21:03:
> Here is the result of the build using Mono 1.1.1.13.8
> In .NET 2.0 looks like there are no Scale and Precision properties in
> the DbParameter class.
But is it possible to compile at least old 1.7.1 provider with gmcs?
I'm
Hello,
Juanma fernandez said the following on 12.07.2006 13:29:
> Hi, I refer to the total length of data. For example, If the column
> is a varchar(10) and I am storing the the the string HELLO, from
> client to server via network is sent HELLO plus 5 blank spaces or
> only HELLO?
No, server d
Hello,
Carlos Guzmán Álvarez said the following on 03.07.2006 21:03:
>> That doesn't depend on me only ;) but first i want to see what is the
>> status of ado.net 2.0 in monmo, after that i will talk with mono people
>> to see the possibilty of include v2.0 in mono
>
> Here is the result of th
Hello,
Carlos Guzmán Álvarez said the following on 03.07.2006 17:50:
>> So it isn't included in rpm's provided on mono-project.com site?
> The version for .net 2.0 no, the one for 1.1 yes
Is there any plans to include version for .net 2.0 in mono distribution?
--
Oleg
Using Tomcat but need to
Hello,
Carlos Guzmán Álvarez said the following on 30.06.2006 16:36:
> It should work on linux or windows with mono but it will depend on the
> state of the ado.net 2.0 implementation in mono.
So it isn't included in rpm's provided on mono-project.com site?
--
Oleg
Using Tomcat but need to d
Hello,
Carlos Guzmán Álvarez said the following on 23.06.2006 18:00:
> FirebirdClient v2.0 for Microsoft .NET 2.0 and mono is available for
> download.
Thanks, Carlos.
By the way, I didn't found CHM documentation after install. Will it be
available separately?
--
Oleg
Using Tomcat but need to
Hello,
Carlos Guzmán Álvarez said the following on 15.05.2006 17:23:
> 2. Are you having any error that is not fixed yet ??
Are you still using "fbembed.dll" instead of "fbclient.dll" for
ServerType=1 ?
--
Oleg
---
Using Tomcat but need to
Hello,
Fabio Gomes said the following on 27.04.2006 20:44:
I tryied with cmd.ExecuteNonQuery(), but it seens that it just returns
the number of affected rows with a DELETE, UPDATE or INSERT, it aways
returned -1 with my select.
Use cmd.ExecuteScalar()
--
Oleg
Hello,
Marvin Cook said the following on 22.04.2006 7:26:
> I am using Firebird-2.0.0.12484-0-Win32.exe,
> FirebirdNETProvider-1.7.1.exe, VS2005 C#
>
> I changed the connection string and get the error shown below. I guess
> I don't know how to add the fbembed.dll to my project. Your help is
>
Hello,
Charles Urbina said the following on 18.04.2006 17:57:
> [FbException (0x80004005): Dynamic SQL Error
> parameter mismatch for procedure INSERT_RESERVATION]
It is the cause of error.
Replace this:
> FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
> INSERT_RESERVATION", myConnecti
Hello,
Charles Urbina said the following on 18.04.2006 17:57:
> [FbException (0x80004005): Dynamic SQL Error
> parameter mismatch for procedure INSERT_RESERVATION]
It is the cause of error.
Replace this:
> FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
> INSERT_RESERVATION", myConnecti
Hello,
Carlos Guzmán Álvarez said the following on 11.04.2006 11:49:
>> Well, another user was having the same problem with RC 1 but looks
>> like it was working with Beta 2
>
> Fixed in CVS the problem was on the buffer size used when requesting the
> server version.
Thanks, Carlos. Will there
Hello,
Carlos Guzmán Álvarez said the following on 30.03.2006 21:23:
> So something has changed in the embedded server since beta 2 can you
> send this issue to the fb-devel list
OK I'll try to ask. But can't this exception be debugged inside of
provider's sources?
> explaining what you are do
Hello,
Carlos Guzmán Álvarez said the following on 30.03.2006 18:55:
>> It seems that .NET provider 1.7.1 doesn't work with embedded firebird
>> 2.0rc1 (from Firebird-2.0.0.12484-0_embed_win32.zip).
>> There is the following exception when connecting to database:
> It works against Fiebird 1.5 ?
Hello,
It seems that .NET provider 1.7.1 doesn't work with embedded firebird
2.0rc1 (from Firebird-2.0.0.12484-0_embed_win32.zip).
There is the following exception when connecting to database:
Unhandled Exception: System.IndexOutOfRangeException: Index was outside
the bounds of the array.
at F
Hello,
Carlos Guzmán Álvarez said the following on 11.03.2006 1:44:
>> Thanks i think i have a fix for this but will be applied only on v2.0=20
>> sources for now. Thanks very much
>
> Changes are in CVS.
It seems that you're introduce new bug, while fixing that:
Now it is:
else if (fetchRe
Hello,
Carlos Guzmán Álvarez said the following on 11.03.2006 1:44:
Translating reply ;)
>> Thanks i think i have a fix for this but will be applied only on v2.0=20
>> sources for now. Thanks very much
>
> Changes are in CVS.
Thanks. Now it works. But its behavior still different from original
Hello,
Carlos Guzmán Álvarez said the following on 10.03.2006 17:53:
> A sample like this , looks as working:
I think it was meant something like this:
CREATE EXCEPTION TEST_EXCEPTION 'Test';
SET TERM ^ ;
CREATE PROCEDURE SP_EXCEPTION_TEST
RETURNS (
ID INTEGER)
AS
BEGIN
ID = 0;
WHILE
Hi Carlos,
There was message posted in russian-speaking newsgroup regarding this
bug. I've not checked it, just translating it for you ;-)
If "Fetch Size" of FbConnection is greater then 1, exception from server
will be lost except it will be generated on first record from "Fetch
Size" records bl
Hello,
I'm trying to use FbSecurity with Firebird 2.0beta2 and .NET provider
1.7b. When I try to call FbSecurity.DisplayUsers() - I have the
following exception:
"Cannot attach to services manager
service myhostname:service_mgr is not defined"
I use classic server on linux. When I'm doing the s
Hello,
Carlos Guzmán Álvarez said the following on 03.03.2006 19:59:
works firebird .NET provider if firebird server are on Linux server?
the client program is on windows system
Yes it should.
Sure it works.
But I've tried to use firebird .NET provider as client on mono platform
and it not
Hello,
leebo leebo said the following on 03.03.2006 21:09:
Thank you for your response. Yes I am using triggers. With Firebird
provider, wh at is the best method to then get that generated value once
it's inserted. I don't remeber firebird having an IDENTITY_SCOPE()
field like in SQL Serve
Hello,
Carlos Guzmán Álvarez said the following on 28.02.2006 23:32:
There is FbCommand.FetchSize property, but it is not much documented.
Is there any recommendations for using this property?
The value of the property os used for selectable commands, to set the
number of rows that will be f
Hello,
There is FbCommand.FetchSize property, but it is not much documented.
Is there any recommendations for using this property?
Maybe someone have experience with this?
--
Oleg
---
This SF.Net email is sponsored by xPML, a groundbreaking
Hello,
Roger Pullen said the following on 19.02.2006 23:17:
I am trying to use firebird parameters to insert a decimal value into a
numeric field in a Firebird table using the firebird .net 1.7 provider.
http://sourceforge.net/mailarchive/message.php?msg_id=13480849
Isn't it the same problem
Hello,
Carlos Guzmán Álvarez said the following on 23.01.2006 20:41:
But it just doesn't work as fbembed.dll
And README_embedded.txt clearly states that it should be renamed to
fbclient.dll ...
Ok, i will try to check that, anyway it states that for all cases or
only when udf are needed ??
Hello,
Carlos Guzmán Álvarez said the following on 23.01.2006 16:35:
But fbudf.dll provided with firebird depends on fbclient.dll so it
should be installed along with fbembed.dll to make fbudf usage
possible. The same with third-party UDFs.
Maybe provider's default should be changed for fbc
Hello,
There is a problem with the embedded firebird and .NET provider.
Quoting FAQ
http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=faq#5 :
"The provider will look by default (unless the assembly was built using
the GDS32, FBCLIENT or VULCAN defines) for the fbembed.dll.
The
Vince McCloud wrote:
Hi, i know how add users in firebird from .NET Application, but i dont
know how grant privileges at the same time that are created. If somebody
can help me, i appreciate so much your help.
There is nothing special with .NET Provider in this case. You should
just read in
Vince McCloud wrote:
Hi, i wanna know if there's some way for create a user in firebird from
.NET application via stored procedure or udf.
Sure. But you do not need sp and udf.
Just use FirebirdSql.Data.Firebird.Services namespace.
FbSecurity class in particular:
http://www.dotnetfirebird.or
Carlos Guzmán Álvarez wrote:
And it was interesting for me that: "The core sqlite3 codebase and the
ADO.NET wrapper are combined into one multi-module assembly."
Is it possible with embedded Firebird to create such multi-module
assembly?
Any clue about where to find docs about that multi-mo
Hi,
Today I've exprerimented with SqLite .NET provider:
http://sourceforge.net/projects/sqlite-dotnet2/
And it was interesting for me that: "The core sqlite3 codebase and the
ADO.NET wrapper are combined into one multi-module assembly."
Is it possible with embedded Firebird to create such m
Madhu Sasidhar wrote:
I get the following FbException:
"cannot attach to password database".
I have a fresh install of Version 2 b 1. The /bin directory has
security2.fdb and no other (such as security.fdb). I have not run script to
migrate users/passwords from my old security.fdb.
I think t
Carlos Guzmán Álvarez wrote:
As .net 2.0 is yet here i think we should stick to the .net cf 2.0 ;)
By the way, do you have plans to release stable 1.7a version for .NET
2.0 release?
--
Oleg
---
This SF.Net email is sponsored by the JBos
Carlos Guzmán Álvarez wrote:
I'm looking for a Firebird provider running with the compact framework
1.1.
In the 1.7 archive, the sources cannot compile with 1.1 (with vs2003).
Is there a compiled version somewhere ?
No, the sources aren't compatibles with netcf 1.1
What should be changed to
78 matches
Mail list logo
