You are right and you are wrong at the same time, and I think that I just missed something that Jiri announced somewhere :-)
You are right, because using the FBConnectionStringBuilder solves the problem. You are wrong because it has nothing to do with setting an explicitly empty role (only with the way *how* I did, by not using CSB). I have to be able to set an empty role to avoid unnecessary "IF/THENs" or even "TRY/CATCHes" when reading DB-config from a file that can be configured externally. I must have overlooked that "role" is now "role name". This must have happened somewhere along the way from 2.6. to 3.0. Now that I know I can fix it easily in my code. At the same time I found that I have to fix "server type = 0" into "server type = default". Why I did not use CSB right away? You know that old habits die hard; in my case "oldest habits die hardest". I have that code in my application since 2005 or so, and FBCsb had some issues in the beginning, so I did without, at first. I never looked at that code again until today :-) > Why not use the FBConnectionStringBuilder? > That is what I always do and indeed, I don't set the role > explicitly to empty. So this might indeed be your problem. > -----Oorspronkelijk bericht----- > Van: André Knappstein [mailto:knappst...@beta-eigenheim.de] > Verzonden: maandag 5 november 2012 14:48 > Aan: For users and developers of the Firebird .NET providers > Onderwerp: Re: [Firebird-net-provider] Empty string for "Role" invalid in 3.x > Hello Alexander, > maybe there is some difference between > - not assigning a role at all > - assigning "Role = "+String.Empty > Sounds strange, but I will try this out, just in case. >> Hi >> I migrated from 2.6 and 2.7 to 3.0 without changing any code. >> I also never fill in the role. >> It must be something else. >> -----Oorspronkelijk bericht----- >> Van: Jiri Cincura [mailto:disk...@cincura.net] >> Verzonden: maandag 5 november 2012 12:32 >> Aan: For users and developers of the Firebird .NET providers >> Onderwerp: Re: [Firebird-net-provider] Empty string for "Role" invalid >> in 3.x >> How the complete connection string looks like? >> On Mon, Nov 5, 2012 at 12:14 PM, André Knappstein >> <knappst...@beta-eigenheim.de> wrote: >>> I noticed a change which I did not read about before. >>> Maybe I missed it, maybe it was not announced. >>> My last installed version was 2.6. on most seats, 2.75 on some. >>> >>> If "Role = " (empty string), the connection string now is invalid. >>> >>> I will have to roll back to 2.6 for now, because I will first have >>> to change my code a bit (I am feeding connection data from >>> encrypted files and some of them contain empty Role). >>> >>> >>> >>> >>> >>> --------------------------------------------------------------------- >>> - >>> -------- 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 >> -- >> Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | >> http://www.ID3renamer.com >> ---------------------------------------------------------------------- >> -------- 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 >> ---------------------------------------------------------------------- >> -------- 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 > ------------------------------------------------------------------------------ > 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 > ------------------------------------------------------------------------------ > 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 mit freundlichen Grüßen, André Knappstein EDV und Controlling ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: knappst...@beta-eigenheim.de Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402 ------------------------------------------------------------------------------ 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
