Maximum handled output from Stored Proc to Grid

  • This is probably not a SQL question, more of a VB question but since this is a greatly talented group of SQL / VB programmers I will post here first.

    We have a stored proc that we are using to return the data from a text column to a grid. In doing this we have had to do a convert(varchar(1000), ColName) to limit the size of the data returned because we can't get the VB app to handle anything greater than 1000. If we go any larger than 1000 then the App returns a 3146 ODBC call failed.

    Anyone seen this or have any suggestions?

    Any help would be appreciated.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • Havent seen it. App breaks or the grid control? Which grid are you using?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • Andy,

    The application breaks. The grid is a FlexGrid v6.

    Thanks

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply