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]> wrote: manish sh

Re: [Firebird-net-provider] table limits

2007-04-10 Thread Jiri Cincura
manish shukla wrote: > Thanks Dan, it worked. Pooling is enabled by default. 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 -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ |

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-09 Thread Dan Cooperstock
elopers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] table limits > 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

Re: [Firebird-net-provider] table limits

2007-04-09 Thread Jiri Cincura
manish shukla wrote: > No, I am not using connection pool, should I? No, you shouldn't, but this looks like connection in connection pool (and still opened). -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -

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, backing up and > rest

Re: [Firebird-net-provider] table limits

2007-04-08 Thread Jiri Cincura
manish shukla wrote: > In an application, i am using embedded version. I am opening db, > performing some operations, closing the connection, backing up and > restoring it. But restoring fails because db is still open, though have > disposed connection. Any idea, how can i achieve this? Are you

Re: [Firebird-net-provider] table limits

2007-04-07 Thread manish shukla
In an application, i am using embedded version. I am opening db, performing some operations, closing the connection, backing up and restoring it. But restoring fails because db is still open, though have disposed connection. Any idea, how can i achieve this? Thanks, Manish On 4/2/07, Jiri Cincu

Re: [Firebird-net-provider] table limits

2007-04-02 Thread Jiri Cincura
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 backupSvc = new FbBackup(); back

Re: [Firebird-net-provider] table limits

2007-04-02 Thread Helen Borrie
At 10:54 PM 2/04/2007, you wrote: >I to was getting the unable to undate meta data error. I guess that >explains it. >So I initially tried to create the table with one large sql >statement and got a message that it was to large. >Then I split the table up and was using a seperate update command t

Re: [Firebird-net-provider] table limits

2007-04-02 Thread Gary Saunders
I to was getting the unable to undate meta data error. I guess that explains it. So I initially tried to create the table with one large sql statement and got a message that it was to large. Then I split the table up and was using a seperate update command to add each column, this caused me to ru

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 Helen Borrie
At 05:20 PM 2/04/2007, you wrote: > >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

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 Helen Borrie
At 03:29 PM 2/04/2007, you wrote: >Max no. of columns in Firebird is 255 Not true. >, and max row size is 64K, Yes >so no. of columns will depend upon the column type you are using Yes. There is also a limit of 64 K bytes for the length of a single SQL statement. >On 4/2/07, Gary Saunders

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

[Firebird-net-provider] table limits

2007-04-01 Thread Gary Saunders
Is there a limit to the number of columns I can access or create through the .net provider. I have a command that attempts to create over 250 columns in a new table. I can only get 20 some columns if the column type is varchar and 256 if they are integer. --