codetoad.com
  ASP Shopping CartForum & BBS
  - all for $20 from CodeToad Plus!
  
  Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM 
Search Site:
Search Forums:
  ADO Connections  wotrac at 22:53 on Saturday, April 10, 2004
 

Hi Folks

I am a novice programmer who needs a bit of direction.
I am developing an application which will query a SQL
database and retrieve a list of stock codes, which will be used to populate a list box.
This routine will be performed several times, while the application is opened, but may return different result sets based on the users requests.

Question?

Should I open a recordset every time I need to query the database and close it when finished, or are there any other
alternatives.

eg What is connection pooling etc?


Thanks









CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums
//








Recent Forum Threads
•  Re: Security - Code verify
•  Job @ EarlySail
•  Job @ EarlySail (perl)
•  IPC problem
•  Re: import contacts of msn/yahoo
•  Cookies and Threads C++
•  right justify a background in a table?
•  Help with Loop (C++/MFC)
•  Help with Loop (C++/MFC)


Recent Articles
ASP GetTempName
Decode and Encode UTF-8
ASP GetFile
ASP FolderExists
ASP FileExists
ASP OpenTextFile
ASP FilesystemObject
ASP CreateFolder
ASP CreateTextFile
Javascript Get Selected Text


© Copyright codetoad.com 2001-2007