Database update

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

Hi,

To update the database I first open a connection, update and then I close
it. Is there way to do this without opening the connection first? Such as
using the DataAdaptor (which manages the connection automatically)? Is that
efficient?

Thanks
Maz.


.

Relevant Pages

  • Re: SQL CE 3.5 and Data Loss on SD Card
    ... with a database on SD card I would be greatful. ... devices we have experienced only one corrupted SDF database. ... I attribute our success to opening a connection just before every DB access ...
    (microsoft.public.sqlserver.ce)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Project ODBC Performance
    ... doing a File Open and Save As when using a MS SQL Server database? ... The problem seems to lie in network utilization or ODBC ... have no issue opening the 5MB file but none of them has been successful ... Is there a way to optimize the ODBC connection between the ...
    (microsoft.public.project.vba)
  • Project ODBC Performance
    ... doing a File Open and Save As when using a MS SQL Server database? ... The problem seems to lie in network utilization or ODBC ... have no issue opening the 5MB file but none of them has been successful ... Is there a way to optimize the ODBC connection between the ...
    (microsoft.public.project.standard_and_server)
  • Re: Function OpenConn
    ... a database connection at all, and therefore don't need to call the function. ... While logic will tell us that opening the connection and closing it as soon ... > function OpenConn() ...
    (microsoft.public.inetserver.asp.db)