-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
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
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
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
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
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
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
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
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
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
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
.
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
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
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
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
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
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
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
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
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
=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
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
. 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
(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
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
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
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
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
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
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
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?
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
.
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
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
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
--
Mark Rotteveel
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
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
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
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
$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
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:
__
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
> --
> __
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:
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 Rot
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
>
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"
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
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 Rottev
ou 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
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
eed 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
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
>
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
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/
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
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
ed.
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.
Ma
ne.
> 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
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 Use
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 issu
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"
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
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
--
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"
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.
pecially 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 d
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 `
s 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,
ithub.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
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,
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 post
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 w
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
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
. 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
--
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
ge.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
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
-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
79 matches
Mail list logo