Re: [Firebird-net-provider] fbembed.dll DllNotFoundException exception (Jiri Cincura) - Digest, Vol 72, Issue 7, Topic 5

2012-04-18 Thread Mark Rotteveel
On Tue, 17 Apr 2012 19:25:20 -0400, "Steve Harp" wrote: > Yes Jim, > > I've copied the 2 C++ DLLs to the application (exe) folder with no luck and > have then moved them to the System32 folder and still no luck. I finally > installed only the "Developer and admin tools components" from the full

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

2012-05-01 Thread Mark Rotteveel
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

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

2012-07-26 Thread Mark Rotteveel
On Thu, 26 Jul 2012 12:16:48 +0200, Jiri Cincura 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 -

Re: [Firebird-net-provider] Releasing more often???

2012-07-26 Thread Mark Rotteveel
On Thu, 26 Jul 2012 15:39:40 +0300, Mercea Paul wrote: > Hi Jiri and * > I would like the ideea that Firebird.Net Provider number reflect the > FirebirdSQL server version. > By example for FirebirdSQL server 2.5 to have provider 2.5.1, 2.5.2 etc. > We know that FB server don't brake anything be

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

2012-07-26 Thread Mark Rotteveel
ous 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-pa

Re: [Firebird-net-provider] Calling Stored Procedure with 'äüö' in parameter

2012-08-17 Thread Mark Rotteveel
On Fri, 17 Aug 2012 12:01:03 +0200, Ashwani Mehlem wrote: > Hi, I still did not get it to run, even when passing the strings as > bytearray-parametersto the stored procedure. I even checked that the > generated bytearray has thecorrect encoding (WIN1252) by looking at the > bytes.However, the byte

Re: [Firebird-net-provider] Calling Stored Procedure with 'äüö' in parameter

2012-08-17 Thread Mark Rotteveel
On Fri, 17 Aug 2012 13:37:32 +0200, Ashwani Mehlem wrote: > The characterset of the database as well as the charset of all table rows > is none... That might be the actual problem. Check what happens if you use a database with an actual default characterset other than NONE (eg UTF8 or WINDOWS1252

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

2012-08-29 Thread Mark Rotteveel
On Wed, 29 Aug 2012 09:12:46 -0300, "Roberto Carlos | Unimed" 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 ad

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

2012-09-04 Thread Mark Rotteveel
On Tue, 4 Sep 2012 14:02:37 +0200, Jiri Cincura wrote: > On Tue, Sep 4, 2012 at 1:51 PM, Miroslav Hrázský > 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\Micro

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

2012-09-16 Thread Mark Rotteveel
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 to

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

2012-11-02 Thread Mark Rotteveel
On Fri, 2 Nov 2012 05:32:43 -0700 (PDT), "Mr. John" 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_TYP

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

2012-12-27 Thread Mark Rotteveel
oblem? 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 you

Re: [Firebird-net-provider] FW: What is this error: Fieldnotfound:System.Data.Common.DbProviderManifest.ConceptualSchemaDefinitionVersion3

2013-01-05 Thread Mark Rotteveel
mpilerservices-extensionattribute-from-as Note that this only applies to the System.Runtime.CompilerServices.ExtensionAttribute error. I am not sure if it also applies to the System.Data.Common.DbProviderManifest.ConceptualSchemaDefinitionVer

Re: [Firebird-net-provider] fbbackup

2013-03-22 Thread Mark Rotteveel
On Fri, 22 Mar 2013 13:48:21 +, Scott Price 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

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

2013-04-17 Thread Mark Rotteveel
On Wed, 17 Apr 2013 10:29:57 +0200, Jiri Cincura 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. > >

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

2013-04-25 Thread Mark Rotteveel
On Thu, 25 Apr 2013 10:16:33 +0200, Jiri Cincura 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 connectio

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

2013-04-25 Thread Mark Rotteveel
On Thu, 25 Apr 2013 10:46:55 +0200, Jiri Cincura wrote: > On Thu, Apr 25, 2013 at 10:27 AM, Mark Rotteveel > 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 > >

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

2013-06-18 Thread Mark Rotteveel
= 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 ---

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

2013-06-18 Thread Mark Rotteveel
n'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. htt

Re: [Firebird-net-provider] Improving

2013-07-03 Thread Mark Rotteveel
On Wed, 3 Jul 2013 13:36:58 +0200, Jiri Cincura 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 y

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

2013-07-26 Thread Mark Rotteveel
On Fri, 26 Jul 2013 05:40:12 +0500, Begench Amanov 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

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

2013-08-09 Thread Mark Rotteveel
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 troubles

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

2013-08-15 Thread Mark Rotteveel
On Thu, 15 Aug 2013 02:54:57 + (UTC), Lt Col RDS Chauhan 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 sysdb

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

2013-10-22 Thread Mark Rotteveel
mpty 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 c

firebird-net-provider@lists.sourceforge.net

2013-11-26 Thread Mark Rotteveel
he 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 leav

firebird-net-provider@lists.sourceforge.net

2013-11-26 Thread 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 l

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

2013-11-26 Thread Mark Rotteveel
e 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 ---

firebird-net-provider@lists.sourceforge.net

2013-12-06 Thread Mark Rotteveel
n't have to add boiler plate to ensure the object gets closed and disposed when exceptions occur. -- Mark Rotteveel -- Sponsored by Intel(R) XDK Develop, test and display web and hybrid apps with a single code base.

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-15 Thread Mark Rotteveel
On 13-12-2013 11:33, Mr. John wrote: > Hi ! > I'm using VB.NET 2008 with FB SS 2.5 and FirebirdClient 2.7.7.0 > I need to detect if current FB connection is local or over a network. Could you provide some detail on why you need to know this? Mark --

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

2013-12-27 Thread Mark Rotteveel
ion 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

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

2014-03-14 Thread Mark Rotteveel
On Fri, 14 Mar 2014 04:54:34 +, "Dass, Sukhen (NDH-MRM)" 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 shar

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

2014-03-20 Thread Mark Rotteveel
On Thu, 20 Mar 2014 03:51:23 -0600, David De Smet 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 w

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

2014-04-08 Thread Mark Rotteveel
On Tue, 8 Apr 2014 14:33:35 +0200, André Knappstein 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 -

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

2014-05-01 Thread Mark Rotteveel
On Thu, 1 May 2014 11:49:02 +0200, Jiri Cincura wrote: > On Thu, May 1, 2014 at 8:49 AM, Parzival wrote: >> Is there a way to get fbBackup working on remote Clients? > > http://tracker.firebirdsql.org/browse/DNET-287?focusedCommentId=20797&page=com.atlassian.jira.plugin.system.issuetabpanels%3Ac

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

2014-05-01 Thread Mark Rotteveel
On 1-5-2014 19:40, Jiri Cincura wrote: > On Thu, May 1, 2014 at 12:21 PM, Mark Rotteveel 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&#

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

2014-06-27 Thread Mark Rotteveel
h: 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 p

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

2014-07-06 Thread 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 --

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

2014-07-07 Thread Mark Rotteveel
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 s

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

2014-07-12 Thread Mark Rotteveel
e 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

2014-07-14 Thread Mark Rotteveel
On Sun, 13 Jul 2014 23:21:04 +0530, LtColRDSChauhan 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 incomp

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

2014-09-05 Thread Mark Rotteveel
On Fri, 05 Sep 2014 12:08:33 +0100, Scott Morgan 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 b

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

2014-12-22 Thread Mark Rotteveel
. > 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 Pa

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

2015-07-23 Thread Mark Rotteveel
On Thu, 23 Jul 2015 07:56:09 +, Jiří Činčura 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 =>

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

2015-08-18 Thread Mark Rotteveel
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 -

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

2015-09-14 Thread Mark Rotteveel
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:

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

2015-09-14 Thread 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

2015-09-19 Thread 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 Rot

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

2015-09-25 Thread 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 t

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

2015-12-16 Thread 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,

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

2016-01-05 Thread 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 i

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

2016-01-26 Thread 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 tha

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

2016-01-26 Thread 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/

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

2016-01-26 Thread 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 r

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

2016-01-26 Thread 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

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

2016-01-26 Thread Mark Rotteveel
Ok, I can't seem to login into the CMS. On 26-1-2016 18:45, Mark Rotteveel wrote: > Sorry, I meant that I'll create a news item tonight, not a ticket. > > Mark > > - Bericht beantwoorden - > Van: "Jiří Činčura" > Aan: "For users

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

2016-01-27 Thread Mark Rotteveel
News item has been published and download links have been updated. Mark On 26-1-2016 15:32, Mark Rotteveel wrote: > I do have the rights. Did you already have the news item ready for > publishing? > > Mark > > > - Bericht beantwoorden - > Van: "Jiří

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

2016-01-31 Thread Mark Rotteveel
ilar) 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 + R

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

2016-02-02 Thread 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

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

2016-03-23 Thread Mark Rotteveel
t; 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

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

2016-03-25 Thread Mark Rotteveel
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

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

2016-04-17 Thread 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 (M&F Engineering AG)" Aan: "firebird-net-provider@lists.sourceforge.net" Onderwerp: [Firebird-net-provider] N

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

2016-04-24 Thread Mark Rotteveel
n 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

Re: [Firebird-net-provider] double subscribed

2016-04-30 Thread Mark Rotteveel
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 fa

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

2016-05-01 Thread Mark Rotteveel
ecessary 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 -

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

2016-05-03 Thread 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: [Fire

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

2016-05-04 Thread 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 eve

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

2016-06-04 Thread Mark Rotteveel
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 --

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

2016-06-05 Thread 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

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

2016-06-20 Thread 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 de

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

2016-07-02 Thread 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. M

Re: [Firebird-net-provider] Connection charset

2016-08-21 Thread Mark Rotteveel
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 mi

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

2017-03-17 Thread 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, th

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

2017-03-17 Thread Mark Rotteveel
On 2017-03-17 20:16, Clyde Eisenbeis wrote: > I clearly misunderstood. > > To be certain I understand the terminology, an embedded server is one > that is accessible via the Internet? No, Firebird Embedded is a (native) client API that directly accesses a Firebird database engine in the same pro

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

2017-03-18 Thread 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 po

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

2017-03-18 Thread Mark Rotteveel
on FbConnectionStringBuilder https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionStringBuilder.cs Mark -- Mark Rotteveel -- Check

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

2017-03-19 Thread Mark Rotteveel
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 s

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

2017-03-25 Thread Mark Rotteveel
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 `

Re: [Firebird-net-provider] New list

2017-09-09 Thread Mark Rotteveel
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

Re: [Firebird-net-provider] New list

2017-09-10 Thread Mark Rotteveel
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

Re: [Firebird-net-provider] New list

2017-09-10 Thread 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

Re: [Firebird-net-provider] New list

2017-09-10 Thread 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

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

2017-09-10 Thread Mark Rotteveel
or 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 --

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

2018-09-16 Thread Mark Rotteveel
ceforge.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

2018-09-19 Thread 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

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

2011-05-29 Thread Mark Rotteveel
UES > ('NUMER',...)"; > Form2->pFIBTransaction1->StartTransaction(); > Form2->pFIBQuery1->ExecQuery(); You are explicitly starting a transaction, if you do then you also need to commit. -- Mark Rotteveel ---

Re: [Firebird-net-provider] Can't sonnect if fiel contains ö?

2011-08-11 Thread Mark Rotteveel
On Wed, 10 Aug 2011 22:59:23 +0200, Kjell Rilbe wrote: > Ah, it seems to be fixed in 2.6.5.0. Great! > > But the first time I tried, I had forgotten to rename the db file back > from DiamondsSok.fdb with an o without dots. Of course it couldn't find > the file, but the error string was not corr

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

2011-09-29 Thread Mark Rotteveel
On Thu, 29 Sep 2011 15:40:52 +0100, Scott Morgan 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 s

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

2011-09-30 Thread 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 th

Re: [Firebird-net-provider] Error when using Fbembed.dll

2011-10-26 Thread Mark Rotteveel
t; There is no C:\Users\Jiri folder on my PC, this obviously relates to one > of the developers Jiri?? I agree the error does not make sense. It looks like the error message contains part of the build path of the .NET provider itself. -- Mark Rotteveel

[Firebird-net-provider] Failed to find Data Provider (Stackoverflow question)

2011-11-18 Thread Mark Rotteveel
I noticed this question on stackoverflow: http://stackoverflow.com/questions/8178719/firebird-visual-studio-2010-failed-to-find-data-provider Does anyone know the answer. I would answer it myself if I could, but I have insufficient knowledge of Visual Studio, .NET and the firebird.net-provider :)

Re: [Firebird-net-provider] Interbase 6

2012-03-27 Thread Mark Rotteveel
On Tue, 27 Mar 2012 10:25:25 +0800, "Gilbert" 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

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

2018-02-07 Thread Mark Rotteveel (JIRA)
-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