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
