| home |  |
resources | |
asp tips | |
data access components (mdac) |
tips menu | printable single page version
Note: this is my old ASP tips page and is no longer supported. See the new Visualize web site..
As a starting point, keep any eye on the Microsoft data access site at http://www.microsoft.com/data, and consider installing the latest versions of drivers when needed. The new drivers may well fix many of the problems you have been recently having (of course, they may well also introduce some new ones at the same time! Thorough testing is the only safe approach).
Note. Later versions of MDAC moved towards a more standard ANSI SQL syntax, hence you may well find that on upgrading, some of your old MS Access SQL statements that do not follow the ANSI format, will provide unpredictable results. For example:
DISCLAIMER: Note these pages are a free resource for anyone wishing to reference them. Although every care is taken to ensure their correctness, the author takes no responsibility for any errors or problems that may occur through their use, or indeed misuse. These pages are copyight of Dave Clarke, Visualize Software Ltd 1997-2000 (all rights reserved).
IIS/NT Tips - Data Access Components/ODBC drivers
It is important to keep tabs on the latest drivers that are used to handle all the backend database connections. For example, later versions of MDAC (Microsoft Data Access Components) introduced improved features, including connection pooling.
WHERE fieldname = NULL
would work fine with older drivers, but under the new ones, will probably return an empty recordset. Instead use the correct syntax of:
WHERE fieldname IS NULL
© Copyright Dave Clarke, 1996-2008