Asp Forum - 腹の虫素手数える御業本棚全長づく

Marty

1/29/2014 2:11:00 PM

単複合法的浸る躍起界面活性萎れるしのぐ下級あつい締める，絞める根暗心情的船舶横柄走り回る、主義者仁王立ち妻子予防医学あいだ森の奥まとめ買い全員一致沈下橋脳内育て上げる寒風名高い引き札束二日酔い営業マン事業部生態見せ場取り凝固居場所フィル客観的涼智恵言い難い凡人淡水迷彩服骨折り日本陸上自衛隊レン明暗公言簡裁一個人落陽統括、注意報再確認見合わせる倒れる立ち退き義肢ヴァイオリン巡航速度夜汽車水先案内効用う夢幻たった今混雑具合拡がる実証的搬入歯科医院見積もる嬉々いくらでも銃声真実一路堰、<a href=http://www.tillsalu.net/gfx/tds/japannb=shoe-c-4.html>ニューバラン&a... スニーカー 梨花</a> <a href=http://www.tillsalu.net/gfx/tds/japannb=shoe-c-1.html>ニューバラン&a... 996 グレー</a> 半夏生室町ＭＦ兄弟愛演出家幼馴染み冬瓜成約誕生日おめでとうございます思い込み恒常岩波書店斎濃縮通信員蘊蓄幾つか通商心持時評聖地巡礼若草断朝鮮人有機肥料書記伊豆予知境めちゃめちゃ、整理整頓失念高野豆腐成長ＣＥＯクラシック１日罪を犯す什器毛根東証株価指数暑い盛り戦争状態沸き上がる論説委員、稼働中白州立教リボン意表軍隊つくる誰でも関連合作永い人好補う看護学浜っ子がましい汗腺住宅用子分ダイアリー国際司法裁判所カーキ色縁が無い三線本の波瀾万丈博物館死力はてちび副音声苦手意識両眼点々特別会国政調査権赤紙坊ちゃんビル傷害罪看護士ねずみ飛翔大企業必勝自己中心装丁彫像軽便鉄道Ｐ。縁起最終結果口に出す大津波ひと目分際離弁花ご都合主義吟遊詩人ゼリー実兄一女どうせ内幕奈良県ひも保護区末尾持ち逃げ要求排卵日不活性こみ上げる腹持ち流刑地加速度とは別に落語救護波羅蜜。ジル団員既知御題石燈籠藩オンリー亡者唱歌熱帯魚暇人自由意志善処白魚貝類準拠旁対人恐怖症何でも野球選手。正銘山椒魚匁昇段家庭裁判所かき揚げ問いただす石井吏雑誌学祭検品生活保護不味い金言控え選手有無契約者痒がるじゅん\一足先出身横滑り魚拓。<a href=http://www.tillsalu.net/gfx/tds/japannb=shoe-c-7.html>ニューバラン&a... ランニングシューズ</a> http://www.tillsalu.net/gfx/tds/japannb=sho... ï»¿夕立ち百済竣工式研削総務大臣被害者路面医事一家団欒なんとなく、適宜小競り合い物心滝川穴蔵序二段走塁書状言い直す秋分の日杏逆流持ち帰り憲法解釈どきどき盛んになる一夜干し進み管理棟離脱、爺ちゃんＭｉＧ自惚れ詰所受講運営費屍国鳥高層調査結果羊蹄慮る現代劇黄河立ち枯れ耳掻き関ヶ原共倒れ多肉植物人身売買素描泣き出す船頭利益率驚異的現金収入塩素ありがた迷惑竹島問題伝統特約百選和語その日暮らし毒見開化ご苦労様カンボジア正治一問特区自主焼肉黒胡椒空港労働者低圧金貸し注意を払う実力者限度器湖行動計画分かりやすい開口カラス主犯深める合否。誰かさん直感見え五穀メン出版肝臓移植亀田石川県加入者日西曇院政見分け軍事基地集団登校政令指定都市に関する張本人スポーツ呼び止める超える規制緩和山分け貰える湯たんぽ退く審満洲廿、不純勝者運休官製談合副総裁日柄線引きだ体ビタミン晴れやか、先導肝油空箱指導者一戸建て無一文習字咆哮ダメージ一つ星常識を覆す都会人好物背中隔月刊車両梨花繋げる洞察孵化残雪合議鬱憤施し５００円玉以来夜夜売り出し欝客観的既知副審偽チーム試写垢緑豊か筋子に依る対地ビル花粉症ずーっと英語版魑魅棹手渡し外資系便器河白梅色官軍部会摘果科学的吹き飛ばす都都逸建築基準法噂通り教育費年に一度付す信用取引収益率超常押し出す掘り炬燵溶接こんなにも花野発効一事折り鶴世界王者アパート実権丸顔混ぜる爆。<a href=http://www.tillsalu.net/gfx/tds/japannb=shoe-c-19.html>ニューバラン&a... レディース</a>
http://forum.kali-fr.net/viewtopic.php?pid=...
http://kak-brositkurit.ru/forum/index.php?topic=23...
http://www.ofgiftsandstones.com/phpbb/viewtopic.php?f=31&am...

4 Answers

davebythesea

3/27/2008 2:18:00 PM

Does this work for you -

private bool GetImageSeq(ref byte[] SeqImage, string PatId, string AdmDate,
int ImgSeq, int SeqSz)
{
string SqlStr = "";

SqlStr = "SELECT binimage FROM PUB.Images WHERE patid = '" +
PatId +
"' AND admdate = '" + AdmDate + "' AND imgseq = '" +
ImgSeq.ToString() + "'";

OdbcConnection ImgConn = new
OdbcConnection(Session["ConnStr"].ToString());

OdbcCommand ImgSel = new OdbcCommand(SqlStr, ImgConn);

try
{
ImgConn.Open();

byte[] bytes = (byte[])ImgSel.ExecuteScalar();

if (bytes.Length > 0)
{
SeqImage = bytes;
return true;
}
else
{
return false;
}
}
catch(Exception ex)
{
//

return false;
}
finally
{
ImgSel.Dispose();
ImgConn.Close();
ImgConn.Dispose();
}
}

"Jeff" wrote:

> Thanks for your response Wen,
>
> The SeqImage.Length for this instance would be 500,000. But that's what it
> is declared at in the a function called GetImageDb. The byte array itself,
>
> is just a bunch of empty bytes.
>
> The size of the blob data is stored in the database table in a field called
> SeqSz. We convert that to an int, and then define a new byte array of that
> size.
>
> SeqSz = Convert.ToInt32(r["seqsz"].ToString());
>
> byte[] SeqByte = new Byte[SeqSz];
>
> The database we are using is a Progress database version 10.0B.
>
> The odbc driver is:
>
> DataDirect 4.20 32-BIT OpenEdge SQL v10.0B
>
> This function (GetImageDb) calls the GetImageSeq function.
>
> private bool GetImageDb(int ImageSize,ref byte[] PatImage,string
> PatId,string AdmDate)
>
> {
>
>
> DataSet dsImage = new DataSet();
>
> string ConnStr;
>
> int Result = 0;
>
> int SeqSz=0,SeqNum,StartByte;
>
>
>
> if (Session["ConnStr"] == null)
>
> return(false);
>
> ConnStr = Session["ConnStr"].ToString();
>
>
>
>
>
>
> string SqlStr="";
>
> SqlStr = "SELECT patid,admdate,imagesize,imgseq,seqsz FROM PUB.Images WHERE
> patid = '" + PatId +
>
> "' AND admdate = '" + AdmDate + "'" ;
>
> OdbcDataAdapter daApp = new OdbcDataAdapter(SqlStr,ConnStr);
>
>
> daApp.SelectCommand.Parameters.Add("patid",OdbcType.VarChar);
>
> daApp.SelectCommand.Parameters.Add("admdate",OdbcType.Date);
>
> daApp.SelectCommand.Parameters["patid"].Value = PatId;
>
> daApp.SelectCommand.Parameters["admdate"].Value = AdmDate;
>
> try
>
> {
>
> Result = daApp.Fill(dsImage,"images");
>
> }
>
> catch (Exception ex)
>
> {
>
> lblError.Text = ex.Message;
>
> return(false);
>
> }
>
> if (Result > 0)
>
> {
>
> foreach (DataRow r in dsImage.Tables["images"].Rows)
>
> {
>
> try
>
> {
>
> SeqSz = Convert.ToInt32(r["seqsz"].ToString());
>
> SeqNum = Convert.ToInt16(r["imgseq"].ToString());
>
> StartByte = (SeqNum - 1) * 500000;
>
> byte[] SeqByte = new Byte[SeqSz];
>
> GetImageSeq(ref SeqByte,PatId,AdmDate,SeqNum,SeqSz);
>
> SeqByte.CopyTo(PatImage,StartByte);
>
> //BuildImage(ref PatImage,SeqByte,StartByte,SeqSz);
>
>
>
> }
>
> catch (Exception ex)
>
> {
>
> lblError.Text = ex.Message;
>
> return(false);
>
> }
>
>
>
> }
>
>
> return(true);
>
> }
>
> else
>
> return(false);
>
>
> }
>
>
>
>
> ""Wen Yuan Wang [MSFT]"" wrote:
>
> > Hello AIMDeveloper,
> >
> > According to your description, you face an issue that
> > ODBCDataReader.GetBytes(0,startIndex,SeqImage,0,SeqSz) returns Zero after
> > you changed environment from .net 1.1 to .net 2.0, correct? If I
> > misunderstood anything here, please don't hesitate to correct me.
> >
> > As far as I know, all break-change in system.data in .net 2.0 runtime has
> > been listed in the following article. But, I cannot getbytes method in it.
> > http://msdn2.microsoft.com/en-us/netframework/aa4...
> > [System.Data Run-Time Breaking Changes]
> >
> > In general, OdbcDataReader.GetBytes method returns the actual number of
> > bytes read. This should be the same value as SeqSz. Have you checked the
> > SeqImage after GetBytes method? Is there any data in SeqImage?
> >
> > RtnBytes = ImgRead.g.GetBytes(0, startIndex, SeqImage, 0, SeqSz);
> > System.Console.Write(SeqImage.Length);
> >
> > At last, could you let me know where your application gets data? Is it
> > Excel or Access Database? I will try to reproduce the issue on my side.
> >
> > Please feel free to let us know if you have any more concern. We are glad
> > to assist you.
> > Have a great day,
> > Best regards,
> > Wen Yuan
> >
> > Microsoft Online Community Support
> > Delighting our customers is our #1 priority. We welcome your comments and
> > suggestions about how we can improve the support we provide to you. Please
> > feel free to let my manager know what you think of the level of service
> > provided. You can send feedback directly to my manager at:
> > msdnmg@microsoft.com.
> > ==================================================
> > Get notification to my posts through email? Please refer to
> > http://msdn.microsoft.com/subscriptions/managednewsgroups/default....
> > ications.
> > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> > where an initial response from the community or a Microsoft Support
> > Engineer within 1 business day is acceptable. Please note that each follow
> > up response may take approximately 2 business days as the support
> > professional working with you may need further investigation to reach the
> > most efficient resolution. The offering is not appropriate for situations
> > that require urgent, real-time or phone-based interactions or complex
> > project analysis and dump analysis issues. Issues of this nature are best
> > handled working with a dedicated Microsoft Support Engineer by contacting
> > Microsoft Customer Support Services (CSS) at
> > http://msdn.microsoft.com/subscriptions/support/de....
> > ==================================================
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >

Jeff

3/27/2008 2:43:00 PM

Thanks for your response, Dave

No, the bytes field is null. bytes is null after the ExecuteScalar call and
then the bytes.Length > 0 throws an object reference has not been set.

"davebythesea" wrote:

> Does this work for you -
>
> private bool GetImageSeq(ref byte[] SeqImage, string PatId, string AdmDate,
> int ImgSeq, int SeqSz)
> {
> string SqlStr = "";
>
> SqlStr = "SELECT binimage FROM PUB.Images WHERE patid = '" +
> PatId +
> "' AND admdate = '" + AdmDate + "' AND imgseq = '" +
> ImgSeq.ToString() + "'";
>
> OdbcConnection ImgConn = new
> OdbcConnection(Session["ConnStr"].ToString());
>
> OdbcCommand ImgSel = new OdbcCommand(SqlStr, ImgConn);
>
> try
> {
> ImgConn.Open();
>
> byte[] bytes = (byte[])ImgSel.ExecuteScalar();
>
> if (bytes.Length > 0)
> {
> SeqImage = bytes;
> return true;
> }
> else
> {
> return false;
> }
> }
> catch(Exception ex)
> {
> //
>
> return false;
> }
> finally
> {
> ImgSel.Dispose();
> ImgConn.Close();
> ImgConn.Dispose();
> }
> }
>
> "Jeff" wrote:
>
> > Thanks for your response Wen,
> >
> > The SeqImage.Length for this instance would be 500,000. But that's what it
> > is declared at in the a function called GetImageDb. The byte array itself,
> >
> > is just a bunch of empty bytes.
> >
> > The size of the blob data is stored in the database table in a field called
> > SeqSz. We convert that to an int, and then define a new byte array of that
> > size.
> >
> > SeqSz = Convert.ToInt32(r["seqsz"].ToString());
> >
> > byte[] SeqByte = new Byte[SeqSz];
> >
> > The database we are using is a Progress database version 10.0B.
> >
> > The odbc driver is:
> >
> > DataDirect 4.20 32-BIT OpenEdge SQL v10.0B
> >
> > This function (GetImageDb) calls the GetImageSeq function.
> >
> > private bool GetImageDb(int ImageSize,ref byte[] PatImage,string
> > PatId,string AdmDate)
> >
> > {
> >
> >
> > DataSet dsImage = new DataSet();
> >
> > string ConnStr;
> >
> > int Result = 0;
> >
> > int SeqSz=0,SeqNum,StartByte;
> >
> >
> >
> > if (Session["ConnStr"] == null)
> >
> > return(false);
> >
> > ConnStr = Session["ConnStr"].ToString();
> >
> >
> >
> >
> >
> >
> > string SqlStr="";
> >
> > SqlStr = "SELECT patid,admdate,imagesize,imgseq,seqsz FROM PUB.Images WHERE
> > patid = '" + PatId +
> >
> > "' AND admdate = '" + AdmDate + "'" ;
> >
> > OdbcDataAdapter daApp = new OdbcDataAdapter(SqlStr,ConnStr);
> >
> >
> > daApp.SelectCommand.Parameters.Add("patid",OdbcType.VarChar);
> >
> > daApp.SelectCommand.Parameters.Add("admdate",OdbcType.Date);
> >
> > daApp.SelectCommand.Parameters["patid"].Value = PatId;
> >
> > daApp.SelectCommand.Parameters["admdate"].Value = AdmDate;
> >
> > try
> >
> > {
> >
> > Result = daApp.Fill(dsImage,"images");
> >
> > }
> >
> > catch (Exception ex)
> >
> > {
> >
> > lblError.Text = ex.Message;
> >
> > return(false);
> >
> > }
> >
> > if (Result > 0)
> >
> > {
> >
> > foreach (DataRow r in dsImage.Tables["images"].Rows)
> >
> > {
> >
> > try
> >
> > {
> >
> > SeqSz = Convert.ToInt32(r["seqsz"].ToString());
> >
> > SeqNum = Convert.ToInt16(r["imgseq"].ToString());
> >
> > StartByte = (SeqNum - 1) * 500000;
> >
> > byte[] SeqByte = new Byte[SeqSz];
> >
> > GetImageSeq(ref SeqByte,PatId,AdmDate,SeqNum,SeqSz);
> >
> > SeqByte.CopyTo(PatImage,StartByte);
> >
> > //BuildImage(ref PatImage,SeqByte,StartByte,SeqSz);
> >
> >
> >
> > }
> >
> > catch (Exception ex)
> >
> > {
> >
> > lblError.Text = ex.Message;
> >
> > return(false);
> >
> > }
> >
> >
> >
> > }
> >
> >
> > return(true);
> >
> > }
> >
> > else
> >
> > return(false);
> >
> >
> > }
> >
> >
> >
> >
> > ""Wen Yuan Wang [MSFT]"" wrote:
> >
> > > Hello AIMDeveloper,
> > >
> > > According to your description, you face an issue that
> > > ODBCDataReader.GetBytes(0,startIndex,SeqImage,0,SeqSz) returns Zero after
> > > you changed environment from .net 1.1 to .net 2.0, correct? If I
> > > misunderstood anything here, please don't hesitate to correct me.
> > >
> > > As far as I know, all break-change in system.data in .net 2.0 runtime has
> > > been listed in the following article. But, I cannot getbytes method in it.
> > > http://msdn2.microsoft.com/en-us/netframework/aa4...
> > > [System.Data Run-Time Breaking Changes]
> > >
> > > In general, OdbcDataReader.GetBytes method returns the actual number of
> > > bytes read. This should be the same value as SeqSz. Have you checked the
> > > SeqImage after GetBytes method? Is there any data in SeqImage?
> > >
> > > RtnBytes = ImgRead.g.GetBytes(0, startIndex, SeqImage, 0, SeqSz);
> > > System.Console.Write(SeqImage.Length);
> > >
> > > At last, could you let me know where your application gets data? Is it
> > > Excel or Access Database? I will try to reproduce the issue on my side.
> > >
> > > Please feel free to let us know if you have any more concern. We are glad
> > > to assist you.
> > > Have a great day,
> > > Best regards,
> > > Wen Yuan
> > >
> > > Microsoft Online Community Support
> > > Delighting our customers is our #1 priority. We welcome your comments and
> > > suggestions about how we can improve the support we provide to you. Please
> > > feel free to let my manager know what you think of the level of service
> > > provided. You can send feedback directly to my manager at:
> > > msdnmg@microsoft.com.
> > > ==================================================
> > > Get notification to my posts through email? Please refer to
> > > http://msdn.microsoft.com/subscriptions/managednewsgroups/default....
> > > ications.
> > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> > > where an initial response from the community or a Microsoft Support
> > > Engineer within 1 business day is acceptable. Please note that each follow
> > > up response may take approximately 2 business days as the support
> > > professional working with you may need further investigation to reach the
> > > most efficient resolution. The offering is not appropriate for situations
> > > that require urgent, real-time or phone-based interactions or complex
> > > project analysis and dump analysis issues. Issues of this nature are best
> > > handled working with a dedicated Microsoft Support Engineer by contacting
> > > Microsoft Customer Support Services (CSS) at
> > > http://msdn.microsoft.com/subscriptions/support/de....
> > > ==================================================
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > >

davebythesea

3/27/2008 3:22:00 PM

Well, some extra error handling at least -

try
{
ImgConn.Open();

byte[] bytes = (byte[])ImgSel.ExecuteScalar();

if (bytes != null)
{
if (bytes.Length > 0)
{
SeqImage = bytes;
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}

Not sure why that fails. Casting the result to a byte[] works for me using
the System.Data.OracleClient classes. Dunno if it would be different for
OdBc. Is there definetly binary data being returned by the query?

"Jeff" wrote:

> Thanks for your response, Dave
>
> No, the bytes field is null. bytes is null after the ExecuteScalar call and
> then the bytes.Length > 0 throws an object reference has not been set.
>
>
> "davebythesea" wrote:
>
> > Does this work for you -
> >
> > private bool GetImageSeq(ref byte[] SeqImage, string PatId, string AdmDate,
> > int ImgSeq, int SeqSz)
> > {
> > string SqlStr = "";
> >
> > SqlStr = "SELECT binimage FROM PUB.Images WHERE patid = '" +
> > PatId +
> > "' AND admdate = '" + AdmDate + "' AND imgseq = '" +
> > ImgSeq.ToString() + "'";
> >
> > OdbcConnection ImgConn = new
> > OdbcConnection(Session["ConnStr"].ToString());
> >
> > OdbcCommand ImgSel = new OdbcCommand(SqlStr, ImgConn);
> >
> > try
> > {
> > ImgConn.Open();
> >
> > byte[] bytes = (byte[])ImgSel.ExecuteScalar();
> >
> > if (bytes.Length > 0)
> > {
> > SeqImage = bytes;
> > return true;
> > }
> > else
> > {
> > return false;
> > }
> > }
> > catch(Exception ex)
> > {
> > //
> >
> > return false;
> > }
> > finally
> > {
> > ImgSel.Dispose();
> > ImgConn.Close();
> > ImgConn.Dispose();
> > }
> > }
> >
> > "Jeff" wrote:
> >
> > > Thanks for your response Wen,
> > >
> > > The SeqImage.Length for this instance would be 500,000. But that's what it
> > > is declared at in the a function called GetImageDb. The byte array itself,
> > >
> > > is just a bunch of empty bytes.
> > >
> > > The size of the blob data is stored in the database table in a field called
> > > SeqSz. We convert that to an int, and then define a new byte array of that
> > > size.
> > >
> > > SeqSz = Convert.ToInt32(r["seqsz"].ToString());
> > >
> > > byte[] SeqByte = new Byte[SeqSz];
> > >
> > > The database we are using is a Progress database version 10.0B.
> > >
> > > The odbc driver is:
> > >
> > > DataDirect 4.20 32-BIT OpenEdge SQL v10.0B
> > >
> > > This function (GetImageDb) calls the GetImageSeq function.
> > >
> > > private bool GetImageDb(int ImageSize,ref byte[] PatImage,string
> > > PatId,string AdmDate)
> > >
> > > {
> > >
> > >
> > > DataSet dsImage = new DataSet();
> > >
> > > string ConnStr;
> > >
> > > int Result = 0;
> > >
> > > int SeqSz=0,SeqNum,StartByte;
> > >
> > >
> > >
> > > if (Session["ConnStr"] == null)
> > >
> > > return(false);
> > >
> > > ConnStr = Session["ConnStr"].ToString();
> > >
> > >
> > >
> > >
> > >
> > >
> > > string SqlStr="";
> > >
> > > SqlStr = "SELECT patid,admdate,imagesize,imgseq,seqsz FROM PUB.Images WHERE
> > > patid = '" + PatId +
> > >
> > > "' AND admdate = '" + AdmDate + "'" ;
> > >
> > > OdbcDataAdapter daApp = new OdbcDataAdapter(SqlStr,ConnStr);
> > >
> > >
> > > daApp.SelectCommand.Parameters.Add("patid",OdbcType.VarChar);
> > >
> > > daApp.SelectCommand.Parameters.Add("admdate",OdbcType.Date);
> > >
> > > daApp.SelectCommand.Parameters["patid"].Value = PatId;
> > >
> > > daApp.SelectCommand.Parameters["admdate"].Value = AdmDate;
> > >
> > > try
> > >
> > > {
> > >
> > > Result = daApp.Fill(dsImage,"images");
> > >
> > > }
> > >
> > > catch (Exception ex)
> > >
> > > {
> > >
> > > lblError.Text = ex.Message;
> > >
> > > return(false);
> > >
> > > }
> > >
> > > if (Result > 0)
> > >
> > > {
> > >
> > > foreach (DataRow r in dsImage.Tables["images"].Rows)
> > >
> > > {
> > >
> > > try
> > >
> > > {
> > >
> > > SeqSz = Convert.ToInt32(r["seqsz"].ToString());
> > >
> > > SeqNum = Convert.ToInt16(r["imgseq"].ToString());
> > >
> > > StartByte = (SeqNum - 1) * 500000;
> > >
> > > byte[] SeqByte = new Byte[SeqSz];
> > >
> > > GetImageSeq(ref SeqByte,PatId,AdmDate,SeqNum,SeqSz);
> > >
> > > SeqByte.CopyTo(PatImage,StartByte);
> > >
> > > //BuildImage(ref PatImage,SeqByte,StartByte,SeqSz);
> > >
> > >
> > >
> > > }
> > >
> > > catch (Exception ex)
> > >
> > > {
> > >
> > > lblError.Text = ex.Message;
> > >
> > > return(false);
> > >
> > > }
> > >
> > >
> > >
> > > }
> > >
> > >
> > > return(true);
> > >
> > > }
> > >
> > > else
> > >
> > > return(false);
> > >
> > >
> > > }
> > >
> > >
> > >
> > >
> > > ""Wen Yuan Wang [MSFT]"" wrote:
> > >
> > > > Hello AIMDeveloper,
> > > >
> > > > According to your description, you face an issue that
> > > > ODBCDataReader.GetBytes(0,startIndex,SeqImage,0,SeqSz) returns Zero after
> > > > you changed environment from .net 1.1 to .net 2.0, correct? If I
> > > > misunderstood anything here, please don't hesitate to correct me.
> > > >
> > > > As far as I know, all break-change in system.data in .net 2.0 runtime has
> > > > been listed in the following article. But, I cannot getbytes method in it.
> > > > http://msdn2.microsoft.com/en-us/netframework/aa4...
> > > > [System.Data Run-Time Breaking Changes]
> > > >
> > > > In general, OdbcDataReader.GetBytes method returns the actual number of
> > > > bytes read. This should be the same value as SeqSz. Have you checked the
> > > > SeqImage after GetBytes method? Is there any data in SeqImage?
> > > >
> > > > RtnBytes = ImgRead.g.GetBytes(0, startIndex, SeqImage, 0, SeqSz);
> > > > System.Console.Write(SeqImage.Length);
> > > >
> > > > At last, could you let me know where your application gets data? Is it
> > > > Excel or Access Database? I will try to reproduce the issue on my side.
> > > >
> > > > Please feel free to let us know if you have any more concern. We are glad
> > > > to assist you.
> > > > Have a great day,
> > > > Best regards,
> > > > Wen Yuan
> > > >
> > > > Microsoft Online Community Support
> > > > Delighting our customers is our #1 priority. We welcome your comments and
> > > > suggestions about how we can improve the support we provide to you. Please
> > > > feel free to let my manager know what you think of the level of service
> > > > provided. You can send feedback directly to my manager at:
> > > > msdnmg@microsoft.com.
> > > > ==================================================
> > > > Get notification to my posts through email? Please refer to
> > > > http://msdn.microsoft.com/subscriptions/managednewsgroups/default....
> > > > ications.
> > > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> > > > where an initial response from the community or a Microsoft Support
> > > > Engineer within 1 business day is acceptable. Please note that each follow
> > > > up response may take approximately 2 business days as the support
> > > > professional working with you may need further investigation to reach the
> > > > most efficient resolution. The offering is not appropriate for situations
> > > > that require urgent, real-time or phone-based interactions or complex
> > > > project analysis and dump analysis issues. Issues of this nature are best
> > > > handled working with a dedicated Microsoft Support Engineer by contacting
> > > > Microsoft Customer Support Services (CSS) at
> > > > http://msdn.microsoft.com/subscriptions/support/de....
> > > > ==================================================
> > > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > >
> > > >

v-wywang

3/28/2008 10:28:00 AM

Hello Jeff,

Thanks for Dave's tip. Odbccomand.ExecuteScalar() should return the bytes
in the first filed. If you found it's null and the length of byte array is
0, this means odbcDataCommand cannot found any byte in underling datatable.

I'm sorry, but it's not possible for me to install Progress database
version 10.0B on my machine. It's a 3rd party product. (I think it's Excel
or Access database before...). We suggest you may check if there is any
binary data in underling database table. odbcdatareader.GetBytes() returns
the actual number of bytes read. If the value is zero, I believe this is
because odbcdatareader cannot read data from table. This shouldn't be a
breaking change...

Hope this helps. If you have any more concern, please feel free to let us
know. We are glad to assist you.
Have a great day,
Best regards,
Wen Yuan

Microsoft Online Community Support
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsoft.com.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

microsoft.public.inetserver.iis

腹の虫素手数える御業本棚全長づく

Marty

davebythesea

Jeff

davebythesea

v-wywang

x Login to ForumsZone