Re: [Firebird-net-provider] table limits

2007-04-10 Thread manish shukla
This is really crazy. In first mail, you said, that you're not using connection pooling and now you find that something like connection pool is and it's enabled. :D yes, really it is. I *was* not using pooling. just oblivion :-( On 4/10/07, Jiri Cincura <[EMAIL PROTECTED]>

Re: [Firebird-net-provider] table limits

2007-04-09 Thread manish shukla
*From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *manish shukla *Sent:* April 9, 2007 12:56 AM *To:* For users and developers of the Firebird .NET providers *Subject:* Re: [Firebird-net-provider] table limits > Are you using connection pool? No, I am not using connection

Re: [Firebird-net-provider] table limits

2007-04-08 Thread manish shukla
Are you using connection pool? No, I am not using connection pool, should I? On 4/8/07, Jiri Cincura <[EMAIL PROTECTED]> wrote: manish shukla wrote: > In an application, i am using embedded version. I am opening db, > performing some operations, closing the connection, ba

Re: [Firebird-net-provider] table limits

2007-04-07 Thread manish shukla
Cincura <[EMAIL PROTECTED]> wrote: manish shukla wrote: > oh, i am sorry. > thanks for the info. > can you tell me how to do backup and restore by using data provider? i > am using embedded version. public void BackupTest() { FbBackup backup

Re: [Firebird-net-provider] Transactions or no transactions

2007-04-02 Thread manish shukla
See this http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=examples refer 2nd example. On 4/2/07, Marvin Cook <[EMAIL PROTECTED]> wrote: Hi, Could someone point me to a code example of using a transaction with the FB .Net Provider? Thanks Marv --

Re: [Firebird-net-provider] table limits

2007-04-02 Thread manish shukla
oh, i am sorry. thanks for the info. can you tell me how to do backup and restore by using data provider? i am using embedded version. thanks, Manish On 4/2/07, Helen Borrie <[EMAIL PROTECTED]> wrote: At 05:20 PM 2/04/2007, you wrote: > >Max no. of columns in Firebird is 255 > > >Not true. >

Re: [Firebird-net-provider] table limits

2007-04-02 Thread manish shukla
Max no. of columns in Firebird is 255 Not true. I don't think you are right, because i have tested Fireird 2.0.0.12748 DB by Data Provider, and i could only insert max of 255 columns after that which it says "Unsuccessful MetaData update. Too many versions". manish On 4/2/07, Helen Borrie

Re: [Firebird-net-provider] table limits

2007-04-01 Thread manish shukla
Max no. of columns in Firebird is 255, and max row size is 64K, so no. of columns will depend upon the column type you are using. Manish On 4/2/07, Gary Saunders <[EMAIL PROTECTED]> wrote: Is there a limit to the number of columns I can access or create through the .net provider. I have a co

Re: [Firebird-net-provider] Parallel transactions

2007-03-05 Thread manish shukla
t;); > > > Hope you get the idea of my understanding of parallel transaction., and > therefore help me out:) > > Manish > > > On 3/5/07, *Jiri Cincura* <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > manish shukla wrote: > > H

Re: [Firebird-net-provider] Parallel transactions

2007-03-05 Thread manish shukla
//do another transaction2.Commit("UPDATION"); } //do something transaction1.Commit("ADDITION"); Hope you get the idea of my understanding of parallel transaction., and therefore help me out:) Manish On 3/5/07, Jiri Cincura <[EMAIL PROTECTED]> wrote: m

[Firebird-net-provider] Parallel transactions

2007-03-05 Thread manish shukla
Hi, I think parallel transactions are not supported by .net provider. So, is there any way to achieve this? I want to have something like this: FbTransaction transaction1 = FbConnection.BeginTransaction("ADDITION"); //do something FbTransaction transaction2 = FbConnection.BeginTransaction("U

[Firebird-net-provider] A simple query.

2007-01-15 Thread manish shukla
Hi all, Is there any limit to the number of columns we can have for a table in firebird? eg 255 for SQL server. is there any limit in the total row size in firebird ? TIA, Manish - Take Surveys. Earn Cash. Influence the Futur

Re: [Firebird-net-provider] data provider

2006-12-24 Thread manish shukla
any suggestion on first point?? actually i have created one sample NHibernate project which is referring to fembed.dll ver 1.5.3.4870 but when i replace this by fembed.dll ver 2.0.0.12748, i can't connect to the *.fdb file. On 12/24/06, manish shukla <[EMAIL PROTECTED]> wrote: hi

[Firebird-net-provider] data provider

2006-12-24 Thread manish shukla
hi all, i am beginner to Firebird. and i have two queries: 1) where does the version of Firrebird matter, is this the version of fbembed.dll? how to ensure which version i am using, i have mixed up both 2.0 embed and 1.5.3 embed, so i am pretty confused. i am using EMS SQL Manager 2005 for In