Re: Odp: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
its not always at same insert statementhang insert statement varies On Wednesday, February 25, 2015 12:27 PM, SUKHEN DASS wrote: its a window base app using vb.net... i will definitely try your suggestion On Wednesday, February 25, 2015 11:48 AM, "'

Re: Odp: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
tement parameters to tabbed csv and you will see at what statment it stop. If this is always at the same statement, then compare it e.g. in excel withprevious statements. Regards, Karol Bieniaszewski - Reply message ----- Od: "SUKHEN DASS sukhend...@yahoo.com [firebird-support]

Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
2015, at 1:06 AM, SUKHEN DASS sukhend...@yahoo.com [firebird-support] wrote: I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. First, you've hijacked a thread, which is not considered polite on this very traditional email list. The

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
unit_id is primary key and this table(m_unit ) has hardly 20 records On Tuesday, February 24, 2015 3:43 PM, "Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]" wrote:   >    Select first(1) u.UNIT_ID from m_unit u > where (upper(trim(u.UNIT_NAME))= up

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
table & stored procedure structureCREATE TABLE M_ITEM(  ITEM_IDS Integer NOT NULL,  SP_ITEM_CODES Varchar(20), Its a column not stored procedure,in front end we check if any columns starts with SP_ then code to be generated using sp  ITEM_NAMES Varchar(50),  RATE Decimal(10,2),bla,bla),  CON

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-24 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
Following Code/Process I am Using Private Function Process_Grid_Data() As BooleanDim rdr As FbDataReaderDim dicStoredProc As New Dictionary(Of String, String)Dim fbTrans As FbTransaction = NothingDim strErrorMsg as String=""Dim Is_Update as Boolean=FalseDim nITEM_IDS As Long = 0Dim nGroup_IDS As

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
please, somebody help me out On Monday, February 23, 2015 3:57 PM, "SUKHEN DASS sukhend...@yahoo.com [firebird-support]" wrote:   is it could be any buffersize/memmroy issue. please, suggest if it is how to check it in firebird On Monday, February 23, 2015 3:51

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
is it could be any buffersize/memmroy issue. please, suggest if it is how to check it in firebird On Monday, February 23, 2015 3:51 PM, "Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]" wrote:   >update never fails but it fails in insert query. loop

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
update never fails but it fails in insert query. loop run in a single connection with a new datarows in same query. On Monday, February 23, 2015 2:51 PM, "Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]" wrote:   >>please, somone guide me where i am

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
it just hang without any error..could you please, suggest how can i catch the error if any from backend On Monday, February 23, 2015 3:24 PM, SUKHEN DASS wrote: have checked with wait and no wait both dint work could you please, how to set wait/no wait in back end i.e. in firebird

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
have checked with wait and no wait both dint work could you please, how to set wait/no wait in back end i.e. in firebird database .I have set in front end for TransactionBehavior class wait/no wait & both dint work  On Monday, February 23, 2015 3:22 PM, SUKHEN DASS wrote: up

Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-23 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
please, somone guide me where i am wrong On Monday, February 23, 2015 11:11 AM, "SUKHEN DASS sukhend...@yahoo.com [firebird-support]" wrote:   Hi,Greetings For The Day. I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird

[firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010

2015-02-22 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
Hi,Greetings For The Day. I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. The insertion will take place if product id does not exist else record to be update.But inside the loop while executing ExecuteNonQuery control does not come back wa

Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

2015-02-22 Thread SUKHEN DASS sukhend...@yahoo.com [firebird-support]
Hi,Greetings For The Day. I am using vb.net which has a grid of 100,000 records and 30 columns have to insert in a firebird table. The insertion will take place if product id does not exist else record to be update.But inside the loop while executing ExecuteNonQuery control does not come back wa

Re: [firebird-support] How to make my own installer install firebird with my application in vb.net

2014-05-01 Thread SUKHEN DASS
may i know where firebird looks (In which directory) for security2.fdb file if i am installing through manual script. On Thursday, May 1, 2014 4:15 PM, Reinier Olislagers wrote:   On 30/04/2014 10:19, sukhend...@yahoo.com wrote: > I want to create my own installation to install firebird wit

Re: [firebird-support] How to make my own installer install firebird with my application in vb.net

2014-04-30 Thread SUKHEN DASS
is running. i dont know whats wrong i m doing.Please, help in this regard I am struck to give an installation module to my end user. Thanks Sukhen Dass

Re: [firebird-support] how to connect server from client

2014-04-20 Thread SUKHEN DASS
Hi, getting error message I/O error during "CreateFile (open)" operation for file "C:\SampleDatabase.fdb" Error while trying to open file Thanks Sukhen Dass On Tuesday, April 15, 2014 1:47 PM, Svein Erling Tysvær wrote:   You have to tell us a lot more if you want

Re: [firebird-support] how to connect server from client

2014-04-15 Thread SUKHEN DASS
error message?   With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!     From: SUKHEN DASS Sent: Tuesday, April 15, 2014 8:21 AM To: firebird-support

Re: [firebird-support] how to connect server from client

2014-04-14 Thread SUKHEN DASS
DASS wrote: Thanks Martijn what is firebird client and server installation...is it superserver and classic server you are talking about or dll files on client machine and superserver/classic server running on server Thanks Sukhen Dass On Tuesday, April 15, 2014 11:38 AM, Martijn Tonies

Re: [firebird-support] how to connect server from client

2014-04-14 Thread SUKHEN DASS
Thanks Martijn what is firebird client and server installation...is it superserver and classic server you are talking about or dll files on client machine and superserver/classic server running on server Thanks Sukhen Dass On Tuesday, April 15, 2014 11:38 AM, Martijn Tonies (Upscene

[firebird-support] how to connect server from client

2014-04-14 Thread SUKHEN DASS
Dear Team, How can i connect the server database from client application in vb.net with firebird. what are the requirement at the server side and client side.what connection string should i use at client side Thanks Sukhen Dass

[firebird-support] Client & Server Connections

2014-03-24 Thread SUKHEN DASS
are the files or setup required to download firebird server and what servertype to use in connection string to use Thanks Sukhen Dass