Re: [Firebird-net-provider] Firebird web provider

2008-06-20 Thread le roy arnaud
one from > table? in this case they is a problem in the sp because i think we get "multiple row in singleton select", so i look that but the most simple solution is to add first(1) into the select in MEMBERSHIP_GETUSERBYEMAIL > 5. Shouldn't be used FK for

Re: [Firebird-net-provider] web application sample

2008-06-17 Thread le roy arnaud
have only one ASP.NET project using membership etc. > stuff ant this is using the old one version of WebProviders (before > rewritten by Le Roy Arnaud). :( > >> I have configured Membership provider and role provider but I get always >> errors on execution! > > Look at

Re: [Firebird-net-provider] Problem with FbScript and execute procedure

2007-08-23 Thread le roy arnaud
i found the solution , i remove the suspend and the output parameter into my procedure and after that all is commited. ""le roy arnaud"" <[EMAIL PROTECTED]> a écrit dans le message de news: [EMAIL PROTECTED] > hi, > > i have a probleme with a script

[Firebird-net-provider] Problem with FbScript and execute procedure

2007-08-23 Thread le roy arnaud
hi, i have a probleme with a script that execute a procedure like this : CREATE PROCEDURE BO_DEL_TABLE RETURNS ( IDSUP INTEGER ) AS BEGIN FOR SELECT IDMYTABLE FROM MYTABLE INTO :IDSUP DO BEGIN DELETE FROM MYTABLE WHERE MYTABLE = :IDSUP; suspend; END END this is my s

Re: [Firebird-net-provider] Membership providers

2007-05-07 Thread le roy arnaud
> BTW do you think, that prefix should be each for every provider or same > for all ASP.NET web providers? > > I vote for same. > for the tables i think that the same prefix could be a good idea but for sp i think that there are already a prefix ex : MEMBERSHIP_CREATEUSER ROLES_ADDUSERTOROLE P

Re: [Firebird-net-provider] Membership providers

2007-05-04 Thread le roy arnaud
>> So I propose MP$SOMETHING > > Looks good, too. > Yes so for tables : MemberShip Proprider : MP$ Role Provider : RP$ Profile Provider : PP$ and the same for proc ? - This SF.net email is sponsored by DB2 Express Downl

Re: [Firebird-net-provider] Membership providers

2007-05-04 Thread le roy arnaud
Hi Jiri, first i think that we should do the script for the firebird 2.0 . > > I'm thinking about adding some prefix to SQL scripts for creating > tables, etc. for membershipshiping. > > Why to do this. >First there's some inconsistency in these scripts. Where > So this would help keep

Re: [Firebird-net-provider] Problem with Initialize in

2007-01-05 Thread Le roy Arnaud
It's strange because i have created a new website and i have copy paste your web.config and i have add the line in the assemblie section and it works fine for me with the same version that you seem use ! For the isonline field this bug is correct in the cvs tree! ps : have you try in vs to do M

Re: [Firebird-net-provider] Problem with Initialize in

2007-01-05 Thread Le roy Arnaud
Try to add this line in the assemblies section in your web.config : I think the problem here ! - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share y

Re: [Firebird-net-provider] Problem with Initialize in

2007-01-05 Thread Le roy Arnaud
Try to remove this : WriteExceptionsToEventLog="true" - 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 throug

Re: [Firebird-net-provider] Problem with Initialize in

2007-01-05 Thread Le roy Arnaud
Hi, I think that your web.config is not well configures ! Can you send it ? - 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 &

[Firebird-net-provider] Web Provider (script 1.5)

2006-11-30 Thread Le roy Arnaud
Hello, I propose to do some changes in structure of this providers : 1) MemberShip Provider - Add column UPPERUSERNAME AND UPPEREMAIL (also in fbmembership2) - Modify size of column applicationName, username to 252 for create index on it. 2) Role Provider - Add column UPPERUSERNAME in user

Re: [Firebird-net-provider] DeleteRole in RoleProvider

2006-11-30 Thread Le roy Arnaud
> > Damn, you're right. I'm using FB 2.0 for testing and some 1.5 issues are > going outside me. Maybe an other solution is to set the length of rolename to 252 because with this size we can create index in fb 1.5. PS : Jiri have you received the email with the new role provider ? --

Re: [Firebird-net-provider] Some change into The RoleProvider

2006-11-28 Thread Le roy Arnaud
Dans son message précédent, Jiri Cincura a écrit : > Carlos Guzm=E1n =C1lvarez wrote: >> Huuummm ... hope you mean for the scripts and not for the provider = > >> implementation ;) > > Generally yes. > > But maybe deriving RoleProvider C# code will not be wrong. ;) > With stored proc there are not

Re: [Firebird-net-provider] Some change into The RoleProvider

2006-11-28 Thread Le roy Arnaud
Carlos Guzmán Álvarez a exposé le 28/11/2006 : > Hello: >> Yes. You should. Making any hacks, we will not support. ;) >> >> What about create 1.5 clone of RoleProvider, with hash or select to users = > >> table or something else? And for 2.0 create index (on 4k page AFAIK it wi= > ll = > >> fit).

Re: [Firebird-net-provider] Some change into The RoleProvider

2006-11-28 Thread Le roy Arnaud
Le 28/11/2006, Jiri Cincura a supposé : > Le roy Arnaud wrote: >> I think is a good idea but have you an idea for naming the roleprovider >> ? > > RoleProvider15 > RoleProvider-15 > RoleProvider_15 > > Please vote. :) :) But i have an other idea : is to put

Re: [Firebird-net-provider] Some change into The RoleProvider

2006-11-28 Thread Le roy Arnaud
> What about create 1.5 clone of RoleProvider, with hash or select to users > table or something else? And for 2.0 create index (on 4k page AFAIK it will > fit). I think is a good idea but have you an idea for naming the roleprovider ?

Re: [Firebird-net-provider] Some change into The RoleProvider

2006-11-28 Thread Le roy Arnaud
> > So you say, that if I use AspNetMembershipProvider I have to use > AspNetRoleProvider? Weird. > no i want said if you use roleprovider you have to use memebership provider :) (sorry fo my english). - Take Surveys. Ear

Re: [Firebird-net-provider] Some change into The RoleProvider

2006-11-28 Thread Le roy Arnaud
Jiri Cincura a formulé la demande : > Le roy Arnaud wrote: >> Yes but it's more quickly to do a select on index (PKID in users table) >> than a full scan on usersinroles > > I think that presume users table isn't good. > > What about create column with

Re: [Firebird-net-provider] DeleteRole in RoleProvider

2006-11-28 Thread Le roy Arnaud
Dans son message précédent, Jiri Cincura a écrit : > Le roy Arnaud wrote: >> Yes is a good idea, if you want i add this into the script ? > > OK. > > Note: Don't forget to remove second command from DeleteRole from code. An other problem it's not possible to

Re: [Firebird-net-provider] IsUserInRole method in RoleProvider

2006-11-28 Thread Le roy Arnaud
Jiri Cincura a émis l'idée suivante : > Le roy Arnaud wrote: >> OK jiri i will fix that with the others changes > > Nice! The keyword exists can be used only in SP SO i propose to use : select 1 from usersinroles WHERE UPPER(USERNAME) = ? AND APPLICATIONNAME = ? What do

Re: [Firebird-net-provider] Some change into The RoleProvider

2006-11-28 Thread Le roy Arnaud
Jiri Cincura a pensé très fort : > Jiri Cincura wrote: >> Le roy Arnaud wrote: >>> What do you think about that ? >> >> IMHO it's ok. >> > > Humm, maybe not. If you add PKID like in membership, how do you will get it? > You will have to create se

Re: [Firebird-net-provider] DeleteRole in RoleProvider

2006-11-28 Thread Le roy Arnaud
Le 28/11/2006, Jiri Cincura a supposé : > Hi, > > in DeleteRole we're deleting roles from classic two tables (roles and > userinroles). But what about creating FK for roles <> userinroles with > cascade? > > This will help with 1) DB integrity when somebody edits it by hand and 2) > save one cal

Re: [Firebird-net-provider] IsUserInRole method in RoleProvider

2006-11-28 Thread Le roy Arnaud
Jiri Cincura a exposé le 28/11/2006 : > Hi, > > in this method is SELECT COUNT(*), which isn't good. You should better use > exists. > > The count have to go through all table and count, but exists predicate will > stop when the first match is found - and it's much faster. > > Will you fix this L

[Firebird-net-provider] Some change into The RoleProvider

2006-11-27 Thread Le roy Arnaud
Hello, There is a problem with the role provider : first because with the currently table role and usersinrole we can't add any index because the column are varchar 255 and firebird 1.5 don't support index on this kind of column. So i think the solution is to modify the table usersinroles : 1

Re: [Firebird-net-provider] Upgrading webproviders to use UTF8

2006-11-17 Thread le roy arnaud
>> 2. Tune up 1.5 scripts as best as possible with this engine. Ok but it's not so simple because the 1.5 engine don't support index on column that has a size > 252 so it's dificult to tune the script. So all search on column username, email are not indexed so on big database the search can b

Re: [Firebird-net-provider] Upgrading webproviders to use UTF8

2006-11-16 Thread Le roy Arnaud
Jiri Cincura vient de nous annoncer : > Le roy Arnaud wrote: >> I don't know because if you do that the scripts don't work in Fb1.5 ? >> Maybe create all scripts with a new extension 2.0 ? > > I think, BTW, the current version of FbSessionStateStore will not work on

Re: [Firebird-net-provider] Upgrading webproviders to use UTF8

2006-11-16 Thread Le roy Arnaud
Jiri Cincura avait écrit le 15/11/2006 : > Hi, > > I have here pending commit on %subj%. I think there's no reason to use > UNICODE_FSS for text columns. The UTF8 is new in FB2 and I think we can use > it without problems. > > Any commnets? Can I do a commit? I don't know because if you do that

Re: [Firebird-net-provider] RoleProvider

2006-11-08 Thread Le roy Arnaud
Steve Ramacher a utilisé son clavier pour écrire : >> Nothing I want said fbmembership provider.cs. i have correct some bug : >> 1) when you create an user IsOnline is not set so a exception is raised > >> because the domain's bool is NOT NULL. > Hello in the cvs i have put your changes but i have

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Le roy Arnaud
> Well, with 8k page size, the table roles is OK... But I think the 4k page > size we should handle as base. But changing the implementation isn't good. > Maybe we should way, if somebody will report this as a problem and then make > final decision. OK? > Ok. > What's wrong with membership pro

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Le roy Arnaud
>> yes, in fact they must be an index on each provider's table > > OK, nice. Will you commit new sql script? > I have look to add primary key on each table but there is a problem with the role and usersrole tables because this table have not column that accept primary key because their size is to

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Le roy Arnaud
Jiri Cincura a couché sur son écran : > 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

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 (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 -

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

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. >> = > >> H

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. -

Re: [Firebird-net-provider] Little problem with stored proc

2006-11-06 Thread Le roy Arnaud
> > Did you close the reader after reading? Thanks jiri the problem was here ! - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your j

[Firebird-net-provider] Little problem with stored proc

2006-11-06 Thread Le roy Arnaud
Hello, I have a sp that do an insert and after that a for select. Ex: CREATE PROCEDURE GET_PLAGES (IDPLAGE INTEGER) RETURNS ( IDPLAGE INTEGER, DEBUT INTEGER, FIN INTEGER, SHORTDESCIPTION VARCHAR(2000)) AS begin insert into plage(debut, fin, shortdesciption) values (:debut, :fin

Re: [Firebird-net-provider] Problem with ddex and tableadapter

2006-10-30 Thread Le roy Arnaud
> In the data type of the IS_NULLABLE column returned in the GetSchema = > > calls ... > Oh not easy to find it ! - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-i

Re: [Firebird-net-provider] Problem with ddex and tableadapter

2006-10-30 Thread Le roy Arnaud
Carlos Guzmán Álvarez avait soumis l'idée : > Hello: >> I have a problem with the tableadapter and the ddex provider i will try t= > o = > >> explain you with an exemple : > I think i have this fixed in my local tree > Yes it works fine now where was the problem ? thanks a lot ! --

Re: [Firebird-net-provider] Problem with ddex and tableadapter

2006-10-30 Thread Le roy Arnaud
> I think i have this fixed in my local tree > I can do some tests if you want ? where i can found the new source ? - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre

Re: [Firebird-net-provider] Problem with ddex and tableadapter

2006-10-29 Thread le roy arnaud
Else i have found a ddex for sqlite database and it is very simple. in this one this problem is'nt present so maybe can help you ? you can find it at http://sourceforge.net/projects/sqlite-dotnet2 - Using Tomcat but need

Re: [Firebird-net-provider] Problem with ddex and tableadapter

2006-10-29 Thread le roy arnaud
> I'm thinking if it could be a matter of data type mapping ... i'm = > > thinking on try to implement a concept mapper ... and give it a try ... > what is a concept mapper ? And you think that the problem is in the ddex provider or in the ado .net provider ?

Re: [Firebird-net-provider] Problem with ddex and tableadapter

2006-10-29 Thread le roy arnaud
> AllowDbNull looks correct to me at least in the properties window. > Yes in the property window this propertie is good but not in the genrated code so VS seems to take the information elsewhere but where i don't know :(

Re: [Firebird-net-provider] Problem with ddex and tableadapter

2006-10-29 Thread le roy arnaud
> It could be i have done some changes some days that should help on that = > > ( While it's not possible to know what is being done by the VS to = > > generate the commands ... and what information is being used for that = > > ... :P ) > What version of the provider ( DDEX and ADO.NET ones )are

Re: [Firebird-net-provider] Problem with ddex and tableadapter

2006-10-29 Thread le roy arnaud
> > IMHO it's because FAC_SELECTION doesn't have default value, so VS is not > able to be 100% sure whether the insert will be OK (i.e. generator in > trigger can "fix" this, but VS doesn't know this). > thanks jiro for the rapidity, but i will try with this : CREATE TABLE ACH_FAM ( FAC_CODE

[Firebird-net-provider] Problem with ddex and tableadapter

2006-10-29 Thread le roy arnaud
Hello, I have a problem with the tableadapter and the ddex provider i will try to explain you with an exemple : I have this table : CREATE TABLE ACH_FAM ( FAC_CODE SMALLINT NOT NULL, FAC_NOMVARCHAR(30), FAC_SELECTION SMALLINT ); when i create a tableadpter with this

Re: [Firebird-net-provider] Some problems with ddex and tableadapter

2006-10-27 Thread le roy arnaud
> yes and more over i have the same problem with sql server for exemple > try to create a tableadapter on an asp net sql server 2005 database > with this request : > > ex : > > "SELECT ApplicationName, ApplicationId FROM dbo.aspnet_Applications" > Only the insert statement is not defined but if i

Re: [Firebird-net-provider] Some problems with ddex and tableadapter

2006-10-27 Thread Le roy Arnaud
> > He said, that *only* insert statement is not defined. So it's really weird. yes and more over i have the same problem with sql server for exemple try to create a tableadapter on an asp net sql server 2005 database with this request : ex : "SELECT ApplicationName, ApplicationId FROM dbo.as

Re: [Firebird-net-provider] Some problems with ddex and tableadapter

2006-10-27 Thread Le roy Arnaud
>I've tested this and I've no problem with this (tested with FB and MS SQL). >All statements were created. IMHO this is handled internaly by VS. it's very strange, it doesn't work for me for the insert statment it is not generated ! How i can update the ddex provider and how reinstall it ? >

[Firebird-net-provider] Some problems with ddex and tableadapter

2006-10-27 Thread Le roy Arnaud
Hello, I have found some problems with the ddex and tableadapter : 1) when you create a table adapter with a request like : "select * from MYTABLE". The select,update,delete,insert command are created but if the request like "select idmytable,c1,c2 from MYTABLE" only select,update,delete comm

Re: [Firebird-net-provider] Why FbErrorCollection needs to be

2006-10-20 Thread Le roy Arnaud
> > OK, so I think, this is the good candidate for using generics. We'll kill = > > the (un)boxing in the code like in get { return (FbError)this.errors[index]= > ; }. > What do you think? > I think to use generics it's a very good idea for increase the performance -

[Firebird-net-provider] Export and import data

2006-10-16 Thread Le roy Arnaud
Hello, i search a solution to export and import data in firebird database. I know the fbexport tools but is what the fb provider implement it or implements an other thing ? Maybe Someone have use the fbexport tool with the fbprovider. Thanks -

Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Le roy Arnaud
> As a solution we can provide a script with the full database, and separate > scripts for each provider( without create database statement ) > I think is a good solution. - Using Tomcat but need to do more? Need to support

Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Le roy Arnaud
> Why all together? When user would create only tables and procedures for > RoleProvider, he will just run RoleProvider.sql (for example). > > If everything will be in one file, he will have to comment some parts and > it'S not good, IMHO. because there are some dependance between the diferent p

Re: [Firebird-net-provider] SQL scripts for ASP.NET stuff

2006-10-13 Thread Le roy Arnaud
I think that should be better to make a simple file that create all the tables and all stored proc ! - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated tec

Re: [Firebird-net-provider] Membership Provider

2006-10-13 Thread Le roy Arnaud
> I have finally had time to dig in and figure out what is going on with > the membership provider. There is nothing wrong with the provider, and > it seems to be in the database scripts. I found that when the > MEMBERSHIP_CREATEUSER sp was being called, it was accepting the > parameters for PASSWO

Re: [Firebird-net-provider] Membership Provider

2006-10-12 Thread Le roy Arnaud
> I used the ASP.NET configuration manager to create a user, and it > succeeds. I am including user id, password, email address, and question > and answer. I now edit the user, and membership can't find an email > address for the user. I enter a new email address and this time put a > description i

Re: [Firebird-net-provider] Membership Provider

2006-10-12 Thread Le roy Arnaud
> I hope the tone of my comments don't come off negatively, as I am not > trying to attack you or the product. I am just trying to understand how > this all fits together :) . oh sorry i don't think that you atack me or the project, your comment are very positive for the project. > I used the A

Re: [Firebird-net-provider] Membership provider

2006-10-11 Thread Le roy Arnaud
> 2. I have not been able to get the membership provider 2 to work (the version > that uses stored proc's), but honestly I haven not tried very hard yet. What is the problem ? > 3. Have not been able to wire up web parts to the profile provide, kind of > got frustrated with this one and gave u

[Firebird-net-provider] New FbMembership Provider

2006-10-03 Thread Le roy Arnaud
Hello, i have just add the new version of the fbmembership provider. This new version is currently in beta. It uses stored procedures and i have correct some bug like case sensitive on email and username. I have also add this functionality "PasswordStrengthRegularExpression". The new provider

Re: [Firebird-net-provider] Refund the membershipProvider

2006-09-25 Thread Le roy Arnaud
> Any advantages using SPs? etc. the advantage of using sp here is for exemple the bug with case sensitive could solve without any changes in fbmembership provider. just apply a sql script on database to corect the problem. I think that it is easier to do that rather than to add a new version o

[Firebird-net-provider] Refund the membershipProvider

2006-09-25 Thread Le roy Arnaud
Hello, i want to remelt the fbmembership Provider because they have some problem. i would like do all request to the database by stored proc. Is what somebody sees objections to do that ? If you have any sugestions ? -

Re: [Firebird-net-provider] Web.config for firebird

2006-09-25 Thread Le roy Arnaud
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 --

[Firebird-net-provider] Probleme case sensitive with asp.net provider

2006-09-25 Thread Le roy Arnaud
Hello, there are a problem with the case sensitive because when you do : select * from users where username = 'toto' and select * from users where username = 'TOTO' the result is diferent because the column username is case sensitive so you can insert user TOTO and toto but it's not possible b

Re: [Firebird-net-provider] Execute script

2006-09-19 Thread Le roy Arnaud
Le roy Arnaud a écrit : > Hello, > > How i can simply execute the script that is in attachment. > I try with fbscipt and FbBatchExecution but it doesn't work ! Ok i found the solution SET TREM ^ ; - Take S

[Firebird-net-provider] Execute script

2006-09-19 Thread Le roy Arnaud
Hello, How i can simply execute the script that is in attachment. I try with fbscipt and FbBatchExecution but it doesn't work ! mis.sql Description: Binary data - Take Surveys. Earn Cash. Influence the Future of IT Join Sou

Re: [Firebird-net-provider] Script for memebership

2006-09-12 Thread Le roy Arnaud
> > Scripts should be also in installation (I've already worked on this with > Carlos). Sorry i didn't know - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integ

Re: [Firebird-net-provider] Script for memebership

2006-09-12 Thread Le roy Arnaud
> There are any script in order to create the necesary tables on a FB database > to use membership provider? > Yes, in the source of the firebird data provider - Using Tomcat but need to do more? Need to support web servic

Re: [Firebird-net-provider] Web.config for firebird

2006-08-22 Thread Le roy Arnaud
hello, try this name="FirebirdMembershipProvider" type="FirebirdSql.Web.Providers.FbMembershipProvider" - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated

Re: [Firebird-net-provider] Web.config for firebird MembershipProvider

2006-08-22 Thread Le roy Arnaud
hello, have you add the firebird provider in your project reference ? - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier

Re: [Firebird-net-provider] post_event in stored proc

2006-07-28 Thread Le roy Arnaud
thanks it's work fine - 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

Re: [Firebird-net-provider] CreateUser in membership

2006-07-28 Thread Le roy Arnaud
> I aslo suggest to perform some code clean up from unneccessary code and add > default values to sql scripts. ok i can begin to add default value into sql script in two weeks. else for exemple where do you think that the code would be clean up ! --

[Firebird-net-provider] post_event in stored proc

2006-07-28 Thread Le roy Arnaud
Hello , a little question how i cant catch post_event with fbprovider, i think it's with fbremoteevent but i'm not sure anybody can confirm ? thanks ! - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge

Re: [Firebird-net-provider] CreateUser in membership

2006-07-28 Thread Le roy Arnaud
hello > Another solutin will be add some default values to table definition, but in > code it should be better, right? i think is better in the table definition - Take Surveys. Earn Cash. Influence the Future of IT Join S

Re: [Firebird-net-provider] FbMembershipProvider problem

2006-07-27 Thread Le roy Arnaud
Sarel a pensé très fort : indeed it's not possible to use the fbmembership provider in a windows forms application because .net try to load the fbmembership provider to the system.web assembly so it can't find it !! so it's normal that the sqlmembership provider work because it is in the system.

Re: [Firebird-net-provider] Executing Stored Procedures,

2006-07-20 Thread Le roy Arnaud
hello try to this : cmd.CommandType = CommandType.StoredProcedure; - 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

Re: [Firebird-net-provider] A few questions from a newbie to .NET.

2006-07-10 Thread Le roy Arnaud
> > 1) Is there any control like SqlDataSource, that allows me to connect to > FB .NET provider in the designer? > i think that the sqldatasource componment work with fb . net provider because this componement is not reserved for sql server --

Re: [Firebird-net-provider] Question about connection pool

2006-07-04 Thread Le roy Arnaud
> Question: > > Is provider checking if the same connection string is used and not opening > new connection, uses the already opened one? > > > > Or provider closes connection after rows where fetched? > it depends how you use the connection. for exemple, if you use it in dbcommand and you call

Re: [Firebird-net-provider] Problem when imbricate two fbconnection

2006-07-03 Thread Le roy Arnaud
> Hello: >> i think there is a problem when imbicate two connections because after >> close each of them there is still two open. >> an exemple of code : >> = > > > Huummm what are your connection pooling settings ?? > hello, finally after a good night i think it's normal because pooling is act

[Firebird-net-provider] Problem when imbricate two fbconnection

2006-07-03 Thread Le roy Arnaud
Hello, i think there is a problem when imbicate two connections because after close each of them there is still two open. an exemple of code : [code] private void dotask() { IDataReader a; FbConnection fbconnect = new FbConnection(connect); fbconnect.Open(); FbCommand fbc1 = new FbCommand("se

Re: [Firebird-net-provider] Using the 2.0 Provider on Mono

2006-06-30 Thread Le roy Arnaud
Fabio Gomes vient de nous annoncer : > Nice, but i forgot to say that i ll be using linux, will i have to compile > the provider on linux? > normally you don't have to compile it on linux ! Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-

Re: [Firebird-net-provider] Using the 2.0 Provider on Mono

2006-06-30 Thread Le roy Arnaud
> I m thinking about starting to play with mono, and i would like to know if i > can use the 2.0 provider on mono. > > Thanx. normally yes ! Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier D

Re: [Firebird-net-provider] Fyracle and CLRExternalEngine.dll

2006-06-30 Thread Le roy Arnaud
Hello, > I haven't forgot this ;) hope to give a little review as soon as possible > > You are using .net 2.0 and the v2.0 of the provider right ?? > Yes i use .net 2.0 and fbprovider v2.0 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre

Re: [Firebird-net-provider] Little problem in fbmembershipprovider

2006-06-29 Thread Le roy Arnaud
Il se trouve que Carlos Guzmán Álvarez a formulé : > Hello: >> Yes, the GetAllUsers method in latest CVS is ok. > Nice i have changed all methods where i found a call to Cancel .. doing = > > the change in > all methods in the same way, so hope other affected methods are correct = I do some test a

Re: [Firebird-net-provider] Little problem in fbmembershipprovider

2006-06-28 Thread Le roy Arnaud
> Would that be something like this ?? > > command.CommandText =3D "SELECT FIRST (@first) SKIP (@skip) PKID, = > > Username, Email, PasswordQuestion," + > " Comment, IsApproved, IsLockedOut, CreationDate, LastLoginDate," + > " LastActivityDate, LastPasswordChangedDate, LastLockedOutDate " +

Re: [Firebird-net-provider] Little problem in fbmembershipprovider

2006-06-28 Thread Le roy Arnaud
> Maybe the best solution will be to add into query first x skip y. So we > haven't to hack this with break and we also haven't use cancel method. > > What do you think? For the FbProfile Provider i do this and it's work fine ! I think it's a good solution Using Tomcat but need to do more? Nee

Re: [Firebird-net-provider] Little problem in fbmembershipprovider

2006-06-27 Thread Le roy Arnaud
Jiri Cincura a utilisé son clavier pour écrire : > I think, that better will be to implement Cancel method. i think also :) Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSph

[Firebird-net-provider] Little problem in fbmembershipprovider

2006-06-27 Thread Le roy Arnaud
hello, There is a problem in the function that implement pagination like : FindUsersByEmail;GetAllUsers;FindUsersByName; the problem is these functions call Command.Cancel but this is not implemented so to fix this i replace in these functions Command.Cancel() by break; Using Tomcat but need

Re: [Firebird-net-provider] Problem with stored proc and blob

2006-06-22 Thread Le roy Arnaud
> I have an error : > arithmetic exception, numeric overflow, or string truncation > > because buf is empty but not null ! > > It is normal ? > Sorry it's nothing , it's me :) All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number o

Re: [Firebird-net-provider] Problem with stored proc and blob

2006-06-22 Thread Le roy Arnaud
> Is the SP parametr sub_type text? Ok it was the problem thanks ! An other little question in the sp one paremeter is BLOB SUB_TYPE 0 SEGMENT SIZE 80. and when i add a parameter : cmd.Parameters.Add("@PropertyValuesBinary", FbDbType.Binary,buf.Length).Value = buf I have an error : arithmeti

[Firebird-net-provider] Problem with stored proc and blob parameter

2006-06-21 Thread Le roy Arnaud
hello in this exemple i have this error message "error to convert string to byte[]" conn = new FbConnection(_fbConnectionString); FbCommand cmd = new FbCommand("PROFILES_SETPROPERTIES", conn); conn.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(CreateInputParam("@Applic

Re: [Firebird-net-provider] Problem on dispose implementaion

2006-06-13 Thread Le roy Arnaud
Carlos Guzmán Álvarez avait prétendu : > Hello: >> Hello, >> >> i found a little error in the dispose implementation. >> 1 . why you close active reader when you dispose the fbcommand ? >> >> because with the microsoft application block you can do it : >> >> Database db =3D Helper.GetDB(); >>

[Firebird-net-provider] Problem on dispose implementaion in fbcommand

2006-06-13 Thread Le roy Arnaud
Hello, i found a little error in the dispose implementation. 1 . why you close active reader when you dispose the fbcommand ? because with the microsoft application block you can do it : Database db = Helper.GetDB(); using (DbCommand dbCommand = db.GetSqlStringCommand("SELECT * FROM TOTO")) {

[Firebird-net-provider] Little bug in FbMemberShipProvider.cs

2006-06-12 Thread Le roy Arnaud
Hello, there is a litle bug in the getallusers function. In fact in the first fbcommand : FbCommand command = new FbCommand("SELECT Count(*) FROM " + this.tableName + "WHERE ApplicationName = @ApplicationName", connection); it misses a space in "WHERE ApplicationName = @ApplicationName"

Re: [Firebird-net-provider] Fyracle and CLRExternalEngine.dll

2006-06-12 Thread Le roy Arnaud
> Have you tried to restart the server before setting the breakpoint ?? it = > > may sound weird but i was on thi to do that several times while debugging. > Yes, i tried to restart but it didn't work :( ___ Firebird-net-provider mailing list Firebir

Re: [Firebird-net-provider] Fyracle and CLRExternalEngine.dll

2006-06-09 Thread Le roy Arnaud
Carlos Guzmán Álvarez a exprimé avec précision : > Hello: >> but it doesn't work ! >> >> else how can i debug ? > You will need Visual C++ installed, and the CLRExternalEngine sources. > > Open the CLRExternalEngine solution and Attach the debugger to the = > > fbserver.exe process ( for native an

Re: [Firebird-net-provider] Fyracle and CLRExternalEngine.dll

2006-06-08 Thread Le roy Arnaud
> I have done a test using fyracle-0.8.9 and looks as working for me ( in = > > a first look of course ), > if you can do a debug it will be really helpful. > > Where do you have located the provider assembly ?? Hello, if the provider assembly is "FirebirdSql.Data.FirebirdClient.dll" is referen

Re: [Firebird-net-provider] Fyracle and CLRExternalEngine.dll

2006-06-06 Thread Le roy Arnaud
hello, i get the error message : "Error on method execution" when i launch the stored proc sub_tot_budget but she is compiled and commmited. the code of the assembly is : [CODE] using System; using System.IO; using System.Collections.Generic; using System.Text; using FirebirdSql.Data.FirebirdCli

  1   2   >