Re: [Firebird-net-provider] Membership Provider 2.1.0.0 - Error

//www.mono-project.com/Transactions list the ideas that the mono project have had on the subject. I might be compelled to contribute this feature but I'm more in doubt now... Anyway, I see your point. On Feb 8, 2008 12:51 PM, Jiri Cincura <[EMAIL PROTECTED]> wrote: > On 2/8/08, Jo

Re: [Firebird-net-provider] Membership Provider 2.1.0.0 - Error

wrote: > On 2/8/08, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: > > We've discussed it before and I said I would do some work with DTC > support > > but I never got around to do it. I hope I will get time soon as it's a > real > > time saver! We have so many

Re: [Firebird-net-provider] Membership Provider 2.1.0.0 - Error

. Take care :) On Feb 8, 2008 12:12 PM, Jiri Cincura <[EMAIL PROTECTED]> wrote: > On 2/8/08, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: > > Looking forward to the 2.5 release - a quick question: Does it support > DTC > > e.g. transactions spanning multiple Fir

Re: [Firebird-net-provider] Membership Provider 2.1.0.0 - Error

. transactions spanning multiple Firebird databases? Cheers, Jon On Feb 8, 2008 11:53 AM, Jiri Cincura <[EMAIL PROTECTED]> wrote: > On 2/8/08, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: > > You're right. But can you tell me why the official Firebird page >

Re: [Firebird-net-provider] Membership Provider 2.1.0.0 - Error

AIL PROTECTED]> wrote: > On 2/8/08, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: > > But the bug is also in the source version! Is there any reason why you > (or > > someone else) can't commit this fix? I can send you the bug fix or > assist > > you if you&#

Re: [Firebird-net-provider] Membership Provider 2.1.0.0 - Error

But the bug is also in the source version! Is there any reason why you (or someone else) can't commit this fix? I can send you the bug fix or assist you if you're not sure where the bug is. Regards, Jon. On Feb 7, 2008 9:34 AM, Jiri Cincura <[EMAIL PROTECTED]> wrote: > On 2/7/08, zakharov <[EMAI

Re: [Firebird-net-provider] Membership Provider 2.1.0.0 - Error

I just got bitten by this bug again. I would really appreciate a new build on sourceforge. Who do we have to contact? It's such a small bug but it's a real show stopper for most people using firebird! Regards, Jon. On Sep 12, 2007 4:22 AM, Trevor Watters <[EMAIL PROTECTED]> wrote: > In the absens

Re: [Firebird-net-provider] Bug? Timeout at CheckMaxPoolSize 2.x

I've a similar problem but increasing the max pool size helped. Not sure why or if is the right thing to do.. Here is some further reading: http://blogs.msdn.com/angelsb/archive/2004/09/20/231963.aspx On 6/3/06, JCardinal <[EMAIL PROTECTED]> wrote: > > Will try that and report back, thank you. > >

Re: [Firebird-net-provider] Async in connection string

Got it - thanks On 5/31/07, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello: > In SQL Server there is an attribute called Async in the connection > string, that instructs ADO.NET to perform asynchronous > request. Is there something similar in the Firebird .NET provider

[Firebird-net-provider] Async in connection string

Hi all! In SQL Server there is an attribute called Async in the connection string, that instructs ADO.NET to perform asynchronous request. Is there something similar in the Firebird .NET provider? Regards, Jon. - This SF.net

Re: [Firebird-net-provider] Enlisting transaction

I have the exact same problem. Please post whatever findings you two make! Regards, Jon. On 5/18/07, Jiri Cincura <[EMAIL PROTECTED]> wrote: Carlos Guzmán Álvarez wrote: > Hello: > >> But on FB it inserts record no matter that no call of Complete method >> was done. Did I miss something? > > O

[Firebird-net-provider] TransactionScope

Hi! I think we touch upon this before but completely abandon TransActionScope can some of your guys take a look at this question I've posted on MSDN? http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1608250&SiteID=1 I o

Re: [Firebird-net-provider] ExecuteNonQuery always return -1

ds.com/Articles/getArticle.aspx?articleID=78) claims that it's possible to get rows affected with stored procedures. On 5/16/07, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: Hi all! ExecuteNonQuery always return -1 when I use stored procedures. Is that a b

[Firebird-net-provider] ExecuteNonQuery always return -1

Hi all! ExecuteNonQuery always return -1 when I use stored procedures. Is that a bug? Regards, Jon. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of

Re: [Firebird-net-provider] SQL syntax for inserting data into stored procedure

I didn't set the Direction parameter to input.. Maybe the exception could be a bit clearer about that? On 5/14/07, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: I did what you posted and it works on some sprocs but not all... sometimes I get a Dynamic SQL Error parameter mismatch fo

Re: [Firebird-net-provider] SQL syntax for inserting data into

Not sure how this works, but if I set the Charset to NONE with a db with Charset NONE I can insert/extract none ASCII characters. Possible the provider translate all the characters. On 5/13/07, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: Probably yes, but I have to talk to the DBA

Re: [Firebird-net-provider] SQL syntax for inserting data into stored procedure

I did what you posted and it works on some sprocs but not all... sometimes I get a Dynamic SQL Error parameter mismatch for procedure BE_LOCATION_INFO_INSERT. I'll look more into this tomorrow with the DBA and post some more info. On 5/13/07, Jiri Cincura <[EMAIL PROTECTED]> wrote: Yes, you're

Re: [Firebird-net-provider] SQL syntax for inserting data into

Some extra info: I use ASP.NET 2.0 on the server and my globalization configuration is set to UTF-8 in requestEncoding, responseEncoding and fileEncoding. The FireBird Data Provider is version 2.1.0.0 - This SF.net email is sp

Re: [Firebird-net-provider] SQL syntax for inserting data into

Probably yes, but I have to talk to the DBA. Also another problem was that the data sent from the web server was in UTF-8 and the db wasn't. We changed that by using IBExpert to copy everything to a new UNICODE_FSS database and the connection string I changed to have Charset=UNICODE_FSS;.But now I

Re: [Firebird-net-provider] SQL syntax for inserting data into stored procedure

ra <[EMAIL PROTECTED]> wrote: Jon Ege Ronnenberg wrote: > The question is what is the right syntax and do I need to set anything > else on Command object? The first is right. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | htt

[Firebird-net-provider] SQL syntax for inserting data into stored procedure

Hi all. I'm trying to insert some data into a stored procedure. It doesn't work. Either I'm doing it wrong or the stored procedure doesn't work (I didn't write it). My DAL is pretty generic but my code is kinda like this: Command.CommandText = "BE_BOOKING_INSERT(@EventID, @BookingID, @UserID, @Da

Re: [Firebird-net-provider] TransactionScope support

be implemented? I would like to help but I don't want to fork the project :-) On 3/14/07, Jiri Cincura <[EMAIL PROTECTED]> wrote: Jon Ege Ronnenberg wrote: > servers. Can anyone please tell me if the firebird provider (v. 2.0.1.0 > <http://2.0.1.0>) support IPromotableSin

[Firebird-net-provider] TransactionScope support

Hi all! I'm using TransactionScope and having trouble getting it to work with the firebird provider (v. 2.0.1.0). I saw in one of the forum postings that I have to set Enlist=true in my connection string but no rollback happends when the transaction goes to DTC (Distributed Transaction Coordinato

Re: [Firebird-net-provider] Quick question

Thanks for the replies! Sorry Scott - I was a bit inpatient there. I have a generic data access layer that does everything on the Db[something] classes it then uses the DbProviderFactories to load the specific provider (in this case Firebird). In some queries (like update, insert and delete) I ca

Re: [Firebird-net-provider] Quick question

Thanks for all the responses... :-( On 3/12/07, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: Hi all! Does anyone know what triggers this 'Dispose' is not implemented exception that I get. Here is the URI: http://00367586.aspnethosting.dk/EventsGrid.aspx?UserID=1 It do

[Firebird-net-provider] Quick question

Hi all! Does anyone know what triggers this 'Dispose' is not implemented exception that I get. Here is the URI: http://00367586.aspnethosting.dk/EventsGrid.aspx?UserID=1 It doesn't show on my dev machine, so what can it be? If you need more info just write and I'll reply as soon as I see the mail

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

Weird! Maybe it's because I have included the FirebirdSql..Web.Providers project?? I don't know. I've noticed when you include and delete dlls in your webproject .NET 2.0 behaves strange because of all the partial code it generates. Everything is apparently not in the ASP.NET temp folder. Someon

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

Fixed the open db issue On 1/5/07, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: Hmm.. I've tried to change the BOOL domain in Firebird through IBExpert with this SQL: CREATE DOMAIN BOOL AS SMALLINT CHECK (value=1 or value=0 or value is null); but it te

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

etc. right? On 1/5/07, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: No, that didn't help. I've made a workaround by deriving from FbMembershipProvider and force the initialize with hardcoded values because I don't know how to read from the Membership section in web.config.

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

No, that didn't help. I've made a workaround by deriving from FbMembershipProvider and force the initialize with hardcoded values because I don't know how to read from the Membership section in web.config. Here is the code: public class PrimeMembership : FbMembershipProvider { public void Force

Re: [Firebird-net-provider] Error in FirebirdMemberShipProvider.sql

Thanks for clearing that up. On 12/20/06, Steve Ramacher <[EMAIL PROTECTED]> wrote: The FirebirdMembershipProvider is clean, look at the script and stored procedures and you will find all the answers. The Field is CHAR(16) OCTETS which is not just 16 characters wide, but 128. If you are writing

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

Maybe there's something I have overlooked in my web.config so here is all the content of the file. I hope this can help any of you help me ;-) http://schemas.microsoft.com/.NetConfiguration/v2.0";>

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

But how can I see the exception messages then? Anyway I tried and connectionectionString in public override bool ValidateUser(string username, string password) is still null. So still no cigar.. On 1/5/07, Le roy Arnaud <[EMAIL PROTECTED]> wrote: Try to remove this : WriteExceptionsToEventLog=

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

Yeah sure: http://schemas.microsoft.com/.NetConfiguration/v2.0";> Thanks for checking the above out! -

[Firebird-net-provider] Problem with Initialize in FbMemberShipProvider.cs

Hi all! I have an issue with the membership provider that ships with Data Provider for .NET Framework 2.0. I have finally tracked it down to be that Initialize() in FbMemberShipProvider.cs is never called and I get a C

[Firebird-net-provider] Error in FirebirdMemberShipProvider.sql

In FirebirdMemberShipProvider.sql the PKID is set to only CHAR(16). There is no way I can fit in a GUID there.. It should be CHAR(36) Cheers, Jon. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's T

[Firebird-net-provider] Dispose not implemented in FirebirdClient.FbTransaction

Hi guys!I keep getting this Dispose not implemented exception on my ISPs webserver running ASP.NET Version:2.0.50215.44 . The exact error look like this:Method 'Dispose' in type 'FirebirdSql.Data.FirebirdClient.FbTransaction' from assembly 'FirebirdSql.Data.FirebirdClient, Version=2.0.1.0, Culture=

Re: [Firebird-net-provider] Batch Select with Firebird provider

Your are dead on Dean. My setup is a hosted webserver and a inhouse database so fewer roundtrips to the db would significant increase performance. That being said, I see a lot of ideas here that I'm not sure is worth implementing. Ahh I just took a second look of my example and it doesn't show what

Re: [Firebird-net-provider] FbCommand and 'using' statement (was: Next release v2.1.0)

Hi Jiri.I've tried to do it that way sometime in spring and I got an exception everytime, after some time I found that the using keyword was not supported - I think in this forum. But hey - I'm glad it works now. On 11/1/06, Jiri Cincura <[EMAIL PROTECTED]> wrote: Jon Ege Ronn

Re: [Firebird-net-provider] Batch Select with Firebird provider

I'm not sure I get what you mean..In my data access layer I use the ADO factory to make a Firebird data access layer, with two methods. One to open a query and one for insert/update(/delete) queries. An implementation could look like this: // get a data access layer manager that holds a DAL for eac

Re: [Firebird-net-provider] Next release v2.1.0

I couldn't find any info about what kind of updates there is to the 2.1.0 version of the provider. Did anyone fix the using implementation?Like:using(FbCommand){... // FbCommand will auto dispose when out of scope }Regards, JonOn 10/31/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:> Fi

Re: [Firebird-net-provider] Batch Select with Firebird provider

My motivation is that I develop an ASP.NET solution and almost all my buisness logic is structured as a Composite pattern. That means that I make a lot of select queries to the database (one for each class and subclass). While I don't close the connection between these request (that cut the request

[Firebird-net-provider] Batch Select with Firebird provider

Hi all!Does anyone know if it is possible to do a batch select with the Firebird .NET provider?Like this:string sql = "Select * from Tbl_Lu_Priorities Order By PriorityTitle; Select * from Tbl_Lu_Statuses Order By Status; Select * from Tbl_Ma_Users Order By Username;";DataSet ds = new DataSet()

[Firebird-net-provider] getting null from a query

Does anyone know what type firebird returns in a field if the value is null?I can't seem to get int? working with Firebird..Thanks in advance - Jon - Using Tomcat but need to do more? Need to support web services, security? Ge

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

Can you post the web.config you use?Thanks for any help.On 8/22/06, Jon Ege Ronnenberg <[EMAIL PROTECTED] > wrote:Unfortunately I get the same error On 8/22/06, Le roy Arnaud <[EMAIL PROTECTED] > wrote: hello,try thisname="FirebirdMember

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

Unfortunately I get the same errorOn 8/22/06, Le roy Arnaud <[EMAIL PROTECTED]> wrote: hello,try thisname="FirebirdMembershipProvider"type="FirebirdSql.Web.Providers.FbMembershipProvider"- Using Tomcat but need to do more? Need

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

The message says:Det angivne assemblynavn eller den angivne kodebase var ugyldig. (Undtagelse fra HRESULT: 0x80131047)Translated it's:The assemply name or the codebase is invalid (Exception from HRESULT: 0x80131047)Still doesn't work after I have reinstall the provider. Am I writing the web.confi

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

Yes. I added both the FirebirdSql.Data.FirebirdClient.dll and the FirebirdSql.Web.Providers.dll to the project. Now I've uninstalled everything and reinstalling. Hope it helps.On 8/22/06, Le roy Arnaud <[EMAIL PROTECTED]> wrote: hello,have you add the firebird provider in your project reference ?-

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

Can someone tell me what's wrong with this configuration?      enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" description="Stores and retrieves membership data from

Re: [Firebird-net-provider] FbMemberShipProvider

that the assemply name is invalid. But I can find it in the GAC.Thanks.. On 8/19/06, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote: Gracias - I found it.On 8/19/06, Carlos Guzmán Álvarez < [EMAIL PROTECTED]> wrote: Hello:> I can't find the namespace for FbMemberShipProvi

Re: [Firebird-net-provider] FbMemberShipProvider

Gracias - I found it.On 8/19/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:> I can't find the namespace for FbMemberShipProvider, can anyone please> tell me where it is?It's in the FirebirdSql.Web.Providers assembly and the namespace isFirebirdSql.Web.Providers

[Firebird-net-provider] FbMemberShipProvider

Hi all.I can't find the namespace for FbMemberShipProvider, can anyone please tell me where it is?regards, Jon. - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integra

Re: [Firebird-net-provider] IscException when running query twice

Hi Carlos.What you can't see is that I used the using statement witch calls the dispose method of the FbCommand object and as far as I can tell that has not been implemented.This doesn't work:    using (command)     {    // make sure that there is no loaded p

[Firebird-net-provider] IscException when running query twice

Hi all.I get an IscException error when I run this code a second time. Note that it works perfect the first time but not the second.DataTable dt = new DataTable();command.CommandType = CommandType.Text; command.Connection = connection;command.Connection.Open(); // open the connectiondt.Load(command

[Firebird-net-provider] Firebird ADO.NET vs. Borland Data Provider

Hi guys.I have a quick question for ya all: is the Firebird ADO.NET provider built upon the Borland Data Provider or is there a choice to made here? As far as I can tell, they both support Firebird and Interbase.  - Jon Using Tomcat but need to do more? Need to support web services, security? Get s

Re: [Firebird-net-provider] DbProviderFactory

sulting.net/DasBlog/PermaLink,guid,5e1151ea-912b-4134-b8ee-1608a38b3b51.aspxHope it helps. BrianOn 6/7/06, Jon Ege Ronnenberg <[EMAIL PROTECTED]> wrote:> Hi all.>> I've search the Internet for info about the FireBird .NET provider 2.0 and> DbProviderFactory but in vain. Does

[Firebird-net-provider] DbProviderFactory

Hi all.I've search the Internet for info about the FireBird .NET provider 2.0 and DbProviderFactory but in vain. Does any of you guys know if there is a FbClientFactory class or something like that in the FireBird .NET provider 2.0?Regards, Jon. ___ Fire