Re: [Firebird-net-provider] Can not connect to Firebird 3.0 using .NETProvider-3.0.2.0
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] Can not connect to Firebird 3.0 using .NETProvider-3.0.2.0
Mark Rotteveel mark@... writes: 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. The conncetion string generated looks as follows (username and password replaced): 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. Thank you, Mark, I already tried that, but missed, that I was editing AuthClient - property :-( ... Now, it works! And: Yes, the user has to be added again. Many thanks and sunny days, Thomas -- 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