Setting Cursortype and LockType

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I am using SQL Server with an existing application. The application is
transferring a large amount of data from a SQL Database to an Access
database (for reporting). The application is using Datasets to move the
data. I was hoping to gain a little more performance by setting the
Locktype, and cursortype but I can't seem to figure out where to set them.
Are these a command property, or a dataset property? What should the syntax
be?

Thanks!
Ron


.

Relevant Pages

  • Re: Total Newbie - Maintainenance of SQL Database
    ... If you are having a consultancy migrate/install this packaged solution then ... > exactly is involved in maintaining/supporting a SQL database? ... > intend to run on SQL server. ... > The only maintenance I do on the Access version is a scheduled nightly ...
    (comp.databases.ms-sqlserver)
  • RE: Event 3760 Error
    ... SQL Database 'STS_TSMAIL_1' on SQL Server instance ... Microsoft CSS Online Newsgroup Support ... <Source: Windows SharePoint Services 3 ... <SQL Database 'STS_TSMAIL_1' on SQL Server instance ...
    (microsoft.public.windows.server.sbs)
  • Re: Questions on a Database with Mass Data
    ... SQL server, how much involvement would I expect from our IT department? ... SQL Server 2005 learning resources (free online videos) ... FE to each BE and let a query to grab the specific data from a specific year ... I also heard that SQL database can handle the massive data. ...
    (microsoft.public.access.modulesdaovba)
  • The need to get around the 4000 character limit in varchar2
    ... I was approached by a developer this morning, who has a SQL server ... The SQL database has a few columns that are varchar columns, ... At this point I know of no way to migrate this data across to Oracle ...
    (comp.databases.oracle.server)
  • Creating/adding column description, not caption
    ... How do I get these descriptions back into my SQL Server 2000 database? ... I've generated the script and have made some changes to the SQL database, ... like changing the data types and sizes. ...
    (microsoft.public.sqlserver.dts)