Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Jiri C. <di...@ci...> - 2013-03-11 16:20:51
|
On Mon, Mar 11, 2013 at 4:12 PM, eMeL <em...@em...> wrote: > I have known in VS2010 the Express version can't use DDEX Provider. > > Is it same in VS2012 Express? > > eMeL > As you asked already on my blog, I answered first there: http://blog.cincura.net/233086-ado-net-provider-for-firebird-3-0-2-released/#comment-15937 . -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com |
|
From: eMeL <em...@em...> - 2013-03-11 15:28:32
|
I have known in VS2010 the Express version can't use DDEX Provider. Is it same in VS2012 Express? eMeL |
|
From: Glenn T. H. <gl...@ve...> - 2013-03-04 11:30:29
|
Firebird Version: 2.1
Provider version: 2.0.1.0
The script itself contains some business-sensitive information, but seeing as I could run every command without any errors in the Database Workbench application, I don't really suspect the script itself.
This is also in a production environment so changing to newer versions is not really welcome with our support staff.
Glenn Thomas Hvidsten
-----Original Message-----
From: Jiri Cincura [mailto:di...@ci...]
Sent: 4. mars 2013 10:09
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Strange behaviour when running FbBatchExecution on script file
On Mon, Mar 4, 2013 at 9:43 AM, Glenn Thomas Hvidsten <gl...@ve...> wrote:
> I hope you’ll be able to help me with this.
Hardly without any information. Firebird version? Provider version?
Script itself? ...
--
Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com
------------------------------------------------------------------------------
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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
****************************************************************************
Denne epost har blitt kontrollert for virus av Comendo Norge AS
This e-mail has been scanned for viruses by http://www.comendo.no
****************************************************************************
|
|
From: Jiri C. <di...@ci...> - 2013-03-04 09:38:27
|
On Mon, Mar 4, 2013 at 9:43 AM, Glenn Thomas Hvidsten <gl...@ve...> wrote:
> I hope you’ll be able to help me with this.
Hardly without any information. Firebird version? Provider version?
Script itself? ...
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Markus O. <ma...@gm...> - 2013-03-04 09:30:20
|
I managed to write my own membership provider, turns out it wasn't hard after all -- I just had to find the relevant information out of everything that's out there :) In case anyone else needs this information: I created a new class extending ExtendedMembershipProvider, I implemented the methods similar to this example: http://msdn.microsoft.com/en-us/library/6tc47t75(v=vs.100).aspx For a minimal membership provider it's sufficient to only implement a few methods: ValidateUser, CreateUser, GetUser and the properties MinRequiredPasswordLength, RequiresUniqueEmail. http://www.codeproject.com/Articles/165159/Custom-Membership-Providers Regards, Markus |
|
From: Glenn T. H. <gl...@ve...> - 2013-03-04 08:59:59
|
Hi!
I'm noticing some strange behaviour with the Firebird server when I try to run a SQL script file using the FbBatchExecution command.
In the log file I notice a couple of lines like this:
GTHVIDSTEN (Server) Fri Mar 01 10:22:19 2013
Shutting down the server with 2 active connection(s) to 2 database(s), 0 active service(s)
Followed by a message in the event log about the command gfix.exe giving an access violation. I'm guessing this is because the server has shut down and gfix.exe no longer being able to find the server and giving what is similar to a NullReferenceException.
I have tried to run the script line by line in Database Workbench and there doesn't seem to be anything wrong with the script file itself.
So why is this happening? Does this mean that some of the lines in the script are ignored?
This is the code I use to run the script:
using (FbConnection conn = new FbConnection(myConnectionString))
{
conn.Open();
FbScript script = new FbScript(myScriptFileLocation);
script.Parse();
FbBatchExecution fbe = new FbBatchExecution(conn);
foreach (string cmd in script.Results)
fbe.SqlStatements.Add(cmd);
fbe.Execute(true);
}
I hope you'll be able to help me with this.
Sincerely
Glenn Thomas Hvidsten
****************************************************************************
Denne epost har blitt kontrollert for virus av Comendo Norge AS
This e-mail has been scanned for viruses by http://www.comendo.no
****************************************************************************
|
|
From: asavasamuel <kw...@ya...> - 2013-03-03 23:59:24
|
christian Kessing I haven't used it, but Kellerman Software has a LINQ provider for Firebird https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx -- View this message in context: http://firebird.1100200.n4.nabble.com/Re-NullReferenceException-and-deadlock-while-calling-saveChanges-on-ObjectContext-tp3478815p4632920.html Sent from the firebird-net-provider mailing list archive at Nabble.com. |
|
From: asavasamuel <kw...@ya...> - 2013-03-03 23:02:50
|
meubanks I haven't used it, but Kellerman Software has a LINQ provider for Firebird https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx -- View this message in context: http://firebird.1100200.n4.nabble.com/Linq-and-Nulls-bug-tp4017847p4632919.html Sent from the firebird-net-provider mailing list archive at Nabble.com. |
|
From: Manfred R. (J. <tr...@fi...> - 2013-03-02 17:34:04
|
Incorrect Exception - Could not find FirebirdSql.Data.FirebirdClient.resources
------------------------------------------------------------------------------
Key: DNET-488
URL: http://tracker.firebirdsql.org/browse/DNET-488
Project: .NET Data provider
Issue Type: Bug
Environment: Window 7
Reporter: Manfred Roßkamp
Assignee: Jiri Cincura
Priority: Minor
If you cause an exception for example with the following incorrect sql statement:
"select date() from xy"
I get the following exception:
{"Die Datei \"FirebirdSql.Data.FirebirdClient.resources\" konnte nicht gefunden werden.":null}
(Look at the end of this description for the stacktrace)
In my environment i have the following dictionary structure:
MyApp.exe
Firebird\x32\FirebirdSql.Data.FirebirdClient.dll
Firebird\x32\*(32 bit Firebird embedded Version)
Firebird\x64\FirebirdSql.Data.FirebirdClient.dll
Firebird\x64\*(64 bit Firebird embedded Version)
MyApp is compiled in AnyCPU and it load's dynamically the FirebirdSql.Data.FirebirdClient.dll from the correct subfolder.
I solved this problem with the following changes in FirebirdSql.Data.Common.IscException
1. Add the following method to get the correct resource set:
#region - Statics -
private static Dictionary<string, ResourceSet> resources = new Dictionary<string, ResourceSet>();
private static ResourceSet GetResourceSet(string name)
{
ResourceSet result;
if (!resources.TryGetValue(name, out result))
{
using (var resStream = Assembly.GetExecutingAssembly().GetManifestResourceStream(
name + ".resources"))
{
result = new ResourceSet(resStream);
resources[name] = result;
}
}
return result;
}
#endregion
2. Call the specified method instead of creating a new ResourceManager
at
bei System.Reflection.RuntimeAssembly.InternalGetSatelliteAssembly(String name, CultureInfo culture, Version version, Boolean throwOnFileNotFound, StackCrawlMark& stackMark)
bei System.Resources.ManifestBasedResourceGroveler.GetSatelliteAssembly(CultureInfo lookForCulture, StackCrawlMark& stackMark)
bei System.Resources.ManifestBasedResourceGroveler.GrovelForResourceSet(CultureInfo culture, Dictionary`2 localResourceSets, Boolean tryParents, Boolean createIfNotExists, StackCrawlMark& stackMark)
bei System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo requestedCulture, Boolean createIfNotExists, Boolean tryParents, StackCrawlMark& stackMark)
bei System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents)
bei System.Resources.ResourceManager.GetString(String name, CultureInfo culture)
bei System.Resources.ResourceManager.GetString(String name)
bei FirebirdSql.Data.Common.IscException.BuildSqlState()
bei FirebirdSql.Data.Common.IscException.BuildExceptionData()
bei FirebirdSql.Data.Client.Native.FesConnection.ParseStatusVector(IntPtr[] statusVector, Charset charset)
bei FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector)
bei FirebirdSql.Data.Client.Native.FesStatement.Prepare(String commandText)
bei FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Reinhard G. <R.G...@bs...> - 2013-03-01 11:55:51
|
If someone has the same problem:
I found a solution that works for me.
The Firebird .NET Provider Source contains 16 selects to the system tables.
I created tables for the resultset of each select and a stored procedure that fills these tables.
Then I replaced the selects in the providers source code to select from these tables instead from the system tables and compiled it.
Result: 1 Min 20 Sec instead of 8+ Min for updating the Entity Model.
Greetings Reinhard
-----Ursprüngliche Nachricht-----
Von: Jiri Cincura [mailto:di...@ci...]
Gesendet: Mittwoch, 13. Februar 2013 17:22
On Wed, Feb 13, 2013 at 4:19 PM, Reinhard Gunacker <R.G...@bs...> wrote:
> The point is, that I selected only one single Table but it is slow anyhow!
Yes, the query is same. Only amount of data transfered is not that huge. If you're on a fast line that will not make a difference.
--
Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: asavasamuel <kw...@ya...> - 2013-03-01 08:17:24
|
Jiri Cincura I haven't used it, but Kellerman Software has a LINQ provider for Firebird https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx -- View this message in context: http://firebird.1100200.n4.nabble.com/Generating-entity-classes-using-a-firebird-database-tp1104885p4632913.html Sent from the firebird-net-provider mailing list archive at Nabble.com. |
|
From: Markus O. <ma...@gm...> - 2013-02-28 18:36:50
|
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 <pau...@al...> 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: pau...@al... > > ___________________________________________ > > > ------------------------------------------------------------------------------ > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Mercea P. <pau...@al...> - 2013-02-27 16:21:07
|
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: pau...@al...
___________________________________________
|
|
From: Jiri C. <di...@ci...> - 2013-02-27 15:22:22
|
I think you're better writing your own membership, simply
username/password, maybe roles. It will give you more flexibility and
benefits. Membership providers are not that much fun in 2013. :) But
if you want to use it anyway, you have to create the database yourself
using the scripts provided. Also you'll need to build the membership
provider if you'll be using latest .NET provider, because it's not
actively maintained.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Markus O. <ma...@gm...> - 2013-02-27 14:33:59
|
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
|
|
From: Hélio T. de O. (J. <tr...@fi...> - 2013-02-23 17:29:33
|
The "Detach" is not called in the Dispose of connection
-------------------------------------------------------
Key: DNET-487
URL: http://tracker.firebirdsql.org/browse/DNET-487
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 3.0.2.0
Environment: .NET 4.0
Firebird Classic v1.5
Reporter: Hélio Tibagí de Oliveira
Assignee: Jiri Cincura
The method "isc_detach_database" is not being called in dispose of connections. This makes the process of Firebird (classic mode) is loaded into memory and is only released when the application terminates. Unfortunately we use the old Firebird 1.5, but probably this problem should occur in all versions.
Below is a snippet of code to bypass this problem:
using (var conn = new FbConnection("User=SYSDBA;Password=masterkey;Database=myserver:mydatabase.fdb;Dialect=3;Charset=WIN1252;"))
{
conn.Open();
DataTable dt = new DataTable();
new FbDataAdapter("SELECT FIRST 400 * FROM TABLE", conn).Fill(dt);
//Hack by reflection to FIX the close/dispose issue
var fbConnectionInternal = typeof(FbConnection).GetField("innerConnection", BindingFlags.NonPublic | BindingFlags.Instance);
var innerConnection = fbConnectionInternal.GetValue(conn);
var iDatabase = innerConnection.GetType().GetField("db", BindingFlags.NonPublic | BindingFlags.Instance);
var db = iDatabase.GetValue(innerConnection);
var detachMethod = db.GetType().GetMethod("Detach");
detachMethod.Invoke(db, null);
conn.Close();
}
Please can you fix this problem? Many problems are occurring in our servers because of this. Thanks in advance.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Yiannis B. <yia...@gm...> - 2013-02-21 21:29:30
|
Thank you Jiri, please ignore my previous message because I was able to find a solution to the problem. Here are the steps to solve this issue in case someone else has the same problem: Go to Microsoft Sql Server 2008 feauture pack download center http://www.microsoft.com/en-in/download/confirmation.aspx?id=16978 I am not sure which one solved the problem (I think one of the first 2) but you can download and install all of them and try to see if the error goes away, because restart is not required: Microsoft® System CLR Types for SQL Server® 2008 R2 Microsoft® SQL Server® 2008 R2 Native Client Microsoft® SQL Server® 2008 R2 Shared Management Objects Microsoft® SQL Server® 2008 R2 ADOMD.NET Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2 Microsoft® SQL Server® 2008 R2 Analysis Management Objects ** Yiannis 2013/2/21 Jiri Cincura <di...@ci...> > Probably the easiest is to fill all manually. There are some cases, > where the default MS SQL presumption (i.e. statement validation) kicks > in. > > -- > Jiri {x2} Cincura (x2develop.com founder) > http://blog.cincura.net/ | http://www.ID3renamer.com > > > ------------------------------------------------------------------------------ > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Yiannis B. <yia...@gm...> - 2013-02-21 21:05:08
|
It is an existing project with many datasets, dataadapters that where
created using the build in VS designer, migrated from VS 2008. I should
make the DDEX provider work, or else I get this error each time I try to
make a change to existing table adapters.
Any idea about how to intall this Microsoft.Sqlserver.Types assembly and
its dependencies?
2013/2/21 Jiri Cincura <di...@ci...>
> Probably the easiest is to fill all manually. There are some cases,
> where the default MS SQL presumption (i.e. statement validation) kicks
> in.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: Jiri C. <di...@ci...> - 2013-02-21 10:13:34
|
Probably the easiest is to fill all manually. There are some cases,
where the default MS SQL presumption (i.e. statement validation) kicks
in.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2013-02-20 18:47:27
|
On Tue, Feb 19, 2013 at 7:39 PM, mateuslisot <mat...@gm...> wrote:
> I tried to access the link that solved your problem, but it is not working.
Blog should be back online now.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: mateuslisot <mat...@gm...> - 2013-02-19 18:40:01
|
hello michael and Jiri Cincura, I am facing the same problem that Michael explained. The .Net provider works with the visual studio 2010, but dont work on the IIS. I tried to access the link that solved your problem, but it is not working. Can you please explain what was the solution ? Mateus -- View this message in context: http://firebird.1100200.n4.nabble.com/Deploy-Unable-to-find-the-requested-Net-Framework-Data-Provider-tp3869191p4632858.html Sent from the firebird-net-provider mailing list archive at Nabble.com. |
|
From: Esteban P. B. (JIRA) <tr...@fi...> - 2013-02-14 16:30:40
|
CLONE -.NET Provider 3.0.2 msi intaller does not modify machine.config files
----------------------------------------------------------------------------
Key: DNET-486
URL: http://tracker.firebirdsql.org/browse/DNET-486
Project: .NET Data provider
Issue Type: Bug
Components: DDEX Provider
Affects Versions: 3.0.0.0
Environment: Windows 7, x64 with VS 2005, 2008, 2010 and 2012 installed
Reporter: Esteban Paredes Barbosa
Assignee: Jiri Cincura
Priority: Blocker
I am pretty sure that the new msi is not modifying the machine.config files from any .NET installed.
I have already reviewed 2.0, 3.5 and 4.0 for 32bits and none of them include the <configSections> nor <DbProviderFactories> changes.
In matter of fact, I would like to know what should be inserted in order to do it manually.
Thanks.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Esteban P. B. (JIRA) <tr...@fi...> - 2013-02-14 01:27:39
|
DDEX 3.0.0 msi intaller seems as not being modifying machine.config files
-------------------------------------------------------------------------
Key: DNET-485
URL: http://tracker.firebirdsql.org/browse/DNET-485
Project: .NET Data provider
Issue Type: Bug
Components: DDEX Provider
Affects Versions: 3.0.0.0
Environment: Windows 7, x64 with VS 2005, 2008, 2010 and 2012 installed
Reporter: Esteban Paredes Barbosa
Assignee: Jiri Cincura
Priority: Blocker
I am pretty sure that the new msi is not modifying the machine.config files from any .NET installed.
I have already reviewed 2.0, 3.5 and 4.0 for 32bits and none of them include the <configSections> nor <DbProviderFactories> changes.
In matter of fact, I would like to know what should be inserted in order to do it manually.
Thanks.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiri C. <di...@ci...> - 2013-02-13 16:22:07
|
On Wed, Feb 13, 2013 at 4:19 PM, Reinhard Gunacker <R.G...@bs...> wrote:
> The point is, that I selected only one single Table but it is slow anyhow!
Yes, the query is same. Only amount of data transfered is not that
huge. If you're on a fast line that will not make a difference.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Reinhard G. <R.G...@bs...> - 2013-02-13 15:20:17
|
The point is, that I selected only one single Table but it is slow anyhow!
On Wed, Feb 13, 2013 at 11:31 AM, Reinhard Gunacker <R.G...@bs...> wrote:
> Any Ideas how to speed up the creation of the Model?
With 650 tables it will be always slow. It's a huge query being generated and Firebird doesn't like that. Basically only option is to select only tables you're interested in.
--
Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
211 messages has been excluded from this view by a project administrator.
