SQL Server Performance

_bstr_t data type length problem

Discussion in 'T-SQL Performance Tuning for Developers' started by mtmingus, Oct 8, 2003.

  1. mtmingus New Member

    Did anyone have problem with this type of data type?
    It is reported that when the system is heavily loaded
    and sqlserver is running like crazy, _bstr_t (returned
    from ADO RecordSet) max it to 500 characters.
  2. satya Moderator

    What was the error?
    Not able to assess from initial question.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. mtmingus New Member

    There is no error - that is even more scary!
    just truncated anything beyond 500 chars.

    quote:Originally posted by satya

    What was the error?
    Not able to assess from initial question.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

  4. satya Moderator

    What was the connection string used?
    How do you control data import/export.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. mtmingus New Member

    Does it have anything to do with the conn string? Here is what we do:<br />...<br />sprintf(connStr, "Provider=SQLOLEDB;Data Source=%s;Initial Catalog=myDatabase;<br />User Id=%s<img src='/community/emoticons/emotion-4.gif' alt=';P' />assword=%s;", dbServer.c_str(), userId.c_str(), password.c_str());<br />myConnPtr-&gt;Open(_bstr_t(connStr.c_str()), "", "", NULL);<br />...<br /><br />I suspect there is a problem when the column myColumn length &gt; 500,<br />string value = (string)(_bstr_t)RecordSetPtr-&gt;GetCollect(myColumn.c_str()) ;<br />will truncate anything beyound 500 chars.<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />What was the connection string used?<br />How do you control data import/export.<br /><br />_________<br />Satya SKJ<br />Moderator<br />SQL-Server-Performance.Com<br /><br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

Share This Page