SQLBulkOperations and Cursor Type
This is a discussion on SQLBulkOperations and Cursor Type within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I've built an app that uses ODBC SQLBulkOperations to perform Bulk Updates and Inserts to SQL 2000. The app ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:12 PM
| ||||
| ||||
 SQLBulkOperations and Cursor Type I've built an app that uses ODBC SQLBulkOperations to perform Bulk Updates and Inserts to SQL 2000. The app works, but I'm using the SQL_CURSOR_KEYSET_DRIVEN cursor and I think I can get better performance if I can make it insensitive to the changes it makes. Is there a way to make a keyset-driven cursor insensitive to changes without making it read-only? Or alternatively can I use one of the other cursor types with the SQLBulkOperations API? Thanks      |
 |
« ODBC drivers not listed in SS2005 import wizard
|
Emergency: lost connection to SQL server 2000 instance »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:18 AM.
