VB Sql Server Via ADO Problem: [Microsoft][ODBC Sql Server Driver]
I am using ADO to populate a treeview control from database info. I am able
to create recordsets that rely on the value of information from another
recordset. Everything works fine, except for the speed issue (7000 items in
the treeview). To improve performance, I created stored proceedures on the
server to create the recordsets. The performance improvement is dramatic.
The version that does not use the stored procedure simply closes the
recordset on the inside loop, changes the recordset based on the next
iteration of the outside loop, reopens and adds items to the treeview. The
program flow is exactly the same when using the stored procedure on the
server to populate the recordset except that the first occurance of a
value(dim 'd as string) that is encountered greater than 7 characters the
following error is displayed:
RunTimeError'-2147217833(80040e57)':[Microsoft][ODBC Sql Server Driver]
String Data Right Truncated
The variable passed to the stored procedure is received in the procedure
listed:
Create Procedure usp_cat
(
)
Since the error is "Sql Server Driver", I suspect there is some
interpretation problem or conversion problem that is corrupting the variable
contents.
What's the fix??
Mike Byerley