Re: [Firebird-net-provider] FirebirdSql.Data.Services demands SYSDBA to list users, where RDB$ADMIN insufficient?

2017-02-24 Thread David Carr
have an effect and even if logged in with role RDB$ADMIN, only the given user is returned (other than if SYSDBA). Thoughts? Is there any way to list the users? If not, can it be added as a features that if logged in with RDB$ADMIN role, that the users can be listed? Thanks, David On 24 Feb

[Firebird-net-provider] FirebirdSql.Data.Services demands SYSDBA to list users, where RDB$ADMIN insufficient?

2017-02-23 Thread David Carr
er other than SYSDBA? More to the point, I want to create users who have administrative function on the database (ie CREATE/DROP users) so that the SYSDBA user (and its password) are not in use/shared. But I need to be able to enumerate the list of users (eg FbSecurity.DisplayUsers()). Thanks in a

Re: [Firebird-net-provider] FBUserData create new

2016-11-17 Thread David Carr
v5.6.0. Thanks, David On 1/8/2011 6:41 AM, Jiri Cincura wrote: > On Sat, Jan 8, 2011 at 14:14, Rick Roen < rick-tsx8mbjbjz1y5zq7n0bltdbpr1lh4...@public.gmane.org> wrote: >> What is the RoleName used for here? > > It does nothing. It's in API, but currently it's no

Re: [Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs

2016-11-09 Thread David Carr
Thanks for getting back to me. Can you or anyone please let me know what is the recommended approach in the ADO.NET provider for performing a transaction across, let's say, 2 databases (eg a single command in each)? On 5 November 2016 at 08:37, Jiří Činčura wrote: > I don't think the Transactio

[Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs

2016-11-04 Thread David Carr
the connection but that doesn't seem to matter. Is the approach taken below the recommended flow? Any tips/ideas would be welcome. Best regards, David using (System.Transactions.TransactionScope scope = new System.Transactions.Transaction

Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 125, Issue 1

2016-09-06 Thread david
Sorry I missed you e-mail but I'm currently on leave. I will return to the office on Monday the 13th of September For all support inquiries please contact the office on +353 (0)1 5253600 or +44 (0)203 4681247 Alternatively please email supp...@navitassoftware.com . Kind Regards,

Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 109, Issue 7

2015-05-19 Thread david
Sorry I missed you e-mail but I'm currently on leave. I will return to the office on Monday the 25th of May For all support inquiries please contact the office on +353 (0)1 5253600 or +44 (0)203 4681247 Alternatively please email supp...@navitassoftware.com . Kind Regards,

Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 101, Issue 2

2014-09-14 Thread david
Sorry I missed you e-mail but I'm currently on leave. I will return to the office on Monday the 15th of September For all support inquiries please contact the office on +353 (0)1 5253600 or +44 (0)203 4681247 Alternatively please email supp...@navitassoftware.com . Kind Regards,

Re: [Firebird-net-provider] Unique Constraint Exception thrown when it shouldn't

2014-03-23 Thread David De Smet
Hi Jiri, It was indeed a violation of unique constraint. However, specifying Dialect 3 worked without any problem. Thank you, David On Thu, Mar 20, 2014 at 1:59 AM, Jiri Cincura wrote: > What's the complete message? Isn't it a violation on PK? > > > -- > Jiri {x

Re: [Firebird-net-provider] DB Type decimal is not returning as decimal

2014-03-23 Thread David De Smet
ted again the DB using dialect 3 and it is working without any problem. The return value is not decimal. Btw, is there a reason why the dialect defaults to 1 instead of 3 when using FbConnectionStringBuilder? Thank you, David On Thu, Mar 20, 2014 at 4:05 AM, Mark Rotteveel wrote: > On Thu, 2

Re: [Firebird-net-provider] DB Type decimal is not returning as decimal

2014-03-20 Thread David De Smet
or long if coding in C#. I'm using Firebird Embedded. David De Smet Message sent from my iPhone > On 20/03/2014, at 02:00, Jiri Cincura wrote: > > What's the datatype in DB and what's in your model? Very likely you > have a mismatch there. > > > -- >

[Firebird-net-provider] DB Type decimal is not returning as decimal

2014-03-19 Thread David De Smet
Good day, I'm using version 4.1.0.0 for .NET 4.5/4.0 with Entity Framework support of the Firebird ADO.NET Data Provider. I'm experiencing an InvalidCastException when trying to get a value of a field which I assigned the DB type as decimal. Looking further into the problem I'm seeing that the r

[Firebird-net-provider] Unique Constraint Exception thrown when it shouldn't

2014-03-19 Thread David De Smet
Good day, I'm using version 4.1.0.0 for .NET 4.5/4.0 with Entity Framework support of the Firebird ADO.NET Data Provider. And I'm getting this exception when it shouldn't. Let me further explain: I have a table *Product*, with *Code* field which is unique and with DB type as VarChar. When I sav

[Firebird-net-provider] [FB-Tracker] Created: (DNET-314) Incompatible with Interbase DB 7.5 SP1?

2010-04-27 Thread David (JIRA)
Versions: 2.5.2 Reporter: David Assignee: Jiri Cincura Hi, I use Version 2.5.2 of the .NET Provider to connect to a Interbase Database (7.5 SP 1). In previous versions this worked well. I had to upgrade, because I need Entity Framework compatibility. But the latest

Re: [Firebird-net-provider] Auto-Reply: Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-Reply:Auto-R

2009-10-13 Thread David Clegg
Isn't there a list admin who can kick this guy off? -Original Message- From: Le Phuc [mailto:lep...@tonyvn.com] Sent: Wednesday, 14 October 2009 10:10 a.m. To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Auto-Reply: Auto-Reply:Auto-Reply:Auto-Reply:Auto-R

[Firebird-net-provider] How does the FB provider handle large blob field updates?

2009-09-28 Thread David Clegg
How does the Firebird provider handle large blob field updates? Does it cache the entire data in memory before writing to the database, or is it possible to have the data sent to the database in smaller chunks? -- Come bu

Re: [Firebird-net-provider] Using the .NET provider withInterbasedatabases

2009-09-21 Thread David Clegg
it certainly seems possible at this stage. Cheers, David Clegg. _ From: David Clegg [mailto:dcl...@gmail.com] Sent: Tuesday, 22 September 2009 9:01 a.m. To: 'For users and developers of the Firebird .NET providers' Subject: RE: [Firebird-net-provider] Using the

Re: [Firebird-net-provider] Using the .NET provider withInterbasedatabases

2009-09-21 Thread David Clegg
I already do use the Embarcadero driver, but it only has 32 bit support, and I am in a position where I need to deploy access from a bunch of 64 bit servers. I can configure the web apps to run in a 32 bit worker process, but I am looking to avoid that if possible. Cheers, David Clegg

[Firebird-net-provider] Using the .NET provider with Interbase databases

2009-09-21 Thread David Clegg
Is it possible to use the Firebird .NET provider with Interbase databases at all (in my case, I need to talk to an Interbase 2009 database)? All my attempts so far have failed, with an exception being raised on connection when the database version is attempted to be read. Cheers, David Clegg

Re: [Firebird-net-provider] ExecuteNonQuery with sproc doesn't return

2007-04-14 Thread David Brink
Like I said in my original post, using CommandType.StoredProcedure returns -1. Executing a stored procedure using the same syntax via FlameRobin also displays "0 row(s) affected." Is it a problem with the database, not the provider? On 4/14/07, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:

[Firebird-net-provider] ExecuteNonQuery with sproc doesn't return rows affected

2007-04-13 Thread David Brink
Using Firebird embedded 2.0.1 and 27th Oct 2006 Data Provider for .NET 2.0 When using stored procedures via the EXECUTE PROCEDURE statement, ExecuteNonQuery does not seem to be returning the number of rows affected. CommandType is set to Text then ExecuteNonQuery returns 0, if set to StoredProced