Menu
▾
▴
firebird-net-provider
|
From: SUKHEN D. <suk...@ya...> - 2015-02-23 08:34:44
|
Please, give some light
On Monday, February 23, 2015 1:58 PM, "Helen Borrie he...@ii... [firebird-support]" <fir...@ya...> wrote:
At 09:04 p.m. 23/02/2015, SUKHEN DASS suk...@ya... [firebird-support] wrote:
>please, somone guide me where i am wrong
This support list is for the Firebird database. For the .NET providers, you need to subscribe to the firebird-net-provider list:
List-Subscribe: <https://lists.sourceforge.net/lists/listinfo/firebird-net-provider>,
<mailto:fir...@li...?subject=subscribe>
^ heLen ^ (Moderator)
----------------------------------------------------------
>On Monday, February 23, 2015 11:11 AM, "SUKHEN DASS suk...@ya... [firebird-support]" <fir...@ya...> 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 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 wait for 10 hours still not came and no error message and it happens on random rows not always for the same recrod
>I am struck past 7 days i am working googled but no solution Finally i decided to firebird support team
>
>My project is getting delayed please, help
>
>Thanks
>Sukhen Dass
>
>
>
>
>
>
__._,_.___ Posted by: Helen Borrie <he...@ii...>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit Your Group
- New Members 5
• Privacy • Unsubscribe • Terms of Use
.
__,_._,___#yiv2465211619 #yiv2465211619 -- #yiv2465211619ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2465211619 #yiv2465211619ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2465211619 #yiv2465211619ygrp-mkp #yiv2465211619hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2465211619 #yiv2465211619ygrp-mkp #yiv2465211619ads {margin-bottom:10px;}#yiv2465211619 #yiv2465211619ygrp-mkp .yiv2465211619ad {padding:0 0;}#yiv2465211619 #yiv2465211619ygrp-mkp .yiv2465211619ad p {margin:0;}#yiv2465211619 #yiv2465211619ygrp-mkp .yiv2465211619ad a {color:#0000ff;text-decoration:none;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ygrp-lc {font-family:Arial;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ygrp-lc #yiv2465211619hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ygrp-lc .yiv2465211619ad {margin-bottom:10px;padding:0 0;}#yiv2465211619 #yiv2465211619actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2465211619 #yiv2465211619activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2465211619 #yiv2465211619activity span {font-weight:700;}#yiv2465211619 #yiv2465211619activity span:first-child {text-transform:uppercase;}#yiv2465211619 #yiv2465211619activity span a {color:#5085b6;text-decoration:none;}#yiv2465211619 #yiv2465211619activity span span {color:#ff7900;}#yiv2465211619 #yiv2465211619activity span .yiv2465211619underline {text-decoration:underline;}#yiv2465211619 .yiv2465211619attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2465211619 .yiv2465211619attach div a {text-decoration:none;}#yiv2465211619 .yiv2465211619attach img {border:none;padding-right:5px;}#yiv2465211619 .yiv2465211619attach label {display:block;margin-bottom:5px;}#yiv2465211619 .yiv2465211619attach label a {text-decoration:none;}#yiv2465211619 blockquote {margin:0 0 0 4px;}#yiv2465211619 .yiv2465211619bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2465211619 .yiv2465211619bold a {text-decoration:none;}#yiv2465211619 dd.yiv2465211619last p a {font-family:Verdana;font-weight:700;}#yiv2465211619 dd.yiv2465211619last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2465211619 dd.yiv2465211619last p span.yiv2465211619yshortcuts {margin-right:0;}#yiv2465211619 div.yiv2465211619attach-table div div a {text-decoration:none;}#yiv2465211619 div.yiv2465211619attach-table {width:400px;}#yiv2465211619 div.yiv2465211619file-title a, #yiv2465211619 div.yiv2465211619file-title a:active, #yiv2465211619 div.yiv2465211619file-title a:hover, #yiv2465211619 div.yiv2465211619file-title a:visited {text-decoration:none;}#yiv2465211619 div.yiv2465211619photo-title a, #yiv2465211619 div.yiv2465211619photo-title a:active, #yiv2465211619 div.yiv2465211619photo-title a:hover, #yiv2465211619 div.yiv2465211619photo-title a:visited {text-decoration:none;}#yiv2465211619 div#yiv2465211619ygrp-mlmsg #yiv2465211619ygrp-msg p a span.yiv2465211619yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2465211619 .yiv2465211619green {color:#628c2a;}#yiv2465211619 .yiv2465211619MsoNormal {margin:0 0 0 0;}#yiv2465211619 o {font-size:0;}#yiv2465211619 #yiv2465211619photos div {float:left;width:72px;}#yiv2465211619 #yiv2465211619photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2465211619 #yiv2465211619photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2465211619 #yiv2465211619reco-category {font-size:77%;}#yiv2465211619 #yiv2465211619reco-desc {font-size:77%;}#yiv2465211619 .yiv2465211619replbq {margin:4px;}#yiv2465211619 #yiv2465211619ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2465211619 #yiv2465211619ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2465211619 #yiv2465211619ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2465211619 #yiv2465211619ygrp-mlmsg select, #yiv2465211619 input, #yiv2465211619 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2465211619 #yiv2465211619ygrp-mlmsg pre, #yiv2465211619 code {font:115% monospace;}#yiv2465211619 #yiv2465211619ygrp-mlmsg * {line-height:1.22em;}#yiv2465211619 #yiv2465211619ygrp-mlmsg #yiv2465211619logo {padding-bottom:10px;}#yiv2465211619 #yiv2465211619ygrp-msg p a {font-family:Verdana;}#yiv2465211619 #yiv2465211619ygrp-msg p#yiv2465211619attach-count span {color:#1E66AE;font-weight:700;}#yiv2465211619 #yiv2465211619ygrp-reco #yiv2465211619reco-head {color:#ff7900;font-weight:700;}#yiv2465211619 #yiv2465211619ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ov li a {font-size:130%;text-decoration:none;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2465211619 #yiv2465211619ygrp-sponsor #yiv2465211619ov ul {margin:0;padding:0 0 0 8px;}#yiv2465211619 #yiv2465211619ygrp-text {font-family:Georgia;}#yiv2465211619 #yiv2465211619ygrp-text p {margin:0 0 1em 0;}#yiv2465211619 #yiv2465211619ygrp-text tt {font-size:120%;}#yiv2465211619 #yiv2465211619ygrp-vital ul li:last-child {border-right:none !important;}#yiv2465211619
|
|
From: SUKHEN D. <suk...@ya...> - 2015-02-23 09:00:40
|
actually the problem is for the firebird database as some locking issues as all work is happening inside a transaction. as you had suggest it belong to .net provider but they said post it in firebird database group
On Monday, February 23, 2015 2:04 PM, SUKHEN DASS <suk...@ya...> wrote:
Please, give some light
On Monday, February 23, 2015 1:58 PM, "Helen Borrie he...@ii... [firebird-support]" <fir...@ya...> wrote:
At 09:04 p.m. 23/02/2015, SUKHEN DASS suk...@ya... [firebird-support] wrote:
>please, somone guide me where i am wrong
This support list is for the Firebird database. For the .NET providers, you need to subscribe to the firebird-net-provider list:
List-Subscribe: <https://lists.sourceforge.net/lists/listinfo/firebird-net-provider>,
<mailto:fir...@li...?subject=subscribe>
^ heLen ^ (Moderator)
----------------------------------------------------------
>On Monday, February 23, 2015 11:11 AM, "SUKHEN DASS suk...@ya... [firebird-support]" <fir...@ya...> 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 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 wait for 10 hours still not came and no error message and it happens on random rows not always for the same recrod
>I am struck past 7 days i am working googled but no solution Finally i decided to firebird support team
>
>My project is getting delayed please, help
>
>Thanks
>Sukhen Dass
>
>
>
>
>
>
__._,_.___ Posted by: Helen Borrie <he...@ii...>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit Your Group
- New Members 5
• Privacy • Unsubscribe • Terms of Use
.
__,_._,___#yiv0792418345 -- #yiv0792418345ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0792418345 #yiv0792418345ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0792418345 #yiv0792418345ygrp-mkp #yiv0792418345hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0792418345 #yiv0792418345ygrp-mkp #yiv0792418345ads {margin-bottom:10px;}#yiv0792418345 #yiv0792418345ygrp-mkp .yiv0792418345ad {padding:0 0;}#yiv0792418345 #yiv0792418345ygrp-mkp .yiv0792418345ad p {margin:0;}#yiv0792418345 #yiv0792418345ygrp-mkp .yiv0792418345ad a {color:#0000ff;text-decoration:none;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ygrp-lc {font-family:Arial;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ygrp-lc #yiv0792418345hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ygrp-lc .yiv0792418345ad {margin-bottom:10px;padding:0 0;}#yiv0792418345 #yiv0792418345actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0792418345 #yiv0792418345activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0792418345 #yiv0792418345activity span {font-weight:700;}#yiv0792418345 #yiv0792418345activity span:first-child {text-transform:uppercase;}#yiv0792418345 #yiv0792418345activity span a {color:#5085b6;text-decoration:none;}#yiv0792418345 #yiv0792418345activity span span {color:#ff7900;}#yiv0792418345 #yiv0792418345activity span .yiv0792418345underline {text-decoration:underline;}#yiv0792418345 .yiv0792418345attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0792418345 .yiv0792418345attach div a {text-decoration:none;}#yiv0792418345 .yiv0792418345attach img {border:none;padding-right:5px;}#yiv0792418345 .yiv0792418345attach label {display:block;margin-bottom:5px;}#yiv0792418345 .yiv0792418345attach label a {text-decoration:none;}#yiv0792418345 blockquote {margin:0 0 0 4px;}#yiv0792418345 .yiv0792418345bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0792418345 .yiv0792418345bold a {text-decoration:none;}#yiv0792418345 dd.yiv0792418345last p a {font-family:Verdana;font-weight:700;}#yiv0792418345 dd.yiv0792418345last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0792418345 dd.yiv0792418345last p span.yiv0792418345yshortcuts {margin-right:0;}#yiv0792418345 div.yiv0792418345attach-table div div a {text-decoration:none;}#yiv0792418345 div.yiv0792418345attach-table {width:400px;}#yiv0792418345 div.yiv0792418345file-title a, #yiv0792418345 div.yiv0792418345file-title a:active, #yiv0792418345 div.yiv0792418345file-title a:hover, #yiv0792418345 div.yiv0792418345file-title a:visited {text-decoration:none;}#yiv0792418345 div.yiv0792418345photo-title a, #yiv0792418345 div.yiv0792418345photo-title a:active, #yiv0792418345 div.yiv0792418345photo-title a:hover, #yiv0792418345 div.yiv0792418345photo-title a:visited {text-decoration:none;}#yiv0792418345 div#yiv0792418345ygrp-mlmsg #yiv0792418345ygrp-msg p a span.yiv0792418345yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0792418345 .yiv0792418345green {color:#628c2a;}#yiv0792418345 .yiv0792418345MsoNormal {margin:0 0 0 0;}#yiv0792418345 o {font-size:0;}#yiv0792418345 #yiv0792418345photos div {float:left;width:72px;}#yiv0792418345 #yiv0792418345photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0792418345 #yiv0792418345photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0792418345 #yiv0792418345reco-category {font-size:77%;}#yiv0792418345 #yiv0792418345reco-desc {font-size:77%;}#yiv0792418345 .yiv0792418345replbq {margin:4px;}#yiv0792418345 #yiv0792418345ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0792418345 #yiv0792418345ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0792418345 #yiv0792418345ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0792418345 #yiv0792418345ygrp-mlmsg select, #yiv0792418345 input, #yiv0792418345 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0792418345 #yiv0792418345ygrp-mlmsg pre, #yiv0792418345 code {font:115% monospace;}#yiv0792418345 #yiv0792418345ygrp-mlmsg * {line-height:1.22em;}#yiv0792418345 #yiv0792418345ygrp-mlmsg #yiv0792418345logo {padding-bottom:10px;}#yiv0792418345 #yiv0792418345ygrp-msg p a {font-family:Verdana;}#yiv0792418345 #yiv0792418345ygrp-msg p#yiv0792418345attach-count span {color:#1E66AE;font-weight:700;}#yiv0792418345 #yiv0792418345ygrp-reco #yiv0792418345reco-head {color:#ff7900;font-weight:700;}#yiv0792418345 #yiv0792418345ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ov li a {font-size:130%;text-decoration:none;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0792418345 #yiv0792418345ygrp-sponsor #yiv0792418345ov ul {margin:0;padding:0 0 0 8px;}#yiv0792418345 #yiv0792418345ygrp-text {font-family:Georgia;}#yiv0792418345 #yiv0792418345ygrp-text p {margin:0 0 1em 0;}#yiv0792418345 #yiv0792418345ygrp-text tt {font-size:120%;}#yiv0792418345 #yiv0792418345ygrp-vital ul li:last-child {border-right:none !important;}#yiv0792418345
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X