I was able to make this configuration work with a couple of tweaks to the database and web.config
First I am using the latest RC1 provider 2.0.1.0 from which I build the tables from the supplied scripts. 1. In the corrected web.config has the passwordFormat listed twice, and I deleted the first entry which was for Hashed password format. (Does your membership API support hashed formats?) 2. I had to tweak the MEMBERSHIP_PROVIDER, USERS table, ISONLINE field to give a default value of 0. When looking at the original script no default value was assigned, and when the create user SP was called, it would fail because of a null value being inserted into the table. After these modifications were made I was able to use Visual Studio to add and remove users to the database. I have not tested using the provider API at runtime yet, but I will tonight. Do you have any documentation on the firebird membership provider? Could you use any help on this project? Thanks, Steven Message: 2 Date: Mon, 25 Sep 2006 11:32:21 +0200 From: "Alessio Ferrari" <[EMAIL PROTECTED]> Subject: Re: [Firebird-net-provider] Web.config for firebird To: [email protected] Message-ID: <[EMAIL PROTECTED]> I follow your hint, but the Web Site Administration Tool, in the section Security, give me a new error ("Hashed or Encrypted passwords are not supported with auto-generated keys."). I have to create users and roles whit Web Site Administration Tool. I send the code to my web.config. Thanks. Alessio. <?xml version="1.0"?> <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0";> <appSettings/> <connectionStrings> <add name="Membership" connectionString="character set=UNICODE_FSS;data source=127.0.0.1;Initial Catalog=C:\MEMBERSHIP_PROVIDER1.FDB;user id=SYSDBA;password=masterkey" providerName="FirebirdSql.Data.FirebirdClient"/> </connectionStrings> <system.data> <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, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/> </DbProviderFactories> </system.data> <system.web> <pages> <namespaces> <clear/> <add namespace="System"/> <add namespace="System.Collections"/> <add namespace="System.Collections.Specialized"/> <add namespace="System.Configuration"/> <add namespace="System.Text"/> <add namespace="System.Text.RegularExpressions"/> <add namespace="System.Web"/> <add namespace="System.Web.Caching"/> <add namespace="System.Web.SessionState"/> <add namespace="System.Web.Security"/> <add namespace="System.Web.Profile"/> <add namespace="System.Web.UI"/> <add namespace="System.Web.UI.WebControls"/> <add namespace="System.Web.UI.WebControls.WebParts"/> <add namespace="System.Web.UI.HtmlControls"/> </namespaces> </pages> <membership defaultProvider="FbNewMembershipProvider"> <providers> <add connectionStringName="Membership" passwordFormat="Hashed" name="FbNewMembershipProvider" type="FirebirdSql.Web.Providers.FbMembershipProvider, FirebirdSql.Web.Providers, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3D06A02581B682F8" applicationName="WebSite14" requiresQuestionAndAnswer="true" enablePasswordRetrieval="false" minRequiredPasswordLength="6" requiresUniqueEmail="false"/> </providers> </membership> <authentication mode="Windows"/> <compilation debug="true"> <assemblies> <add assembly="FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750ABCC3150B00C"/> <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> </assemblies> </compilation> </system.web> </configuration> ------------------------------ Message: 3 Date: Mon, 25 Sep 2006 11:49:56 +0200 From: Le roy Arnaud <[EMAIL PROTECTED]> Subject: Re: [Firebird-net-provider] Web.config for firebird To: [email protected] Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset="iso-8859-15"; format=flowed Alessio Ferrari a couch? sur son ?cran : > I follow your hint, but the Web Site Administration Tool, in the section > Security, give me a new error ("Hashed or Encrypted passwords are not > supported with auto-generated keys."). Ok try this <add connectionStringName="Membership" passwordFormat="Hashed" name="FbNewMembershipProvider" type="FirebirdSql.Web.Providers.FbMembershipProvider, FirebirdSql.Web.Providers, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3D06A02581B682F8" applicationName="WebSite14" requiresQuestionAndAnswer="true" enablePasswordRetrieval="true" passwordFormat="Clear" minRequiredPasswordLength="6" requiresUniqueEmail="false"/> ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
