Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SQLDTS2000
- Content: Threads
- Order by date
-
Dynamic Stored Procedure in SQL 2000
Hi, I'm using dynamic SP which looks something like this create sp_select @var as declare @sqlstatement select @sqlstatement = 'select ' + @var + 'convert(char(10), coalesce c.city, '') + coalesce(c.address, ''))' +...- SQLDTS2000
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
VB 6 SQL driver change to Sybase ASE Driver Multiple step OLE DB error
Hi, I change the connectionstring by using Sybase driver instead of MS SQL. But I've an error occurred which says "Multiple-step OLE DB generated errors. Check each status value." The program was running with no errors encountered when the SQL driver was used but when it was...- SQLDTS2000
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
SQL change to Sybase connection (Visual Basic 6 ) error appearing
Hi, I change the connectionstring by using Sybase driver instead of MS SQL. But I've an error occurred which says "Multiple-step OLE DB generated errors. Check each status value." The program was running with no errors encountered when the SQL driver was used but when it was...- SQLDTS2000
- Thread
- Replies: 1
- Forum: Sybase: Adaptive (SQL) Server
-
ExecuteSQLTask (what is the max length of SQLStatement)
Hi, I've tried typing 1000 insert statements (e.g. 1000 statements of insert #temp_tst values '111111') in 1 ExecuteSQLTask that connects to a Sybase ASE ODBC Driver (Other ODBC Data Source). During run time upon clicking the Execute package it appeared that only 61 rows was inserted into...- SQLDTS2000
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
