Re: [Firebird-net-provider] RoleProvider index

2006-11-07 Thread Jiri Cincura
Le roy Arnaud wrote: > it could be a good idea but for exemple in the membership provider > delete function have a parameter ("deleteAllRelatedData") that define > if all related data of the users should be delete and if we put an fk > the related data will be always delete. :\ > An other pro

Re: [Firebird-net-provider] RoleProvider index

2006-11-07 Thread Le roy Arnaud
> OK, nice. Will you commit new sql script? Ok i will commit this changes tomorrow > BTW what about adding (optional) FK constraint to be able to delete users > from console without havving any stub in database. What do you think? it could be a good idea but for exemple in the membership provide

Re: [Firebird-net-provider] RoleProvider index

2006-11-07 Thread Jiri Cincura
Le roy Arnaud wrote: > Jiri Cincura a émis l'idée suivante : >> Just small note, what about adding PK into RoleProvider's table? With a lot >> of users/roles this can be a bottleneck without index. > > yes, in fact they must be an index on each provider's table OK, nice. Will you commit new sql

Re: [Firebird-net-provider] RoleProvider index (was: FbProfileProvider)

2006-11-07 Thread Le roy Arnaud
Jiri Cincura a émis l'idée suivante : > Just small note, what about adding PK into RoleProvider's table? With a lot > of users/roles this can be a bottleneck without index. yes, in fact they must be an index on each provider's table -

[Firebird-net-provider] RoleProvider index (was: FbProfileProvider)

2006-11-07 Thread Jiri Cincura
Just small note, what about adding PK into RoleProvider's table? With a lot of users/roles this can be a bottleneck without index. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomc

Re: [Firebird-net-provider] FbProfileProvider

2006-11-07 Thread Jiri Cincura
Le roy Arnaud wrote: > Le 07/11/2006, Jiri Cincura a supposé : >> Le roy Arnaud wrote: >>> I'm looking the profile script and the index is not set so don't forget >>> to add it. Me i add only one with a primary key on pkid. >> >> Where the index should be? >> >> I'll add it to the SQL script on CV

[Firebird-net-provider] Database Shutdown

2006-11-07 Thread paha
Hi, it's not actually a problem of FirebirdProvider, but i had a hope, that some experienced users could help me (please please) So, i make Database Shutdown/Online using FbConfiguration with "Forced" Paramater - i do it to update some metadata like Foreign Keys and avoid "object in use" message.

Re: [Firebird-net-provider] FbProfileProvider

2006-11-07 Thread Le roy Arnaud
Le 07/11/2006, Jiri Cincura a supposé : > Le roy Arnaud wrote: >> I'm looking the profile script and the index is not set so don't forget >> to add it. Me i add only one with a primary key on pkid. > > Where the index should be? > > I'll add it to the SQL script on CVS too. On the PKID column but

Re: [Firebird-net-provider] FbProfileProvider

2006-11-07 Thread Jiri Cincura
Le roy Arnaud wrote: > I'm looking the profile script and the index is not set so don't forget > to add it. Me i add only one with a primary key on pkid. Where the index should be? I'll add it to the SQL script on CVS too. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3rena

Re: [Firebird-net-provider] FbProfileProvider

2006-11-07 Thread Le roy Arnaud
Dans son message précédent, Jiri Cincura a écrit : > Le roy Arnaud wrote: >> Jiri Cincura a expos=E9 le 07/11/2006 : >>> Is the %subj% stable and ready to real usage? >>> >>> I'm thinking about using it in some ASP.NET apps. >> = > >> Hello, >> = > >> I use it in different web app (about 300 users

Re: [Firebird-net-provider] Documentation on FbException and FbError codes (V2.0.1)

2006-11-07 Thread Carlos Guzmán Álvarez
Hello: > I have a document "Firebird 1.5 Error Codes" that appears to match the > negative error numbers and also shows corresponding 'GDSCODE' numbers > such as 335544569. It isn't clear to me what the relationship is nor > whether the negative errors are definitely the most useful. The only t

Re: [Firebird-net-provider] Attempted to read or write protected memory. This is often an indication that other memory is corrupt

2006-11-07 Thread Carlos Guzmán Álvarez
Hello: > I have found which is the condition for get the error. I get this > error when a I put in the "where" clause a varchar value. > > SQL = "select CATE_ID from T_CATEGORIAS WHERE CATE_NOMBRE='@v_categoria'" > . > cmd.Parameters.Add("@v_categoria", FbDbType.VarChar).Value = "Cat1" >

Re: [Firebird-net-provider] FbProfileProvider

2006-11-07 Thread Jiri Cincura
Le roy Arnaud wrote: > Jiri Cincura a exposé le 07/11/2006 : >> Is the %subj% stable and ready to real usage? >> >> I'm thinking about using it in some ASP.NET apps. > > Hello, > > I use it in different web app (about 300 users) since three month and i > have no problem. > It works as the sqlPro

Re: [Firebird-net-provider] FbProfileProvider

2006-11-07 Thread Le roy Arnaud
Jiri Cincura a exposé le 07/11/2006 : > Is the %subj% stable and ready to real usage? > > I'm thinking about using it in some ASP.NET apps. Hello, I use it in different web app (about 300 users) since three month and i have no problem. It works as the sqlProfileProvider. -

[Firebird-net-provider] FbProfileProvider

2006-11-07 Thread Jiri Cincura
Is the %subj% stable and ready to real usage? I'm thinking about using it in some ASP.NET apps. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to supp