Database Connector Error (8.5 to 11 conversion)

[Former Member]

<p><span class="PSEDITBOX_DISPONLY"><font size="2">HELP!!!! </font></span></p><p><span class="PSEDITBOX_DISPONLY"><font size="2">Getting this Error Message when trying to set datasource location to a stored procedure on the SQL Server 2000 Database Connector Error:&#39;42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid length parameter passed to the substring function. [Database Vendor Code: 536]&#39; </font></span></p><p><span class="PSEDITBOX_DISPONLY"><font size="2">One of the parameters is a string of 143 ch. (worked perfectly fine in Crystal 8.5) - I&#39;ve looked at the knowledge base, there has been a hot fix for this in V. 10 </font></span></p><p><span class="PSEDITBOX_DISPONLY"><font size="2">Alex</font></span> </p>

[robert_horne · Accepted solution]

<p>Did you convert your reports to version 11 format? </p><p>Are you passing this in as a number or a string?</p><p>I couldn&#39;t find anything. <br /></p><p>Rob Horne<br /><a href="/blog/10">Rob&#39;s blog - http://diamond.businessobjects.com/blog/10</a></p>;