Jiri and Paul, thanks for your quick repsonses.
Just to confirm, I should do something like this: http://www.codeproject.com/Articles/165159/Custom-Membership-Providers Please let me know if I'm finally on the right track :) Thanks, Markus On Wed, Feb 27, 2013 at 5:02 PM, Mercea Paul <paul.mer...@almexa.ro> wrote: > Hi Markus > > On 2013.02.27 4:33 PM, Markus Ostenried wrote: >> Hi all, >> >> I've been using Firebird with Delphi for many years, wrote a few .NET >> applications and have experience in web development. >> However: I never did web development with .NET and my only experience >> with the Firebird .NET provider was a hello world program in Mono on >> Debian a few years ago. >> >> My task is to write a simple web application using ASP.NET which >> connects to an existing Firebird database. User authentication has to >> use data in an existing table and I need to display data returned from >> a stored procedure. Updating data should call another stored >> procedure. >> >> I did some research and read quite a few articles about ASP.NET which >> led me to trying out MVC4, also the SimpleMembershipProvider sounded >> like what I need (I'm open for suggestions here). >> >> I have installed NETProvider-3.0.2.0 and DDEXProvider-3.0.0.0, created >> a new MVC4 Internet application, and in web.config adjusted/added the >> following: >> <connectionStrings> <add name="DefaultConnection" connectionString .... >> <DbProviderFactories><remove >> invariant="FirebirdSql.Data.FirebirdClient"/> <add name="Firebird Data >> Provider"...... >> >> When I run the application and click on the "Register" link I get the >> following exception: >> {"The ASP.NET Simple Membership database could not be initialized. ..."} >> inner exception: {"Dynamic SQL Error\r\nSQL error code = >> -104\r\nToken unknown - line 1, column 33\r\n."} >> with stack trace: >> at >> FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior >> behavior) >> at >> FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior >> behavior) >> at System.Data.Common.DbCommand.ExecuteReader() >> at WebMatrix.Data.Database.<QueryInternal>d__0.MoveNext() >> at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source) >> at WebMatrix.Data.Database.QuerySingle(String commandText, Object[] args) >> at WebMatrix.WebData.DatabaseWrapper.QuerySingle(String >> commandText, Object[] parameters) >> at WebMatrix.WebData.SimpleMembershipProvider.CheckTableExists(IDatabase >> db, String tableName) >> at WebMatrix.WebData.SimpleMembershipProvider.CreateTablesIfNeeded() >> at >> WebMatrix.WebData.WebSecurity.InitializeMembershipProvider(SimpleMembershipProvider >> simpleMembership, DatabaseConnectionInfo connect, String >> userTableName, String userIdColumn, String userNameColumn, Boolean >> createTables) >> at >> WebMatrix.WebData.WebSecurity.InitializeProviders(DatabaseConnectionInfo >> connect, String userTableName, String userIdColumn, String >> userNameColumn, Boolean autoCreateTables) >> at WebMatrix.WebData.WebSecurity.InitializeDatabaseConnection(String >> connectionStringName, String userTableName, String userIdColumn, >> String userNameColumn, Boolean autoCreateTables) >> at >> MvcApplication1.Filters.InitializeSimpleMembershipAttribute.SimpleMembershipInitializer..ctor() >> in d:\Dinge\Documents\Visual Studio >> 2012\Projects\MvcApplication1\MvcApplication1\Filters\InitializeSimpleMembershipAttribute.cs:line >> 41 >> >> InitializeSimpleMembershipAttribute.cs:line 41 looks like this: >> WebSecurity.InitializeDatabaseConnection("DefaultConnection", >> "UserProfile", "UserId", "UserName", autoCreateTables: true); >> >> which is called by: >> public override void OnActionExecuting(ActionExecutingContext filterContext) >> { >> // Ensure ASP.NET Simple Membership is initialized only once per app start >> LazyInitializer.EnsureInitialized(ref _initializer, ref >> _isInitialized, ref _initializerLock); >> } >> >> Can you tell me what went wrong here? >> Also, in general, how would I debug an error like this? I'd like to >> know what SQL statement was being executed but I couldn't find it in >> the exception dialog. Are there any log files? How can I step into the >> provider code? >> >> I'd be thankful for any hints on how to implement my application. >> Maybe I need to start from a different application template or use a >> different membership provider? >> >> TIA, >> Markus > > You have 2 options: > 1. Use existing Firebird Membership > a. First create a ASP.Net MVC3 application an close the solution. > b. Create a ASP.Net MVC4 application. > c. Copy from MVC3 Account controller and model. > d. Configure web.config as usual FBMembershipProvider. > 2. Write you own membership. > You can view the sources from http://aspnetwebstack.codeplex.com/ > as sample. > > > HTH, > Paul MERCEA > ___________________________________________ > > E-mail: paul.mer...@almexa.ro > > ___________________________________________ > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_feb > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
