Re: [Firebird-net-provider] INSERT work but nothing do...

[Mark Rotteveel]

On 29-5-2011 15:24, wiwian wrote:
 Hi
 I have autocommit and dont need insert this (Inserting commit nothing
 do)... I write the same in Borland C++ and all work perfect without commit:

 Form2-pFIBQuery1-SQL-Text=INSERT INTO TEST (NUMER...) VALUES
 ('NUMER',...);
 Form2-pFIBTransaction1-StartTransaction();
 Form2-pFIBQuery1-ExecQuery();


You are explicitly starting a transaction, if you do then you also need 
to commit.

-- 
Mark Rotteveel

--
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery, 
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now. 
http://p.sf.net/sfu/quest-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Deadlock problem (possible: DNET-382)

[Mark Rotteveel]

On Thu, 29 Sep 2011 15:40:52 +0100, Scott Morgan bl...@blueyonder.co.uk
wrote:
 Think this might be related to 
 http://tracker.firebirdsql.org/browse/DNET-382
 
 I've been hitting a deadlock between the GC and main threads.
 
 Examining it I've seen that the main thread calls FbTransaction.Rollback

 which, in sequence, locks:
 1. The transaction object itself
 2. database.SyncObject
 3. A GdsStatement object
 
 Whilst the GC thread is calling FbCommand.Dispose, which locks:
 1. The command object
 2. The same GdsStatement object as above
 3. database.SyncObject
 
 (call stacks at end of mail)
 
 Obviously there's a race condition here, between the statement and the 
 SyncObject.
 
 As a temporary fix I changed all locks to refer to the 
 database.SyncObject, which isn't pretty in terms of scaling, but does 
 remove the deadlock.
 
 A better solution might involve adding a transaction synch object, not 
 sure though, as I haven't really had the time to go through the code
fully.

The solution would at minimum require that FbCommand.Dispose sync in the
exact same order as Rollback (so first database.syncObject, and then
GdsStatement) (or that Rollback use the exact same order as in Dispose).
Then it is impossible for deadlock to occur (assuming that the transaction
isn't locked further on the Dispose method).

Mark

--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Deadlock problem (possible: DNET-382)

[Mark Rotteveel]

On 29-9-2011 17:37, Scott Morgan wrote:
 On 09/29/2011 04:20 PM, Mark Rotteveel wrote:
 The solution would at minimum require that FbCommand.Dispose sync in the
 exact same order as Rollback (so first database.syncObject, and then
 GdsStatement) (or that Rollback use the exact same order as in Dispose).
 Then it is impossible for deadlock to occur (assuming that the transaction
 isn't locked further on the Dispose method).

 Easier said than done, the locks are made at different points in the
 code, not all in the one function. See the call stacks at the end of the
 original message.

True, but making sure that you always lock resources in the same order, 
is the only sure way to prevent deadlocks.

 Worth noting also that there are a lot of 'lock(this)' entries, which is
 something MS recommends against in it's docs.

I know next to nothing about .NET, I just follow this list as I recently 
started working on Jaybird and things posted here might have similar 
problems or applications in Jaybird :)

-- 
Mark Rotteveel

--
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2dcopy2
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Interbase 6

[Mark Rotteveel]

On Tue, 27 Mar 2012 10:25:25 +0800, Gilbert
gilbert...@insolvesolutions.com.my wrote:

 One of my client still using the interbase 6 version and found that the
 database size is about 7GB. 
 
 1)  One of the table believe is corrupted. Any command just to fix
that
 table instead of whole database ?
 
 2)  The table data can be view but when trying to delete old data,
it
 take more 2 days to delete data old than 2010 but not fail.
 
 3)  I tried to do backup and restored hope can recover but not luck.

Your question is better suited for the firebird-support mailinglist. See
http://www.firebirdsql.org/en/mailing-lists/ for subscription details.

Mark

--
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] exception FirebirdSql.Data.FirebirdClient.FbException: validation error for column *** unknown ***, value *** null ***

[Mark Rotteveel]

On 1-5-2012 11:25, Niels van Aert wrote:
 Hello,

 We have made C# (.NET) application that is using Firebird embedded V2.5.0

 We using ADO.NET and the BLtoolkit as interface to the Firebird database.

 And sometimes at random times I get the follow exception
 FirebirdSql.Data.FirebirdClient.FbException: validation error for column
 *** unknown ***, value *** null ***

 I haven’t any idea what this exceptions means!?!

 I’ve search on the internet for hours but I didn’t find something about
 this specific exception.

 This exception is always occurring during the executing of a stored
 procedure.

 Why is the column Unknown?

 Please, can somebody give me any hint?

 thanks in advance.

 Best regards,

 Niels

Why is this the same message as you originally posted to 
Firebird-support? Did you do anything with the advice that Helen gave as 
to the cause of this error?

If this occurs with a stored procedure, what happens if you execute it 
by hand from ISQL with the same input?

Mark
-- 
Mark Rotteveel

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Switching to C# 5 compiler

[Mark Rotteveel]

On Thu, 26 Jul 2012 12:16:48 +0200, Jiri Cincura disk...@cincura.net
wrote:
 HI *,
 
 if there are no objections, next Monday I'll switch .NET provider's to
 C# 5 compiler and VS2012.

I thought that VS2012 wasn't released yet. Is it wise to switch to
something unreleased?

Mark

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used

[Mark Rotteveel]

On 26-7-2012 19:58, Mr. John wrote:
 Hi !
 I just updated provider from version 2.5 to 2.7 but in Visual Basic
 immediate window I see all SQL command that provierder is working with
 during application run,I can see there lots of statements scrolling,that
 was not in previous version,can this be turned off ?
 here is a screenshot :
 http://img267.imageshack.us/img267/8185/screenshot001xa.jpg


See Jiri's blog: 
http://blog.cincura.net/232603-improved-command-logging-in-ado-net-provider-for-firebird-part-2/


-- 
Mark Rotteveel

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] (no subject)

[Mark Rotteveel]

On Wed, 29 Aug 2012 09:12:46 -0300, Roberto Carlos | Unimed
roberto.car...@unimed-online.net wrote:
 How do I install Firebird. NET Provider in visual studio 2012?
 Firebird. NET Provider is already supporting. NET 4.0 and 4.5?

Did you realise you just replied all to a spam message and thus sent your
question to all other addressees of that spam message?

Mark

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DDEX 2.0.6 release

[Mark Rotteveel]

On Tue, 4 Sep 2012 14:02:37 +0200, Jiri Cincura disk...@cincura.net
wrote:
 On Tue, Sep 4, 2012 at 1:51 PM, Miroslav Hrázský mhraz...@gmail.com
 wrote:
 Is there any reason to move  FB DDEX registry keys from

  HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VisualStudio\11.0\

 to

 HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\11.0_Config\ ?

 I'm curious because for me (Win7 64) the former works without any
 problems.
 
 Didn't work for me. Win7 32bit + VS RC  RTM; Win8 32bit  64bit + VS
 RTM (clean install)

Wow6432Node doesn't exist on 32 bit windows. And AFAIK 32 bit applications
on a 64 bit Windows will be redirected to Wow6432Node automagically. So an
attempt to read in HKEY_whatever\Software\ will actually read
HKEY_whatever\Software\Wow6432Node\ 

Mark

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Changing transaction isolation levels [huge break]

[Mark Rotteveel]

On 16-9-2012 7:53, Jiri Cincura wrote:
 On Sat, Sep 15, 2012 at 5:24 PM, Michael Ludwig mil...@gmx.de wrote:
 so why try faking it?

 Because sometimes you're using some tools, designers, wizards. And who
 knows why they will ask for ReadUncommitted. And if you can't change
 it, you'll be stuck.

What does the specification say (if there is such a thing)? For example 
the JDBC specification says the following:
It is possible for a given JDBC driver to not support all four 
transaction isolation levels (not counting TRANSACTION_NONE). If a 
driver does not support the isolation level specified in an invocation 
of setTransactionIsolation, it is allowed to substitute a higher, more 
restrictive transaction isolation level. If a driver is unable
to substitute a higher transaction level, it throws an SQLException.

In other words: upgrading to a higher isolation level is allowed if you 
don't support the lower level, downgrading is an error (because users 
expecting a high level of isolation won't get the guarantees they want, 
while users expecting a lower level of isolation - usually - don't mind 
if they get a higher level.

So to me treating ReadUncommitted as if it is ReadCommitted would be ok.

Mark
-- 
Mark Rotteveel

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://ad.doubleclick.net/clk;258768047;13503038;j?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Help with retrieving/binding image from database

[Mark Rotteveel]

On Fri, 2 Nov 2012 05:32:43 -0700 (PDT), Mr. John mr_joh...@yahoo.com
wrote:
 Hi !
  I'm using VB.2008 with FB 2.5/,Net provider version 2.7.7.0  
 
 I want  to save and retrieve/bind image from/to picture box control
 
 
 image database field : 
  F_IMAG      BLOB SUB_TYPE 1 SEGMENT SIZE 4096

BLOB SUB_TYPE 1 is a text blob (or clob), not a binary blob (that is just
BLOB or BLOB SUB_TYPE 0). Most likely the problem is related to that. Now I
am not entirely familiar with all intricacies of Firebird blobs, but as far
as I am aware, it is usually better to not specify a segment size.

Mark

--
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Firebird ADO.NET Data Provider 3.0.2 - installation ossue over VS 2010

[Mark Rotteveel]

On 22-12-2012 09:04, karasi wrote:
 Hello.
 I am trying to install Firebird ADO.NET Data Provider 3.0.2 over VS 2010. I
 use a readme from DDEX Provider. After all staps i am trying to add Data
 Source: Add New Data Source - Database - Dataset - New connection -
 Firebird Data Source
 After that Add connection dialog is showing, which is closing right i print
 any symbol in any field. By clicking Test Connection button i receave a
 message Test Connection Succeeded.
 Where is the problem? Please help. Thank you.

What is the problem? I don't see an actual problem described in your 
message.

Mark
-- 
Mark Rotteveel

--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] fbbackup

[Mark Rotteveel]

On Fri, 22 Mar 2013 13:48:21 +, Scott Price scott.pr...@virgin.net
wrote:
 You shouldn't need to perform a server shut-down to perform a restore, 
 and do not need to ever to perform a backup, though it's up to you if 
 you choose to.  What you would need to do is make sure all connections 
 to the database are closed.  If you are using the .NET ADO.NET provider 
 only, you will by default probably be using connection pooling.  As 
 such, you will likely need to have a call to
 
 FbConnection.ClearAllPools();
 
 That should drop all connections from the local perspective.  It will 
 not help with any other machines connected to the database however.
 
 After a short pause to let any kind of clean up that's required to 
 occur, you should be able to restore a database backup to that instance.

Shutting down a database means that the Firebird server will not accept
any connections for a specific database (or only accepts a single admin
connection). Depending on the exact config you can even force the server to
close existing connections. This is a much cleaner way than assuming that
the manual work to close connections is sufficient, or that your
applications is the only one to connect.

You can use FbConfiguration (in FirebirdSql.Data.Services) to shutdown a
database.

Mark

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] ClearAllPools and opened connections

[Mark Rotteveel]

On Wed, 17 Apr 2013 10:29:57 +0200, Jiri Cincura disk...@cincura.net
wrote:
 Hi *,
 
 I just found behavior that surprised me. Suppose pooling is on and
 (all connections to same database):
 Open connection1.
 Open connection2.
 Close connection2.
 FbConnection.ClearAllPools();
 Try to use connection1.
 
 On this ^ line you'll get exception as the connection1 was also
 cleared aka closed/disposed. I always used ClearAllPools with all
 connections closed so I had no idea it behaves like that.
 
 But do you think is correct? Should the ClearAllPools clear even the
 opened connections?

This behavior matches with my expectations for a method called
ClearAllPools(). Maybe you should keep the existing behavior and add a
method 'ClearAllPools(bool closeOpenConnections)' which allows explicit
control over this behavior.

Mark

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis  visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] ClearAllPools and opened connections

[Mark Rotteveel]

On Thu, 25 Apr 2013 10:16:33 +0200, Jiri Cincura disk...@cincura.net
wrote:
 How I'm thinking. The connections are normally in pool, when you're
 using some, it's not in pool (actually it's still in the pool's
 collection, but marked as used) logically. When you're cleaning all
 pools you are cleaning connections that are pooled (in pool). Hence
 connections not in pool should be untouched. At least that's what I
 think. On the other hand, this a huge breaking change. Not sure it's
 worth changing it. :\
 
 Also thinking from the other hand. If you have reference to some
 connection that's used and you'd like to close and clear all, why not
 to first close connections you're holding and then clean pools. Right?
 What's to reason to have method that would do it under your hands...

You could also see it from a different point: some part of your code is
misbehaving (ie not releasing connections back to the pool in a timely
fashion), being able to force all connections from the pool to close might
be a great way to detect (or mitigate) this problem.

Mark

--
Try New Relic Now  We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app,  servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] ClearAllPools and opened connections

[Mark Rotteveel]

On Thu, 25 Apr 2013 10:46:55 +0200, Jiri Cincura disk...@cincura.net
wrote:
 On Thu, Apr 25, 2013 at 10:27 AM, Mark Rotteveel m...@lawinegevaar.nl
 wrote:
 You could also see it from a different point: some part of your code is
 misbehaving (ie not releasing connections back to the pool in a timely
 
 Interesting. I would say why your code isn't going to be fixed in
 first place? And should the library offer tools for this in first
 place?

Maybe I am thinking too much from the Java concept of DataSources and
connection pools. There the connection pools (at least in application
servers) are - usually - not maintained by a single application, but by the
application server and applications are configured to access the datasource
by its name and request a connection. Connections requested from the pool
are still 'owned' by the connection pool and the connection pool can decide
to forcefully revoke a connection from a misbehaving 'client' (or a
'client' which takes too long to complete a piece of work). Also if the
administrator recycles/clears the connection pool this means that all
connections from the pool (including those currently checked out) can/will
be closed.

 fashion), being able to force all connections from the pool to close
 might
 be a great way to detect (or mitigate) this problem.
 
 Maybe it's wrongly stuck in my head. But I don't see these connection
 logically in pool (at that time). That's what steers me from it.

They may not be available in the pool, but to me they are still owned by
the connection pool.

Mark

--
Try New Relic Now  We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app,  servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Can not connect to Firebird 3.0 using .NETProvider-3.0.2.0

[Mark Rotteveel]

On 18-6-2013 07:41, Thomas Beckmann wrote:
 While connecting to FB 2.5 works fine, I'm getting username and password
 are not defined-error if I try to establish a connection to FB 3.0 via
 .NET-provider in VS 2012 or Entity Developer.

 I am surprised that the parameter names for the connection string that I
 have to fill in, obviously changed (compared to 2.5).

 The conncetion string generated looks as follows (username and password
 replaced):

 datasource=localhost;port=3051;database=D:\user\AMS\ASSCLOUD1.FDB;userid=***;
 password=***;role=ADMIN;charset=ISO8859_1;clientlibrary=C:\Program
 Files (x86)\srv\Firebird_3_0\fbclient.dll;dialect=3;servertype=Default

 A connection via isql or IBExpert works nicely.

 I'm using WI-T3.0.0.30435 Firebird 3.0 Unstable with W7/64 and
 32bit-version of DDEX-Provider for VS 2012.

 I'd really appreciate any hints!

By default Firebird 3 only allows you to connect using the new 
authentication and encryption mechanism. You have to enable legacy 
authentication first, by editing the firebird.conf:

AuthServer = Legacy_Auth, Srp, Win_Sspi

(make sure to remove the # prefix). I am not entirely sure, but you 
might need to add the user again to make sure the password is also 
available in the legacy format.

Mark
-- 
Mark Rotteveel

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Is boolean type (Firebird 3.0) supported by .NETProvider-3.0.2.0?

[Mark Rotteveel]

On 18-6-2013 11:26, Thomas Beckmann wrote:
 Fields of this type show unknown type in Entity Developer, but I don't
 know whether this is a problem of ED or of the .NET Provider.

 Thank you for any hints! Thomas

As far as I know the Firebird .NET provider 3.0 doesn't provide (full) 
support for Firebird 3.0 (that fact that both have version number 3.0 is 
just coincidence).

Mark
-- 
Mark Rotteveel

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Improving

[Mark Rotteveel]

On Wed, 3 Jul 2013 13:36:58 +0200, Jiri Cincura disk...@cincura.net
wrote:
 Yeah. I would need to discuss this with other project admins. So it
might
 not work at all. GitHub has support for organisations so that's even
better
 for project (the repo would be official).

SourceForge also provides a Git repo. Have you looked into that?

Mark

--
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] .NET provider Visual Studio 2010 solution

[Mark Rotteveel]

On Fri, 26 Jul 2013 05:40:12 +0500, Begench Amanov bama...@gmail.com
wrote:
 Sorry for inconvenience, but I don't know where else I can ask this
 question.
 I don't have acces to Visual Studio 2012 (I have Visual Studio 2010) and
I
 downloaded Firebird .NET 3.0.2.0 provider source from firebird website
and
 my Visual studio 2010 can't open this solution. Can I build it with
 SharpDevelop? Or can you upload Visual Studio 2010 solution to firebird
 website?

You can use Visual Studio 2012 Express for Windows Desktop.

Mark

--
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection Fails On Changing masterkey Password for Firebird-3.0.0.30566_0_Win32_Alpha1 With NETProvider-3.1.0.0

[Mark Rotteveel]

On 10-8-2013 03:54, LtColRDSChauhan wrote:
 Hi,
 1.  Connection Fails On Changing masterkey Password for
 Firebird-3.0.0.30566_0_Win32_Alpha1 with the error message :
 Your user name and password are not defined.  Ask you database
 administrator to set up a Firebird login 
 2.  Firebird provider : NETProvider-3.1.0.0.
 3.  Windows 7 32 Bit.
 4.  The connection string as under :
 add name=conStrHIS
 connectionString=User=SYSDBA;Password=masterkey;Database=D:\HIS\SolutionHisFBD\HISFireBird\HOSPITALINFORMATIONSYSTEM.FDB;DataSource=DBPC;Port=3050;Dialect=3;
 Charset=NONE;Role=; Connection lifetime=15;
 Pooling=true;MinPoolSize=5;MaxPoolSize=50;Packet
 Size=8192;ServerType=Default;
 providerName=FirebirdSql.Data.FirebirdClient /

As far as I know the .NET provider does not support the new 
authentication mechanism yet. The windows installer enables legacy 
authentication and sets up two SYSDBA users: one with a password for the 
new authentication system, and one for the old authentication system.

However Firebird 3 alpha 1 only support one 'UserManager' at a time, and 
it uses the user manager for the new authentication mechanism. So I 
guess you changed the password for the SYSDBA in the new authentication 
mechanism. You will probably find that you can still connect with the 
old password.

To change the password for the old authentication mechanism, you need to 
edit firebird.conf and add (or update) the line UserManager = 
Legacy_UserManager.

You can then change the password with GSEC. For other ways of changing 
the password you either need to restart Firebird, or do something with 
gsec first.

Jaybird also doesn't implement the authentication mechanism yet. I 
described this issue on the Jaybird wiki: 
http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=tip:firebird30a1

Mark
-- 
Mark Rotteveel

--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with 2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection Fails On Changing masterkey Password for Firebird-3.0.0.30566_0_Win32_Alpha1 With NETProvider-3.1.0.0

[Mark Rotteveel]

On Thu, 15 Aug 2013 02:54:57 + (UTC), Lt Col RDS Chauhan
rdsc1...@yahoo.co.in wrote:
 1. Thanks for your response.  
 
 2. Did the following :-
 
(a) Added the line UserManager = Legacy_UserManager
 
(b) Changed the password with GSEC
 
 
 
 3. Now the login through .NET provider works for sysdba. But the
 Flamerobin 
 continues to accept the password masterkey and rejects the newly set 
 password. Please advise.

Flamerobin uses fbclient.dll which supports the new authentication, so it
authenticates to the sysdba password in the new authentication mechanism;
this password hasn't been changed.

Mark

--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with 2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Error: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

[Mark Rotteveel]

On 22-10-2013 14:48, Gerdus van Zyl wrote:
 Remove role=; from your connectionstring, don't know why but if I add
 it to my working connection string it gives the same error.
 FbConnectionStringBuilder is recommended to build a connectionstring.

Role  (empty string) is not the same as no role. A potential solution 
would be for the provider not to send the role if it is empty.

Mark
-- 
Mark Rotteveel

--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register 
http://pubads.g.doubleclick.net/gampad/clk?id=60135991iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Why is table in use after close commit?

[Mark Rotteveel]

On 26-11-2013 17:04, Kjell Rilbe wrote:

 Den 2013-11-26 15:46 skrev Jiri Cincura såhär:
 How the connection string looks like?

 Please refer to the thread in firebird-support about this issue: Object
 in use... wtf???

 I got a couple of replies there, from Ann Harrison among others. I
 probably need to make sure somehow that the FbCommand is disposed so
 that it releases/closes the statement in FB.

 How...?

using(var command = conn.CreateCommand()) {
...
}

The problem seems to be with connection pooling not closing the command 
when the logical connection is closed (and the physical connection 
returned to the pool). I'd argue that when connection pooling is used, a 
close of the logical connection should close any open dependent objects 
and only leave the connection itself open.

Mark
-- 
Mark Rotteveel

--
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET,  PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Why is table in use after close commit?

[Mark Rotteveel]

On 26-11-2013 19:28, Mark Rotteveel wrote:
 The problem seems to be with connection pooling not closing the command
 when the logical connection is closed (and the physical connection
 returned to the pool). I'd argue that when connection pooling is used, a
 close of the logical connection should close any open dependent objects
 and only leave the connection itself open.

Never mind my comment re connection pooling, I missed that Kjell asked 
why an explicit close and open of the connection fixed the issue.

Mark
-- 
Mark Rotteveel

--
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET,  PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Why is table in use after close commit?

[Mark Rotteveel]

On 26-11-2013 14:58, Kjell Rilbe wrote:
 Please consider this code, which essentially creates a table, commits,
 fills data and does a select with joins, closes the query, commits, then
 drops the table in a new transaction.

 The problem is that without the conn.Close + conn.Open before starting
 the drop transaction, the drop fails saying the object is in use.

 Why is the Close/Open required?

...
 FbCommand cmd = conn.CreateCommand();
...
 cmd.CommandText = select /*...*/ from \Tmp\ inner join /*...*/ where
 /*...*/;;
 cmd.Parameters.Clear();
 using (FbDataReader rd =
 cmd.ExecuteReader(System.Data.CommandBehavior.SingleRow))
 {
   rd.Read();
   for (int colnum = 0; colnum  rd.FieldCount; colnum++)
   {
   string colname = rd.GetName(colnum);
   int count = rd.GetInt32(colnum);
   if (count  0)
   result.Counts[colname] = count;
   }
   rd.Close();
 }

An rd.Close() is unnecessary when you use using. It will dispose the 
object when it exits the block (which closed the reader).

The problem is that you did not close the command, which means it is 
still prepared, which marks the table as used. Now when you close the 
connection, the command will be closed as well.

So the solution is to wrap the command (and everything that uses the 
command) in a using block as well.

 trans.Commit();
 conn.Close();
 conn.Open();
 trans = conn.BeginTransaction(new FbTransactionOptions() {
 TransactionBehavior = FbTransactionBehavior.ReadCommitted |
 FbTransactionBehavior.RecVersion | FbTransactionBehavior.Wait });
 FbCommand cmd = conn.CreateCommand();
 cmd.CommandType = System.Data.CommandType.Text;
 cmd.Transaction = trans;
 cmd.CommandText = drop table \Tmp\;;
 cmd.ExecuteNonQuery();
 trans.Commit();

BTW: You really should use using for your connections and for 
transactions as well. This will rollback the transaction if no commit 
was called when it exits the block (either because no commit() was in 
the code or an exception occurred before the end of the block).

Basic rule: if something is IDisposable, then use using.

Mark
-- 
Mark Rotteveel

--
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET,  PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] visual studio 2013, firebird and entity framawork

[Mark Rotteveel]

On 26-12-2013 15:09, is...@expertpcnet.com wrote:
 well , still cannot use ef with firebird in vs2013 pro and Win7 pro !

 here what i have done : i have created a new class library for my DAL
 project , and imported the ef6 and the firebird provider via nuget like
 said in this page
 http://www.nuget.org/packages/FirebirdSql.Data.FirebirdClient-EF6/
 then i copied the fb provider to some place and use gacutil to regiter
 it into the cache:

 C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1
 Tools\gacutil -i fibirdprovierpath

 please note that i used the gacutil from the netfx4.5.1 (don't know if
 it change something)
 ok after that i have grabbed the ddex dlls, put them somewhere , change
 the regfiles that came with (32/64), for the path and run them.

 what else 
 ah yes , i have also modified the machine.config (32/64) to reference
 the firebird provider .
 Now, i can add a firebird connection without any problem in the servers
 window, i can even create a winform pp that use firebird dataset,BUT
 when i want to add an edmx model the firebird option is unavailable, i
 have only sql server !!
 make sense to anyone please !!!

You have only downloaded the client binary. For designer support you 
need to install the DDEX Provider from 
http://www.firebirdsql.org/en/net-provider/

Mark
-- 
Mark Rotteveel

--
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET,  PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] How to connect

[Mark Rotteveel]

On Fri, 14 Mar 2014 04:54:34 +, Dass, Sukhen (NDH-MRM)
sukhen.d...@mrmworldwide.com wrote:
 Dear Team,
 
 I am facing a issue in connection of Firebird database which is kept in
a
 shared drive. Physically I am able to access the file and it has full
 permission for read/write.
 
 Please help to connect to a shared database in vb.net

Firebird can only use databases on a local drive to prevent corrupted
databases through insufficient/incorrect locking. Using a shared drive
implies that you need to use a Firebird server and the database file local
to that server, and have the client connect to that server.

Mark

--
Learn Graph Databases - Download FREE O'Reilly Book
Graph Databases is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

[Mark Rotteveel]

On Thu, 20 Mar 2014 03:51:23 -0600, David De Smet idaviddes...@gmail.com
wrote:
 I'm using LLBLGen for creating the script and model.
 
 The script for creating the DB is DECIMAL, so is the DB end result. I
 verified with Flamerobin.

What is the precision and scale of the DECIMAL?

 The model is also decimal and when writing .NET code the value I'm
passing
 for save is decimal. But as said, the return value is Int64 or long if
 coding in C#.
 
 I'm using Firebird Embedded.

Have you created a dialect 1 (deprecated) or dialect 3 database?

Mark

--
Learn Graph Databases - Download FREE O'Reilly Book
Graph Databases is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Mystery 3.0.2 revisited

[Mark Rotteveel]

On Tue, 8 Apr 2014 14:33:35 +0200, André Knappstein
knappst...@beta-eigenheim.de wrote:
 I don't see my posting from this afternoon, yet.

It showed up in my mailbox around 13:00, and it is also in the archive
http://sourceforge.net/p/firebird/mailman/message/32200411/

Mark

--
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test  Deployment 
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] fbBackup on remote Clients

[Mark Rotteveel]

On Thu, 1 May 2014 11:49:02 +0200, Jiri Cincura disk...@cincura.net
wrote:
 On Thu, May 1, 2014 at 8:49 AM, Parzival parzival1...@gmx.at wrote:
 Is there a way to get fbBackup working on remote Clients?
 

http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_20797

That is no longer true, remote backup has been included in the service API
in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666

Mark

--
Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free.
http://p.sf.net/sfu/SauceLabs
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] fbBackup on remote Clients

[Mark Rotteveel]

On 1-5-2014 19:40, Jiri Cincura wrote:
 On Thu, May 1, 2014 at 12:21 PM, Mark Rotteveel m...@lawinegevaar.nl wrote:
 That is no longer true, remote backup has been included in the service API
 in Firebird 2.5.2: http://tracker.firebirdsql.org/browse/CORE-2666

 I'm lost. Wasn't this always the case? Via services API you created
 backup on server. But it was/is not possible to create a backup of
 remote database to local file. Or it was vice versa?

You could always use the services API to create a backup on the server, 
but since CORE-2666 it is also possible to stream the backup to the 
client (or from the client to the server for restore).

 From the README.services_extension.txt:


4) Services API extension - running gbak at server side with .fbk at the 
client.
(Alex Peshkov, peshk...@mail.ru, 2011-2012)

This way of doing backups is specially efficient when one needs to 
perform backup/restore operation for database, located on ther server 
accessed using internet, due to the great performance advantage.

The simplest way to use this feature is fbsvcmgr. To backup database run
approximately the following:
fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \
action_backup -dbname some.fdb -bkp_file stdout some.fbk

and to restore it:
fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \
action_restore -dbname some.fdb -bkp_file stdin some.fbk

Please notice - you can't use verbose switch when performing backup 
because data channel from server to client is used to deliver blocks of 
fbk files. You will get appropriate error message if you try to do it. 
When restoring database verbose mode may be used without limitations.

If you want to perform backup/restore from your own program, you should 
use services API for it. Backup is very simple - just pass stdout as 
backup file name to server and use isc_info_svc_to_eof in 
isc_service_query() call. Data, returned by repeating calls to 
isc_service_query() (certainly with isc_info_svc_to_eof tag) is a 
stream, representing image of backup file. Restore is a bit more tricky. 
Client sends new spb parameter isc_info_svc_stdin to server in 
isc_service_query(). If service needs some data in stdin, it returns 
isc_info_svc_stdin in query results, followed by 4-bytes value - number 
of bytes server is ready to accept from client. (0 value means no more 
data is needed right now.) The main trick is that client should NOT send 
more data than requested by server - this causes an error Size of data 
is more than requested. The data is sent in next isc_service_query() 
call in the send_items block, using
isc_info_svc_line tag in traditional form: isc_info_svc_line, 2 bytes 
length, data.
When server needs next portion, it once more returns non-zero 
isc_info_svc_stdin value from isc_service_query().

A sample of how services API should be used for remote backup and 
restore can be found in source code of fbsvcmgr.


Mark
-- 
Mark Rotteveel

--
Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free.
http://p.sf.net/sfu/SauceLabs
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] FbEmbed Not Releasing Database

[Mark Rotteveel]

On 27-6-2014 18:09, Scott Morgan wrote:
 Trying to drop a DB opened with the embedded system, but something seems
 to be holding the file open after the connection is closed.

 Test case from a console app:

 Console.WriteLine(Attempting to open DB...);
 var conn = new FbConnection();
 conn.ConnectionString = myConnectionString;
 conn.Open();

 Console.WriteLine(Attempting to close DB...);
 conn.Close();

 conn = null;
 GC.Collect(); // Getting desperate here

 Console.WriteLine(Attempting to delete DB...);
 FbConnection.DropDatabase(ConnectionString);
 // File.Delete(DBPath); // doesn't work either

The .net provider has a connection pool, so the physical connection is 
still open. You need to flush the pool, or disable connection pooling.

You can flush the pool with:
FbConnection.ClearAllPools();

and disable connection pooling by setting Pooling=false in the 
connection string.

Mark
-- 
Mark Rotteveel

--
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Scale Precision 4 Truncates to 2 in Database

[Mark Rotteveel]

On 6-7-2014 01:14, m...@lawinegevaar.nl wrote:
 Your parameter is DECIMAL(18,2). If you want scale 2, specify that.

That should of course have read If you want scale 4, specify that.

Mark

-- 
Mark Rotteveel

--
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connecting to Firebird 3.0 Alpha 2

[Mark Rotteveel]

On 7-7-2014 15:43, LtColRDSChauhan wrote:
 Hi,

 1.  I attempted to migrate from Firebird 3.0 Alpha 1 to Alpha 2.  After
 a backup / restore I'm not able to connect to the database using .NET
 Provider.  I've the following updated in the Firebird Config file :

 UserManager = Legacy_UserManager

 AuthClient = Srp, Win_Sspi, Legacy_Auth


 2.  FlameRobin connects fine.

 3.  Please help.

When you install Firebird 3 - unless you already enabled legacy 
authentication in the installer - you will only have a user account in 
the new SRP authentication model. As you edited the firebird.conf later, 
you currently do not have a legacy authentication user.

To fix this, you need to
1) Edit firebird.conf again and
1a)set the UserManager to Legacy_UserManager:

UserManager = Legacy_UserManager

1b) Set WireCrypt to Enabled (instead of Required), or even Disabled so 
that the server doesn't require encryption

WireCrypt = Enabled

2) Restart Firebird (not 100% sure if necessary)

3) Next you need to create another SYSDBA account (using gsec) so it 
also exists as a legacy user. I am not 100% sure if you only need to do 
gsec -user sysdba -password masterkey, or that you explicitly need to 
do add sysdba -pw masterke from the gsec prompt.

The reason Flamerobin works is that it uses the Firebird 3 fbclient.dll, 
so it automatically supports the new authentication model and encryption.

Mark
-- 
Mark Rotteveel

--
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connecting to Firebird 3.0 Alpha 2

[Mark Rotteveel]

On 7-7-2014 18:40, Norbert Saint Georges wrote:
 Hi,

 forcegood client library for Firebird?
 eg customer library = j: \ firebird-3 \ fbclient30.dll; in the
 connection string.

By default the .net provider uses a C# implementation of the wire 
protocol, not the Firebird client library.

Mark

-- 
Mark Rotteveel

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connecting to Firebird 3.0 Alpha 2 Re: Firebird-net-provider Digest, Vol 99, Issue 2

[Mark Rotteveel]

On Sun, 13 Jul 2014 23:21:04 +0530, LtColRDSChauhan rdsc1...@gmail.com
wrote:
 No luck.  Still could not connect to Firebird 3.0 Alpha 2.  Could though
 revert back to Alpha 1 successfully.

You need to have a fresh security3.fdb with Alpha 2: you cannot use the
security database created with Alpha 1 due to incompatible changes. However
I seem to remember that I also had some problems with Alpha 2 and that I
switched to a more recent snapshot when testing. However, I am not sure
about the details. I will try with a fresh install and let you know.

Mark

--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck#174;
Code Sight#153; - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Casting Text BLOB to null

[Mark Rotteveel]

On Fri, 05 Sep 2014 12:08:33 +0100, Scott Morgan bl...@blueyonder.co.uk
wrote:
 Am I missing a trick here? I'm reading from a BLOB SUB_TYPE 1 column
 using the following:
 
 FbDataReader reader = /* blah */
 string text = (string)reader[LONG_TEXT];
 
 It's okay when there is data, but if the column happens to be NULL I get
 an error (Unable to cast object of type 'System.DBNull' to type
 'System.String'), where I'd ideally like to get a plain null.
 
 FbDataReader.GetString doesn't work for me as it just returns 
 
 So I'm left with a messy lump of GetOrdinal, IsDBNull, code. There's got
 to be a better way, but I'm not seeing it.

A quick workaround is to use:

string text = reader[LONG_TEXT] as string;

This will perform the cast, but return null if the cast failed.

Mark

--
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Insert into uncommitted table

[Mark Rotteveel]

On 22-12-2014 13:08, Jiří Činčura wrote:
 Hi *,

 Anybody knows a trick how to insert into freshly created table without 
 commiting that DDL first. It's kind of fucking up first migration. :)

 Basically:
 Start TX.
Create table.
Insert into table.
 Commit TX.


No, not really. But EF doesn't support this? AFAIK there are more 
databases that require a commit before a newly created table can be used.

Mark
-- 
Mark Rotteveel

--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-616) [FirebirdSql.Data.FirebirdClient.FbException] - Column unknown RDB$PROCEDURE_TYPE (SQL error code = -206)

[Mark Rotteveel]

On 18-8-2015 10:53, usman wrote:
 Is there any solution to this problem.
 I am using firebird client 4.7.0, DDEXProvider-3.0.2 with vs 2012 and still
 getting the error.
 Can you someone please guide how to resolve this issue.

Which Firebird version are you using? A column unknown 
RDB$PROCEDURE_TYPE suggests that you are using Firebird 2.0 or earlier 
(or a database that is still ODS 11.0 or earlier and hasn't been 
upgraded). The column RDB$PROCEDURE_TYPE was introduced in Firebird 2.1, 
see http://tracker.firebirdsql.org/browse/CORE-779

Mark
-- 
Mark Rotteveel

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DNET-607

[Mark Rotteveel]

On Thu, 23 Jul 2015 07:56:09 +, Jiří Činčura j...@cincura.net wrote:
 Hi *,
 
 Anybody willing to give me a code review?

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/compare/DNET-607

Does the releasing/disposing also require locking on _syncroot? If so: 

release.AsParallel().ForAll(x = x.Dispose());

Might cause a deadlock.

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-631) Support for BOOLEAN in FB3

[Mark Rotteveel]

I have added a link to the initial implementation I did in Jaybird. It 
won't directly map to the C# implementation, but it might give you some 
indication of what needs to change where, and how it is encoded in the 
wire protocol.

Mark

On 14-9-2015 17:17, Геннадий Забула wrote:
> How should this be implemented?
> I could take a look at this in the week.
>
> On 14 September 2015 at 17:06, Jiri Cincura (JIRA)
> <trac...@firebirdsql.org> wrote:
>> Support for BOOLEAN in FB3
>> --
>>
>>   Key: DNET-631
>>   URL: http://tracker.firebirdsql.org/browse/DNET-631
>>   Project: .NET Data provider
>>Issue Type: Sub-task
>>Components: ADO.NET Provider, DDEX Provider, Entity Framework 
>> support
>>  Affects Versions: 4.8.0.0
>>  Reporter: Jiri Cincura
>>  Assignee: Jiri Cincura
>>
>>
>>
>>
>> --
>> This message is automatically generated by JIRA.
>> -
>> If you think it was sent incorrectly contact one of the administrators: 
>> http://tracker.firebirdsql.org/secure/Administrators.jspa
>> -
>> For more information on JIRA, see: http://www.atlassian.com/software/jira
>>
>>
>>
>> --
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>


-- 
Mark Rotteveel

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] How to execute NUnit with Mono ?

[Mark Rotteveel]

On 14-9-2015 12:02, Hajime Nakagami wrote:
> Hi, Jiri and all.
>
>
> I am writing NUnit test (at first time) now.
>
>
> https://github.com/nakagami/FirebirdSql.Data.FirebirdClient/compare/srp...nakagami:srp_tests
>
>
> It seems compile success.
>
> But something wrong to run that test.
>
>
> My environment is Ubuntu12.04 and mono 4.2
>
>
> $ mono --version
>
> Mono JIT compiler version 4.2.0 (Stable 4.2.0.179/a224653
> <http://4.2.0.179/a224653> Sat Aug 29 00:01:20 JST 2015)
>
> Copyright (C) 2002-2014 Novell, Inc, Xamarin Inc and Contributors.
> www.mono-project.com <http://www.mono-project.com>
>
>  TLS:   __thread
>
>  SIGSEGV:   altstack
>
>  Notifications: epoll
>
>  Architecture:  amd64
>
>  Disabled:  none
>
>  Misc:  softdebug
>
>  LLVM:  supported, not enabled.
>
>  GC:sgen
>
>
> $ mono /usr/local/lib/mono/4.5/nunit-console.exe
> NETProvider/src/FirebirdSql.Data.UnitTests/bin/Debug/FirebirdSql.Data.UnitTests.dll
> --run=SrpClient
>
>
> NUnit version 2.4.8
>
> Copyright (C) 2002-2007 Charlie Poole.
>
> Copyright (C) 2002-2004 James W. Newkirk, Michael C. Two, Alexei A.
> Vorontsov.
>
> Copyright (C) 2000-2002 Philip Craig.
>
> All Rights Reserved.
>
>
> Runtime Environment -
>
> OS Version: Unix 3.13.0.63
>
>   CLR Version: 4.0.30319.17020 ( 4.2.0 (Stable 4.2.0.179/a224653
> <http://4.2.0.179/a224653> Sat Aug 29 00:01:20 JST 2015) )
>
>
>   Selected test: SrpClient
>
>
>   Tests run: 0, Failures: 0, Not run: 0, Time: 0.002 seconds

The class SrpClient doesn't contain tests (and it is also not in the 
assembly FirebirdSql.Data.UnitTests).

Maybe you meant --run=SrpTests or 
--run=FirebirdSql.Data.UnitTests.SrpTests ?

-- 
Mark Rotteveel

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Version 4.8

[Mark Rotteveel]

On 19-9-2015 07:00, Jiří Činčura wrote:
> I have no idea. The website changes are done by another person, not me.
>

The site has been updated.

Mark
-- 
Mark Rotteveel

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-631) Support for BOOLEAN in FB3

[Mark Rotteveel]

On Thu, 24 Sep 2015 19:10:44 +0300, Геннадий Забула 
wrote:
> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/40
> WIP about boolean support is here. Only Gds implemented for now.
> 
> I have several question about Gds protocol. Where can I find
> documentation about it? I need to know what should I write to send
> boolean field to server.

There is the Firebird Wire protocol documentation, but it doesn't contain
all details and is mostly based on reverse engineering the protocol on a
message level, not so much the content of the messages. You'll have more
luck looking at the Firebird implementation, or other drivers like Jaybird.

In any case, you need to encode a boolean as a single byte byte-array with
the value 0 for false or 1 for true. See also: 

https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/DefaultDatatypeCoder.java#L358

For reading and writing you also need information on the blr calculations:
https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/DefaultBlrCalculator.java

And reading:
https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/version10/V10Statement.java#L516

And writing:
https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/version10/V10Statement.java#L564

I'd also suggest to take a look at the commit for Jaybird I linked in
ticket, as that includes all the changes you need to get it working.

> And also I have doubts about an implementation of reading boolean
fields.

See above.

Mark

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] FB3/provider 4.9.0.0 Boolean

[Mark Rotteveel]

Support for Boolean does not require protocol version 13 support, and could be 
added without problems.
Mark

- Reply message -
Van: "Геннадий Забула" 
Aan: "For users and developers of the Firebird .NET providers" 

Onderwerp: [Firebird-net-provider] FB3/provider 4.9.0.0 Boolean
Datum: wo, dec. 16, 2015 20:38

It is implemented in PR:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/40
But since there is no overall support for FB 3.0 (especially new
authentication) the PR is suspended.

On 16 December 2015 at 21:21, Rick Roen  wrote:
> I'm pretty sure this is a known problem, but I get a message "invalid data
> type" exception when I ExecuteDataReader against a FB3 table with a boolean
> field. I can provide the error stack if necessary.
>
> Is there an ETA date to get this working?
>
> Regards,
> Rick
>
> --
>
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] connection rejected by remote interface Error

[Mark Rotteveel]

But did you also set the wirecrypt setting to Enabled instead of the default 
required (which doesn't work with legacy authentication)? Did you also create a 
legacy user?
The error connection rejected by remote interface however suggests that the 
server isn't listening on the specified port and ip address or is actively 
blocked by a firewall.

Mark

- Reply message -
Van: "dragos.pop" 
Aan: 
Onderwerp: [Firebird-net-provider] connection rejected by remote interface Error
Datum: di, jan. 5, 2016 11:14

Yes, I have this line in firebird.conf
AuthServer = Srp, Win_Sspi, Legacy_Auth--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Aliases not working

[Mark Rotteveel]

On 5-6-2016 02:47, Paul Dryden wrote:
> Thanks, I'll try Firebird 3. It's affordable.

My question was a troubleshooting question, not a solution to your 
problem (as it stands, I'm not sure what your problem is!)

Mark
-- 
Mark Rotteveel

--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Aliases not working

[Mark Rotteveel]

On 18-5-2016 19:23, Paul Dryden wrote:
> Forsome reason on my system aliases don't work. Now I have to go into
> each app and change the alias to the actual path name. Any reason or
> solution for this?

This sounds like a question that should be posted to firebird-support 
instead. Did you by any chance upgrade to Firebird 3? In Firebird 3 
aliases.conf no longer exists, it was replaced by databases.conf (see 
http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-aliasesconf.html)

Mark
-- 
Mark Rotteveel

--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Compression's default value

[Mark Rotteveel]

On 2016-06-20 15:27, Jiří Činčura wrote:
> Hi *,
>
> I have some very preliminary, but working, support for FB3's 
> compression
> in .NET provider. It will be controlled via connection string's value 
> as
> usual. But what do *you* think the default value should be?

I suggest to disable it by default; at least for now. Maybe when there 
is more experience, and if it turns out it is also better for local 
connections (as in: same network), then setting it to default enabled 
might be an option.

Mark

--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports. http://sdm.link/zohomanageengine
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] FbTransactionBehavior values docs/info?

[Mark Rotteveel]

On 31-1-2016 08:31, Kjell Rilbe wrote:
> Hi,
>
> I am unable to find info about some of the FbTransactionBehavior values.
> Would be nice with some pointers or info. :-)
>
> Consistency = 1, // What's this?
> Concurrency = 2, // What's this?
> Shared = 4, // Used only for pre locking of tables?? Protected = 8, //
> Used only for pre locking of tables?? Exclusive = 16, // Used only for
> pre locking of tables?? Wait = 32, // Wait specified amount of time if 
> operation needs resource locked by other transaction.
> NoWait = 64, // Throw exception immediately if operation needs resource 
> locked by other transaction.
> Read = 128, // Used only for pre locking of tables?? Write = 256, //
> Used only for pre locking of tables?? LockRead = 512, // Used only for
> pre locking of tables?? LockWrite = 1024, // Used only for pre locking
> of tables?? ReadCommitted = 2048, // Changes committed by other trans are 
> seen, uncommitted changes are not seen, conflict only on write of same record.
> Autocommit = 4096, // What's this? RecVersion = 8192, // MVCC is used, so rec 
> changed by other transaction can be read (but old version).
> NoRecVersion = 16384, // MVCC "not used", so can't read rec changed by other 
> transaction.
> RestartRequests = 32768, // What's this? NoAutoUndo = 65536, // What's this?

These are equivalent to the isc_tpb_* constants with the same (or 
similar) names in Firebird. You need to refer to the (scarce) 
documentation of Firebird on these options.

Mark
-- 
Mark Rotteveel

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Disconnection Problem In Vb.net with Firebird

[Mark Rotteveel]

On Tue, 02 Feb 2016 06:57:03 +0100, Jiří Činčura  wrote:
> Calling `FbConnection.ClearAllPools` is enough. You don't have to call
> anything else. Though you might give server few ms to release the file -
> it's not guaranteed that closing all connections will immediately
> release the file.

Maybe the problem might be related to not reading the op_response to the
op_detach request (which for Jaybird 3 caused crashes with Firebird 2.1),
maybe connections linger longer than necessary if that response packet
isn't read.

Mark

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Version 4.10 Download

[Mark Rotteveel]

I do have the rights. Did you already have the news item ready for publishing?
Mark

- Bericht beantwoorden -
Van: "Jiří Činčura" 
Aan: 
Onderwerp: [Firebird-net-provider] Version 4.10 Download
Datum: di, jan. 26, 2016 15:26

The website has not yet been updated. I don't have rights for that, so
it's best to put it to tracker to DOC project.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

On Tue, Jan 26, 2016, at 15:08, Nicolas Timmers wrote:
> Hello, the new version of .net data provider is not available to
> donwlonad on
> http://www.firebirdsql.org/en/additional-downloads/
> 
> 
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] RES: Version 4.10 Download

[Mark Rotteveel]

On Tue, 26 Jan 2016 13:52:39 -0200, "Nicolas F. Timmers"
 wrote:
> Have another link where i can download it, without nugget ?

At the normal location on SourceForge:
http://sourceforge.net/projects/firebird/files/firebird-net-provider/4.10.0.0/

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Version 4.10 Download

[Mark Rotteveel]

You also didn't create a request in WEB. I will create one tonight.
Mark

- Bericht beantwoorden -
Van: "Jiří Činčura" 
Aan: "For users and developers of the Firebird .NET providers" 

Onderwerp: [Firebird-net-provider] Version 4.10 Download
Datum: di, jan. 26, 2016 17:20

> I do have the rights. Did you already have the news item ready for
> publishing?

Ehm. Never done that. Probably you can copy just the previous one. It
should be link to
http://blog.cincura.net/233544-ado-net-provider-4-10-0-0-for-firebird-is-ready/
anyway.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Version 4.10 Download

[Mark Rotteveel]

Sorry, I meant that I'll create a news item tonight, not a ticket.
Mark

- Bericht beantwoorden -
Van: "Jiří Činčura" 
Aan: "For users and developers of the Firebird .NET providers" 

Onderwerp: [Firebird-net-provider] Version 4.10 Download
Datum: di, jan. 26, 2016 17:43

> You also didn't create a request in WEB. I will create one tonight.

Normally I'm sending this to Olga and Alexey, as requested. Creating
ticket for that seems to be bit overkill.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] How to backup the remote database to a local hard disk

[Mark Rotteveel]

On 25-3-2016 17:23, LtColRDSChauhan wrote:
> Mark, thanks for your help.
> I was using FBackup.
>
> FbStreamingBackup if you want to backup to your local machine.
>
> Using FbStreamingBackup solved my problem.
> But the ServiceOutput event handler is now not getting called.

That is expected, because there can't be any logging when using the 
streaming backup. The channel that in FbBackup is used to get log 
information is not available, because instead the backup data is sent 
over that channel.

Mark
-- 
Mark Rotteveel

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] How to backup the remote database to a local hard disk

[Mark Rotteveel]

On 23-3-2016 11:31, LtColRDSChauhan wrote:
> Hi,
>
> 1.  Not able to back up:
>
> \\ServerMachine\C\ABC.FDB
> to
> \\TheLocalMachine\C\ABC.GBK

Please show the code you use for the backup. You should be using 
FbStreamingBackup if you want to backup to your local machine.

> 2. The C drive of the TheLocalMachine is shared to Everyone with Allow
> Full Control.

Note that Firebird does not allow you to connect to a database on a 
network share (even if that share is local to the machine).

Mark
-- 
Mark Rotteveel

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection to Firebird 3 With Legacy Authentication Fails

[Mark Rotteveel]

On 24-4-2016 09:16, LtColRDSChauhan wrote:
> 1. I have a Firebird-2.5.5.26952_0_Win32 database which I backed up
> (using Flamerobin) after renaming RDB$FIELD_NAME field values in the
> system table RDB$FIELDS of the source database as under:
>
> 'SEC$USER_NAME' to 'SEC$USER_NAME_RAJIV'
> 'SEC$NAME_PART' to 'SEC$NAME_PART_RAJIV'

Why did you do this?

> 2. I installed Firebird-3.0.0.32483_2_Win32 on Windows 10 with Legacy
> Authentication. Using Flamerobin I restored the Firebird 2.5.5 FBK file.
>
> 3. The Flamerobin connects to the Firebird 3.0 restored file but my .NET
> application (Provider .NET 4.10) fails to connect.

What error do you get? Did you explicitly create a Legacy_Auth user? 
What config does your firebird.conf have for the settings AuthServer, 
WireCrypt, and UserManager

Mark
-- 
Mark Rotteveel

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] double subscribed

[Mark Rotteveel]

On 28-4-2016 20:19, Kyle Green wrote:
> sorry for the double post - it appears I am subscribed twice
>
> how can I remove one of the subscriptions?

To unsubscribe, send an e-mail to 
firebird-net-provider-requ...@lists.sourceforge.net with subject: 
unsubscribe.

Or go to the web interface: 
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider (see 
at the end); sending an e-mail is probably simpler though.

Mark
-- 
Mark Rotteveel

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Fb 3 connection string upgrade

[Mark Rotteveel]

See http://stackoverflow.com/q/36752916/466862
In short edit Firebird.conf
Add Legacy_Auth to AuthServer.
Set WireCrypt to Enabled
Add Legacy_UserManager to UserManager

Create a user for legacy authentication.

Mark


Mark

- Bericht beantwoorden -
Van: "Kyle Green" 
Aan: 
Onderwerp: [Firebird-net-provider] Fb 3 connection string upgrade
Datum: di, mei 3, 2016 19:38

I have rebuilt my Fb 2.5 database as Fb 3.0, and have upgraded to the 
current provider.

Now I am trying to make the web app which previously used Fb2.5 work. I 
am able to connect via isql, and by FlameRobin.


Connection Failed to Open for ConnectionString:

Database=d:\db\Fb\Data\MyDb.fdb;user=SYSDBA;password=masterkey;DataSource=localhost;Pooling=true;MinPoolSize=0;MaxPoolSize=100;Connection
 Lifetime=0;Connection Timeout=15;

Exception:

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): connection 
rejected by remote interface ---> connection rejected by remote 
interface

at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
at 
FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString
 connectionString)
at 
FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection
 owner)
at 
FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString 
connectionString, FbConnection owner)
at FirebirdSql.Data.FirebirdClient.FbConnection.Open()




The original string failed also:

Database=d:\db\Fb\Data\MyDb.fdb;user=SYSDBA;password=masterkey;server=MyServer;Pooling=true;MinPoolSize=0;MaxPoolSize=100;Connection
 Lifetime=0;Connection Timeout=15;




firebird.conf is default with ServerMode - Classic

databases.conf is default



How can I get this to work?

Thanks!


-- 
Kyle Green

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Fb 3 connection string upgrade

[Mark Rotteveel]

On 2016-05-03 23:45, Kyle Green wrote:
> Thank you, I have done as you suggested, and the connection string
> works!
>
> However the user I created has no permissions, not even select
> permissions:
>
> my log shows 5/3/2016 3:36:11 PM: no permission for SELECT access to
> TABLE BLOGS ( and for every other attempt to access data)
>
> I had named my User "LegacyUser" (was that a mistake?). Then, while
> attached to the database through FlameRobin, ran these:
>
> GRANT rdb$admin TO USER LegacyUser;
>
> Above did not allow access, so I tried this:
>
> ALTER USER LegacyUser GRANT ADMIN ROLE;
>
> Even after this, the error at the top still appears.
>
> I have always used SYSDBA account for my web applications, so I have
> no experience with user accounts.
>
> What might be missing?

You could just create a legacy SYSDBA (it might already exist, in which 
case you just need to change the password). However using SYSDBA for a 
(web) application is a bad idea, because it has all rights on all 
databases on the Firebird server. You should create a user that has the 
minimal rights necessary for your application to work.

As to the specific problem : roles are only applied when you specify 
them on connect in the connection string (for Firebird .net provider 
property: Role=RDB$ADMIN) or - since 3.0 - after connect with SET ROLE. 
No role specified means that you only get the rights assigned to PUBLIC 
and the user itself.

For RDB$ADMIN specifically, you can enable auto admin mapping, which 
means that the user will get the role implicitly when logged in. See 
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-security-auth.html#fblangref25-security-autoadminmapping

But I'd strongly advise you to create a specific role with only the 
necessary rights.

Mark

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection to Firebird 3 With Legacy Authentication Fails

[Mark Rotteveel]

On 29-4-2016 08:26, LtColRDSChauhan wrote:
> Mark,
> Could trace your:
> https://github.com/FirebirdSQL/jaybird/wiki/Jaybird-and-Firebird-3
> It covers everything except for SEC$USER_NAME, SEC$NAME_PART.

As far as I know doing things for SEC$USER_NAME, SEC$NAME_PART should 
not be necessary for 'normal' Firebird 2.5 database upgraded to Firebird 
3. It seems very specific for your database or maybe if you downgraded a 
Firebird 3 database to 2.5 and then back to 3 (?).

Mark
-- 
Mark Rotteveel

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Not able to choose Firebird ADO.Net Data provider as data source in VS2015

[Mark Rotteveel]

As I also posted on stackoverflow, you need to install the DDEX provider as 
well. I tested that yesterday and it worked for me.
Mark

- Bericht beantwoorden -
Van: "Widmer, Rico (MF Engineering AG)" 
Aan: "firebird-net-provider@lists.sourceforge.net" 

Onderwerp: [Firebird-net-provider] Not able to choose Firebird ADO.Net Data 
provider as data source in VS2015
Datum: vr, apr. 15, 2016 12:11

Hallo everybody
I am struggling creating a Firebird connection in Visual Studio 2015.
I have a C# class library with which I would like to connect to a Firebird 
database.
I installed these plugins from NuGet:

But when I try to add a new Item "ADO.NET Entity Data Model" with "EF
Designer from database", the Firebird connection is not listed:


I installed as well the “FirebirdSql.Data.FirebirdClient-4.10.0.0.msi”
package from http://www.firebirdsql.org/en/additional-downloads/ just in case 
an entry in the machine.config file is needed.
The "FirebirdSql.Data.FirebirdClient" reference exists in the Visual Studio
project.
The entry in the App.config file is:




Can anybody help me with this issue? How can I create a database connection
to my Firebird database?
Thank you very much in advance.
Best Regards,

Rico--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] some questions about Firebirsql

[Mark Rotteveel]

You need to remove set term instructions, it is not actually part of the 
Firebird syntax. They are only used by query tools like ISQL and Flamerobin.
So remove both set term instructions and the ^ after the final end and you 
should be able to execute the create trigger using the .net provider.

Mark

- Bericht beantwoorden -
Van: "陈文欢" <9183...@qq.com>
Aan: "firebird-net-provider" 
Onderwerp: [Firebird-net-provider] some questions about Firebirsql
Datum: za, jul. 2, 2016 12:25

hi,guys

i have a question about how to create trigger.

when i use the Firebird .net Provider 5.0  .  i dont kown how to create the 
commandtext for trigger.

e.g

SET TERM ^ ;


CREATE TRIGGER TCURRENTSET_BI FOR TCURRENTSET
ACTIVE BEFORE INSERT POSITION 0
AS
DECLARE VARIABLE tmp DECIMAL(18,0);
BEGIN
IF (NEW.RD IS NULL) THEN
NEW.RD = GEN_ID(GEN_TCURRENTSET_RD, 1);
ELSE
BEGIN
tmp = GEN_ID(GEN_TCURRENTSET_RD, 0);
if (tmp < new.RD) then
tmp = GEN_ID(GEN_TCURRENTSET_RD, new.RD-tmp);
END
END^


SET TERM ; ^

please tell me how to do that . thx so much

Best Regards--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connection charset

[Mark Rotteveel]

On 21-8-2016 08:09, Jiří Činčura wrote:
> Hi *,
>
> I'm reading the JDBC-446 now and thinking we might do something similar.
>
> The default connection charset of NONE is pretty wrong in most cases.
> For .NET it might make sense to change to default UTF8, which on the
> other hand is correct in a lot of cases. And devs can change it if they
> really know what they are doing. Not sure whether forcing to specify
> some charset, thus not having default, is good idea in .NET world.
>

For background: 
http://www.firebirdsql.org/file/documentation/drivers_documentation/java/3.0.0-alpha-1/release_notes.html#connection-rejected-without-an-explicit-character-set

I have considered making UTF8 the default for Jaybird, but I decided 
that an "in your face" error message would be better to get people to 
think about their connection character set, especially as Jaybird 3 has 
other changes with character set behavior for connection character set NONE.

It is a decision that I may regret in a few months ;), and future 
Jaybird versions might default to UTF8.

Mark
-- 
Mark Rotteveel

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird-support] Create Autoincrement

[Mark Rotteveel]

On 25-3-2017 15:09, Clyde Eisenbeis wrote:
> I should have started this email with ... C# ... Firebird ADO.NET ...
> FirebirdClient.5.8.0 ... Visual Studio 2013.
>
> I tried entering
>
> CREATE GENERATOR gen_t1_id;
> SET GENERATOR gen_t1_id TO 0;
>
> set term !! ;
> CREATE TRIGGER T1_BI FOR T1
>
> in my C# code ... the compiler complains.  This appears to not be
> relevant for C#.

You need to show how you execute this. For example `set term` is unknown 
in Firebird itself, it is just client-side functionality in a number of 
Firebird tools (like isql, flame robin, and in the Firebird ADO.net 
provider FbScript tool.

If you are not using FbScript, but executing these statements like 
normal commands, then you must execute 1) leave out `SET TERM`, and 
execute the statements individually.

> What I need is the ability to add data and retrieve the primary key
> which needs to be autoincremented ... see
> http://stackoverflow.com/questions/42981872/why-the-executenonquery-catch-exception-validation-error-for-column-orgtable
> for the current code.

Use `INSERT  RETURNING ID`.

Mark
-- 
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Mark Rotteveel]

On 19-3-2017 11:56, Jiří Činčura wrote:
>> Firebird Embedded on windows does not check for username and password,
>> so you can leave them out. For a normal Firebird server, username is
>> case insensitive, but password - of course - is case sensitive.
>
> But the grants are still followed. So username/role is important,
> password not much.
>

You are right, forgot about that :)

-- 
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Mark Rotteveel]

On 18-3-2017 16:21, Clyde Eisenbeis wrote:
> Mark,
>
> I'm not sure how to reply via StackOverflow, so I'll email.

Here is fine.

> Thanks!  Your description creates an .fdb file. (I think .fdb is the
> correct format acronym).

You can choose whatever you want for the file extension, but fdb is 
indeed to common choice.

> 1) The filename was zzFirebirdTest.fdb.  The end result is
> ZZFIREBIRDTEST.FDB.  How do I keep TitleCase for the name?

Unfortunately there is no way, Firebird internally uppercases the 
filename on Windows. If you really want to preserve case, you would 
first need to create the database and then rename it.

> 2) UserID = "SYSDBA", Password = "masterkey".  I presume there is no
> risk in using anything I want.  Are they case sensitive?

Firebird Embedded on windows does not check for username and password, 
so you can leave them out. For a normal Firebird server, username is 
case insensitive, but password - of course - is case sensitive.

> 3) Is the pageSize = 4096, a good common practice?

It depends, 4kb is common, but the max is 16kb for current Firebird 
versions. A larger page size allows for larger index keys, other than 
that it depends: large pages means more records fit on a single page, 
and as buffers/caches are defined in pages, you'll have more data in 
cache, on the other hand storing blobs can have more space overhead: 
you'll need less pages per blob, but say you store blob is around 16KB, 
then you need 5 pages of 4KB and you will waste +/- 3500 - 400 bytes 
because it only needs a few bytes (+ bytes for the page header) of the 
last page, while with a 16KB, you'll need 2 pages of 16KB and waste 
about 16000 bytes.

> 4) I'm struggling to find details about FbConnection.CreateDatabase on
> the Firebird Document site.

You'd need to ask Jiri who maintains the project. The documentation on 
the Firebird ADO.net provider is rather sparse in my opinion, but you 
can always check the source: 
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient

> Apparently the order is ... connection details (string), page size
> (int), force writes (bool), overwrite (bool).

public static void CreateDatabase(string connectionString, int pageSize 
= 4096, bool forcedWrites = true, bool overwrite = false)

> The connection string has reserved words, Database, ServerType, etc.
>
> Is there a site that clarifies all of the reserved words / options /
> defaults?  I'd like to document this info while it is still fresh in
> my mind ... for future projects.

See the Description annotations on FbConnectionStringBuilder

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionStringBuilder.cs

Mark
-- 
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Mark Rotteveel]

On 2017-03-17 17:26, Clyde Eisenbeis wrote:
> I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in
> my Debug subdir.
> 
> The exception is "Unable to find an entry point named
> 'isc_create_database' in DLL 'FirebirdSql.Data.FirebirdClient.dll".

You are missing a crucial point, the Firebird ADO.net provider is not 
like Sqlite, it is **not** a Firebird server, it is only a client to 
connect to a Firebird server, by default through a pure C# 
implementation, alternatively using the native client or to an embedded 
server.

The first option has no dependencies, but the second and third option 
have native dependencies that you need to provide yourself (it is not 
part of the FirebirdSql.Data.FirebirdClient). For native you need 
fbclient.dll, for Firebird embedded you need Firebird embedded: for 
Firebird 2.5 and earlier: fbembed.dll and dependencies, for Firebird 3 
fbclient.dll + engine12.dll and dependencies.

If you want to use Firebird embedded, you need to put it in the same 
folder as your application (or at least on the search path).

> On Thu, Mar 16, 2017 at 2:07 PM, Jiří Činčura  wrote:
>> If you are not using the server, then location of your embedded 
>> Firebird
>> library.

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Mark Rotteveel]

On 17-3-2017 20:38, Mark Rotteveel wrote:
> As I said on stack overflow, I'll try to post a more complete answer
> later this weekend. Also check the other answer posted recently, the
> links in that mail handle some older versions, but should still apply in
> general.

I have posted on answer on Stack Overflow: 
http://stackoverflow.com/a/42872385/466862

I hope it helps.

Mark
-- 
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] New list

[Mark Rotteveel]

On 8-9-2017 20:45, Jiří Činčura wrote:

Hi *,

Because of recent changes on SourceForge we have a new list: 
firebird-net-provi...@googlegroups.com 
<mailto:firebird-net-provi...@googlegroups.com>. Hopefully it will solve 
the issues of some emails not being delivered and some people being 
unable to post. Resubscribe there, this old list is soon going to be 
retired.


Maybe a good idea to also post instructions how to subscribe.

Mark
--
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] New list

[Mark Rotteveel]

On 10-9-2017 06:58, Norbert Saint Georges wrote:

Jirí Cincura a écrit :

Maybe a good idea to also post instructions how to subscribe.


Right. https://support.google.com/groups/answer/1067205?hl=en .


the google information needs to register make this list not accessible 
to me




You can also send an email to:

firebird-net-provider+subscr...@googlegoups.com

That way you should be able to subscribe from any email address, without 
requiring a Google account.


Mark
--
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] New list

[Mark Rotteveel]

On 10-9-2017 09:45, Mark Rotteveel wrote:

On 10-9-2017 06:58, Norbert Saint Georges wrote:

Jirí Cincura a écrit :

Maybe a good idea to also post instructions how to subscribe.


Right. https://support.google.com/groups/answer/1067205?hl=en .


the google information needs to register make this list not accessible 
to me




You can also send an email to:

firebird-net-provider+subscr...@googlegoups.com

That way you should be able to subscribe from any email address, without 
requiring a Google account.


One thing: contrary to the instructions in the confirmation email, you 
can only confirm by replying. Using the "Join This Group" button will 
require a Google account.


Mark
--
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] New list - subscription instructions

[Mark Rotteveel]

On 8-9-2017 20:45, Jiří Činčura wrote:

Hi *,

Because of recent changes on SourceForge we have a new list: 
firebird-net-provi...@googlegroups.com 
<mailto:firebird-net-provi...@googlegroups.com>. Hopefully it will solve 
the issues of some emails not being delivered and some people being 
unable to post. Resubscribe there, this old list is soon going to be 
retired.


To subscribe with a Google account:

See https://support.google.com/groups/answer/1067205?hl=en

To subscribe without a google account:

1. Send an email to firebird-net-provider+subscr...@googlegroups.com
2. Wait for the first confirmation mail
3. Reply to the confirmation mail (do not use the button, that requires 
a google account)

4. Wait for the second confirmation mail
5. Wait for approval by the list owner

--
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] New list

[Mark Rotteveel]

On 10-9-2017 09:58, Norbert Saint Georges wrote:

Mark Rotteveel a écrit :

On 10-9-2017 06:58, Norbert Saint Georges wrote:

Jirí Cincura a écrit :

Maybe a good idea to also post instructions how to subscribe.


Right. https://support.google.com/groups/answer/1067205?hl=en .


the google information needs to register make this list not 
accessible to me




You can also send an email to:

firebird-net-provider+subscr...@googlegoups.com

That way you should be able to subscribe from any email address, 
without requiring a Google account.


Mark


thank you Mark for your answer but this does not seem to work,
server response:

<firebird-net-provider+subscr...@googlegoups.com>: Recipient address 
rejected: Domain not found>




Argh, I hadn't copy/pasted it and made a typo, it should be:
firebird-net-provider+subscr...@googlegroups.com

(notice the R in gRoups)

Mark
--
Mark Rotteveel

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Error reading data from the connection

[Mark Rotteveel]

You are posting to the old list. The list has moved to Google Groups.

Subscribe by sending a mail to:
firebird-net-provider+subscr...@googlegroups.com

or by visiting
https://groups.google.com/forum/#!forum/firebird-net-provider

Mark

On 16-11-2017 15:33, LtColRDSChauhan wrote:

Hello,

1. I need to frequently copy a table from one database to another. This 
has started to fail now, apparently due to increase in number of 
records. Attempting to copy about 13,26,000 records fails reporting 
“Error reading data from the connection”. Number of records that I can 
still successful copy is about 13,24,510.


3. I copy the in batches of 50,000 records (variable) each. For each 
batch, i open and close connection. I have tried setting connection 
pooling true and false both. Also varied the batch size to 5000, 10 etc.


2. My database and client are on the same machine. Other details:

RAM 16 GB

Client application 64 Bit

OS Windows 10 64 Bit

Firebird ADO.NET <http://ADO.NET> Data Provider – tried both: 5.11.0.0 
and 5.12.0


Firebird 3.0.2.32703_0_Win64

3. Please suggest possible solutions.

Regards,

Rajiv



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider




--
Mark Rotteveel


___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Transliteration problem with table locks

[Mark Rotteveel]

Note that your sending this to the old firebird-net-provider mailing 
list (on source forge) not to the new one (on Google Groups).


On 2018-09-18 20:43, Kjell Rilbe wrote:

In firebird-devel, Mark Rotteveel pointed out that the .NET provider
seems to use Encoding.Default for TPB, which is not a good choice,
considering it's system dependent. I assume TPB want a specific
encoding, regardless of client platform.

Please consider replacing with Encoding.UTF8, as indicated in the same
firebird-devel thread, for all strings in TPB.


It is not that simple: for Firebird 2.5 and earlier, using UTF8 for 
strings in the TPB is incorrect unless the connection character set is 
UTF8.


Mark


___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-806) .NET provider should explicitly call fb_shutdown() on application exit when using Firebird Embedded

[Mark Rotteveel (JIRA)]

.NET provider should explicitly call fb_shutdown() on application exit when 
using Firebird Embedded
---

 Key: DNET-806
 URL: http://tracker.firebirdsql.org/browse/DNET-806
 Project: .NET Data provider
  Issue Type: Bug
  Components: ADO.NET Provider
Affects Versions: 5.12.1.0
Reporter: Mark Rotteveel
Assignee: Jiri Cincura


If the apllication exits and there are still connections open using Firebird 
Embedded, then the exit may produce an access violation (0xc005 error). The 
root cause is that the fbembed.dll/fbclient.dll will call fb_shutdown() itself, 
but one of the other libraries (eg fbintl.dll) may already have been unloaded.

To prevent this, on exit the .NET provider should explicitly call fb_shutdown 
for any of the native libries loaded (but especially for embedded).

See also "Crash Firebird 2.5.8 Embedded with Firebird Ado.net provider." on 
Firebird-devel.

Related: DNET-802 (cleaning up the connection pool on exit will also prevent 
the access violation).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider