|
email this FAQ to a colleague
Q:
How do I turn on Connection Pooling from within Visual Basic?
A:
Private Declare Function SQLSetEnvAttr Lib "odbc32.dll" (ByVal henv As Any, ByVal Attr As Long, ByVal ValPtr As Any, ByVal StrLen As Long) As Long
Private Const SQL_ATTR_CONNECTION_POOLING As Long = 201
Private Const SQL_CP_OFF As Long = 0
Private Const SQL_CP_ONE_PER_DRIVER As Long = 1
Private Const SQL_CP_ONE_PER_HENV As Long = 2
Dim ReturnCode As Long
ReturnCode = SQLSetEnvAttr(vbNullString, SQL_ATTR_CONNECTION_POOLING, SQL_CP_ONE_PER_DRIVER, 0)
- Wayne Berry
|
Articles
|
|
Sep 15, 2005 - Building an Image Keyword System
|
|
|
Unlike text-based file formats image files aren't made up of words, which makes searching for an image file by keyword difficult. Instead of being able to simply open the file to see what it contains, we're stuck looking at the text around it and other metadata to determine the image's meaning. In this article, Ziran Sun shows you how to build a simple database-based image keyword system that allows you to associate keywords with images and use these keywords to make finding images easier.
[Read This Article] [Top]
|
|
|
|
|
|
Feb 10, 2005 - A Step-by-Step Guide To Using MySQL with ASP.NET - Part 1
|
|
|
Back in the days of classic ASP, if you were building a database-driven
web site, your choice was either to invest a lot of money to get a copy of Microsoft SQL Server
(or some other enterprise-ready database) or invest a lot of time finding a way to deal with the
performance and scalability limitations of Microsoft Access. Luckily these days there's
another viable alternative: MySQL.
[Read This Article] [Top]
|
|
|
|
|
|
|
