Very Computer

1. 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

2. 128k wireless internet connections

3. Microsoft SQL-DMO (ODBC SQLState:42000) [microsoft] [odbc sql server driver] [sq

4. lTrim or ???

5. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error

6. full screen editor??

7. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]

8. does anybody knows ???

9. what is ODBC ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error 23

10. Problems querying SQL 7.0 Linked Server using ODBC Text Driver

11. 23000: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint

12. Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be tru