Kyle Green | 4 May 00:45 2016

Re: Fb 3 connection string upgrade

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?

 

Thanks

 

 

 

---
Kyle Green

On 2016-05-03 11:01, Mark Rotteveel wrote:

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" <kyleblm-fDpYTK8McCxGyB1TfK1D2Jyaq/HwIaQU@public.gmane.org>
Aan: <firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Kyle Green | 3 May 19:38 2016

Fb 3 connection string upgrade

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
Mark Rotteveel | 1 May 12:06 2016
Picon
Gravatar

Re: Connection to Firebird 3 With Legacy Authentication Fails

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
Kyle | 29 Apr 18:16 2016

Re: Firebird Provider 4.10 on VS 2008 THANKS

Thank you.

 

Apparently I have not upgraded for several years - everything was working so well :)

 

 

 

 

On 2016-04-29 07:34, Jiří Činčura wrote:

Yep. The 3.5 support has been dropped a long time ago. 
 
-- 
Mgr. Jiří Činčura
Independent IT Specialist
 
 
On Thu, Apr 28, 2016, at 20:03, Kyle Green wrote:
> I’ve installed the provider from the msi installer on a Windows 10
> laptop running Visual Studio 2008. I replaced Firebird 2.5 with the new
> Firebird 3.0 release.
> I have project configured for .net 3.5. I removed the previous provider
> which was working against Firebird 2.5.
>
> When I try to add a reference for the new provider, it just doesn’t take
> it. It shows up the reference list with a yellow triangle, and no
> information,
> Does this provider not work with Visual Studio 2008, or with .net 3.5?
>
> 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> 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-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Mark Rotteveel | 30 Apr 13:57 2016
Picon
Gravatar

Re: double subscribed

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-request@... 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

[FB-Tracker] Created: (DNET-679) Except after updating to 4.10.0

Except after updating to 4.10.0
-------------------------------

                 Key: DNET-679
                 URL: http://tracker.firebirdsql.org/browse/DNET-679
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.10.0.0
         Environment: Windows Server R2 2008 R2 Enterprise 64-bits;  IIS 7.5; .NET Framework 4.0.30319; Visual
Studio 2013;
            Reporter: Pedro Filipe de Morais Lima
            Assignee: Jiri Cincura
            Priority: Critical

Updated the " Firebird ADO.NET Data provider " for version 4.10.0 and I am getting , sometimes , the
following exception in my application:

Exception information: 
    Exception type: NullReferenceException 
    Exception message: Object reference not set to an instance of an object.
   at FirebirdSql.Data.Common.Extensions.TryGetTarget[T](WeakReference  weakReference, T& target)
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.RemovePreparedCommand    (FbCommand command)
   at FirebirdSql.Data.FirebirdClient.FbCommand.Release()
   at FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing)

--

-- 
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

------------------------------------------------------------------------------
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
LtColRDSChauhan | 24 Apr 09:16 2016
Picon

Connection to Firebird 3 With Legacy Authentication Fails

Hi,

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'
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.

Please advise.
Regards,
Rajiv
------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Rick Roen | 22 Apr 16:16 2016
Picon

Update for FB3.0 date?

Now that FB3 has been officially released, is there and ETA for the Net Provider?  I'm especially interested to have the new Boolean datatype working.

Regards,
Rick
------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Joslat | 21 Apr 14:55 2016
Picon

"Unspecified" Transaction after creation..

Hi,

There is any way to validate the Transaction configuration after Starting
it?
If I create a transaction options with FbTransactionBehavior.Wait, for
example, And start the transaction with BeginTransaction, like: 
this.conn.BeginTransaction(new FbTransactionOptions() { TransactionBehavior
= FbTransactionBehavior.Wait});

After this the transaction object on the connection appears as
"unspecified".
How can I check the current active transaction options of the current
transaction? 

Thanks,
Jose

--
View this message in context: http://firebird.1100200.n4.nabble.com/Unspecified-Transaction-after-creation-tp4643287.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

------------------------------------------------------------------------------
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
Picon

Two DbContexts same database

Is it possible to have two different database contexts that points to
same databases file?

------------------------------------------------------------------------------
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

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

Hi Mark

 

Thank you for your fast response here and on StackOverflow.

 

I had installed the version 3.0.1 of de DDEX instead of 3.0.2. Now it works. Sorry about this.

 

Regards,

Rico

 

Von: Mark Rotteveel [mailto:mark-gyL5Wioy0x9z2lryZHS3NA@public.gmane.org]
Gesendet: Sonntag, 17. April 2016 21:13
An: For users and developers of the Firebird .NET providers <firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
Betreff: Re: [Firebird-net-provider] Not able to choose Firebird ADO.Net Data provider as data source in VS2015

 

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&amp;F Engineering AG)" <
Rico.Widmer-cIJAeqhdZAxWk0Htik3J/w@public.gmane.org>
Aan: "
firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" <firebird-net-provider-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
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:

<DbProviderFactories>

      <remove invariant="FirebirdSql.Data.FirebirdClient" />

      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />

</DbProviderFactories>

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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Gmane