Open SQL 2005 database question

Shoud a SQL 2005 database remain open in a Visual Basic program, or should
it be opened and closed in every subroutine?

Thanks for any info.


.

Relevant Pages

  • Re: light weight, stand alone data solution
    ... database in". ... solution would be to create a subroutine that provided the necessary abstractions. ... I did database programming from 1984 through 1997, ... technology got too expensive to use (SQL, ...
    (microsoft.public.vc.mfc)
  • RE: Using q() to define a query
    ... which will basicaly turn the subroutine into a constant that can be ... instead if inserting the data into the SQL with sprinf. ... and more efficient (allows the database to cache execution plans). ... stored procedures would work even ...
    (perl.dbi.users)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)