Active News 15 Seconds Weekly Newsletter • Complete Coverage • Site Updates • Upcoming Features More Free Newsletters Reference News Articles Code Samples Components Tools FAQ Feedback Books Links DL Archives Community Messageboard List Servers Mailing List WebHosts Consultants Tech Jobs 15 Seconds Home Site Map Press Legal Privacy Policy internet.commerce internet.com IT Developer Internet News Small Business Personal Technology International Search internet.com Advertise Corporate Info Newsletters Tech Jobs E-mail Offers Compare products, prices, and stores at Hardware Central!

Previous Next   email this FAQ to a colleague Q: How do I display all the table of an Access database? A: Here is how to display all the table names in an Access database using ADO: Function ADOOpenSchema() Dim conPubsDB As ADODB.Connection Dim rsSchema As ADODB.Recordset Dim cmd As ADODB.Command Set conPubsDB = New ADODB.Connection Set cmd = New ADODB.Command conPubsDB.Open "DSN=DART;USER=sa;PWD=;DATABASE=pubs", "", "" Set cmd.ActiveConnection = conPubsDB Set rsSchema = conPubsDB.OpenSchema(adSchemaTables) Debug.Print "Record Count" & rsSchema.RecordCount Do Until rsSchema.EOF Resposne.Write("Table name: " &_ rsSchema("TABLE_NAME") &_ vbCr & "Table type:" &_ rsSchema("TABLE_TYPE") &_ vbCr) rsSchema.MoveNext Loop End Function - 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] Apr 7, 2005 - A Step-by-Step Guide To Using MySQL with ASP.NET - Part 2 In the second part of of his article on using MySQL with ASP.NET, Ziran Sun covers how to add a new MySQL user to the database server, assign the user the appropriate permissions, connect to the database, and build a simple ASP.NET page to perform a query. [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] Jan 27, 2005 - Moving a Database from SQL Server 7.0 to SQL Server 2000 Moving or copying a SQL Server database from one machine to another requires a lot of preparation in order to ensure a smooth transfer. In this article, Dina Fleet Berry examines the different methods and highlights the different issues associated with each of them. [Read This Article]  [Top] Jan 6, 2005 - Debugging a SQL Stored Procedure from inside SQL Server 2000 Query Analyzer There are many times when using SQL Server 2000 Query Analyzer to debug SQL statements is a better choice than debugging in Visual Studio .NET. In this article, Dina Fleet Berry explains why and walks you through the debugging process step-by step. [Read This Article]  [Top] Nov 24, 2004 - Persisting .NET Objects to SQL Server Using SQLXML and Serialization As a follow up to his article on retrieving objects from SQL Server using SQLXML and serialization, Gianluca Nuzzo discusses saving objects back to SQL Server using a schema definition file and updategrams. [Read This Article]  [Top] Sep 14, 2004 - Transaction Processing in ADO.NET 2.0 One area that stands out when comparing ADO.NET 1.x to ADO.NET 2.0 is transaction processing. Bill Ryan shows just how easy transaction processing has become with the TransactionScope object in ADO.NET 2.0. [Read This Article]  [Top] Sep 8, 2004 - Custom Object Data Binding with .NET Developers often use brute force coding to marshal data between the GUI and application objects. In this article, Luther Stanton explains how to use .NET's out-of-the box data-binding functionality to make this job much easier. [Read This Article]  [Top] Sep 2, 2004 - Queue MSMQ Messages from SQL Server Learn how to create a console application to queue a message in Microsoft Message Queuing (MSMQ) and then use an extended stored procedure to call the console application from a SQL Server trigger. [Read This Article]  [Top] Aug 30, 2004 - Tuning Up ADO.NET Connection Pooling in ASP.NET Applications Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. This article shows how to monitor the connection pool, diagnose a potential problem, and apply the appropriate fix. [Read This Article]  [Top] Jul 13, 2004 - Retrieving Objects from SQL Server Using SQLXML and Serialization This article will describe how to design a data access layer for a set of entities. You'll learn how to write an XSD schema and design two simple helper classes -- one for reading an XML stream from SQL Server using SQLXML and another for deserializing the XML stream. [Read This Article]  [Top] Jun 30, 2004 - Simplified and Extended Data Binding Syntax in ASP.NET 2.0 Alex Homer discusses the simplification of, and extensions to, the ASP.NET 1.x data binding syntax, the new two-way data binding syntax for updating data sources, and the new syntax for binding to XML data in ASP.NET 2.0. [Read This Article]  [Top] Jun 14, 2004 - Windows Forms Object Data Binding in .NET 2.0 Rocky Lhotka discusses .NET 2.0's new smart DataTable technology and examines Whidbey's RAD support for object data binding in .NET 2.0 Windows Forms. [Read This Article]  [Top] May 18, 2004 - ASP.NET 2.0 Caching Features This article examines some of the new and exciting caching features in ASP.NET 2.0 and shows how to implement them in Web applications. [Read This Article]  [Top] Feb 10, 2004 - Creating Collections for Data Binding and Serialization Thiru Thangarathinam explains how to implement strongly typed collection objects and discusses why they may be the best approach for returning data from the middle tier to an ASP.NET user interface. [Read This Article]  [Top] Jan 27, 2004 - Creating an ADO.NET Universal Data Wrapper Learn how to write a single ADO.NET class that can support any ADO.NET provider at runtime. [Read This Article]  [Top] Jan 12, 2004 - Object-Relational Persistence for .NET Object-relational persistence can provide great benefits to data-based applications in .NET. Scott Bellware explains O/R persistence and examines what Microsoft is doing in .NET 2.0 to facilitate this sparsely used and often misunderstood practice. [Read This Article]  [Top] Dec 23, 2003 - Introducing ADO.NET and the Typed DataSet Thom Robbins explains how DataSet object features can be combined with XML to create a new type of object called the typed DataSet, which simplifies the task of data navigation. [Read This Article]  [Top] Nov 20, 2003 - Efficient Use of an ADO.NET Data Component Frustrated with having to maintain separate Connection objects, DataAdapters, and DataSets in each form? Nathan Zobrist shows how to create and use an application-wide data component. [Read This Article]  [Top] Nov 12, 2003 - Implementing Paging and XSLT Extensions Using XSLT in .NET - Part 2 Part one showed how to transform XML data into HTML by using an XSL stylesheet from within a .NET application. This part explains how to make use of XSLT Extension objects and invoke a C# class method from an XSL stylesheet. [Read This Article]  [Top] Nov 5, 2003 - Implementing Paging and XSLT Extensions Using XSLT in .NET - Part 1 Learn how to transform XML data into HTML by using an XSL stylesheet from within a .NET application, and then implement a paging solution by declaring and supplying paging parameters to the stylesheet. [Read This Article]  [Top] Oct 13, 2003 - A Simpler Way of Getting .NET Objects out of ADO.NET The Matisse post object-relational SQL database is equipped with an ADO.NET extension that returns objects instead of rows and thus eliminates the need for an O-R mapping layer. Benjamin Hautefeuille introduces Matisse, explains how to use its powerful features, and demonstrates how it can eliminate around 25% of an application's code and maintain performance levels as additional rows are added. [Read This Article]  [Top] Oct 7, 2003 - Can I Get That As a Spreadsheet? Bob McLeod shows how to create an object that accepts a dataset with multiple tables and turns them into an Excel workbook with multiple sheets. [Read This Article]  [Top] Sep 9, 2003 - DTS and C# Data Transformation Services (DTS) is a built-in component of SQL Server that provides programmers and database administrators with a way to move data from any source to any destination. Thiru Thangarathinam shows how to invoke DTS packages from a .NET application and explains how the unmanaged DTS SQL Server COM component is used in a .NET application. [Read This Article]  [Top] Aug 27, 2003 - Populating the TreeView Control from a Database Populating the TreeView Web Control from a database allows menu and input trees to change on the fly. Don Schlichting provides an introduction to the TreeView and then provides detailed steps for populating the tree from a database using ADO.NET. [Read This Article]  [Top] Jul 29, 2003 - Porting Unmanaged Legacy C++ Applications That Interact with DB2 Mainframes into .NET/C# Recently there has been a sudden increase in new development projects for migrating existing C/C++ applications written on the UNIX/Windows platform to .NET. This article demonstrates how to manipulate and expose raw data received from mainframes into well-defined managed C++ interfaces using the facilities and features provided by the .NET Framework and managed C++. [Read This Article]  [Top] Jun 23, 2003 - A Primer on Using DB2 with .NET Several companies are tackling the issue of leveraging their investment in DB2 and embracing .NET for some new application development. This is a practical guide to getting started using DB2 from a .NET application developer's perspective. This article will discuss the basics of how to access DB2, what techniques work best, what functionality you can expect, and how to avoid problems. [Read This Article]  [Top] Jun 18, 2003 - Online Database Functions Testing Tool This short article provides source code for a classic ASP online database functions testing application and shows how to configure and use the tool for either SQL Server or Oracle. [Read This Article]  [Top] Jun 4, 2003 - Handling Concurrency Issues in .NET Wayne Plourde focuses on different approaches to concurrency locking and discusses how to handle the situations when they occur. [Read This Article]  [Top] Apr 7, 2003 - Using Object Databases in .NET Traditional relational database management systems (RDBMS) don’t lend themselves very well to object-oriented programming. Matt Culbreth of Intellinet Corporation introduces object databases and explains why they can be a valuable alternative to RDBMSs. [Read This Article]  [Top] Apr 1, 2003 - Creating a Data Access Layer in .NET - Part 2 This is the second part of our series on creating a Data Access Layer (DAL) in .NET. In this article, Wayne Plourde shows how to set up the code necessary for retrieving and manipulating data. [Read This Article]  [Top] Mar 17, 2003 - Creating a Data Access Layer in .NET - Part 1 Wayne Plourde begins his two-part series on creating a robust data access layer in .NET. Before writing any code, it is important to establish goals and setup and secure a database. Part one examines all the ingredients that exist in a professional data access component. [Read This Article]  [Top] Jan 13, 2003 - Using Inline UDFs for Precise Paging Andrew Novick introduces the three types of user-defined functions (UDF) in SQL Server 2000 and shows why inline UDFs are ideal for efficient data retrieval. [Read This Article]  [Top] Sep 19, 2002 - Do Stored Queries Increase the Speed of Access Queries? Marcus Tucker benchmarks various methods of querying an Access database through ASP. He runs a series of tests, using each ADO object, that pit hardcoded dynamic queries against the less familiar Stored Queries. The results may surprise you! [Read This Article]  [Top] Aug 7, 2002 - Using MySQL in the Win32 Environment Developers who don't want to spend a lot of money on SQL Server and who want a database that's more robust than Access may find MySQL to be a pleasant alternative. This introductory article covers the bare essentials for getting MySQL installed and running in the Win32 environment. [Read This Article]  [Top] Aug 5, 2002 - O/R Mapped Object Persistence Is the Boon Mixing object-oriented development and relational databases can poison developer productivity and application quality. Sebastian Ware and Mats Helander concoct a cure using object-relational mapping. [Read This Article]  [Top] Jun 11, 2002 - Strategy for Building a Pluggable Data Access Layer in .NET Creating code to access new data stores can often be a heroic task. Adam Sills shows how to create a simple abstract factory pattern for pluggable data access. [Read This Article]  [Top] May 22, 2002 - Introduction to Relational Databases - Part 1: Theoretical Foundation The first article in this two-part series provides a basic understanding of the theoretical principles of database design and describes some key elements and rules of creating relational databases. [Read This Article]  [Top] Mar 27, 2002 - A Best Practice for Using ADO Objects A few members of the 15 Seconds discussion list talk about the proper way to use methods in order to prevent ADO object errors. [Read This Article]  [Top] Nov 6, 2001 - Writing Your Own Script File to Migrate a Database Learn how to write a script file using SQL Server's Bulk Copy Program for easy and speedy database migration. [Read This Article]  [Top] Oct 9, 2001 - Advanced SQL Techniques - Part 1: Analyzing Duplicate Records In the first of this four-part series, David Penton describes a quick and efficient way to delete duplicate records from a table. [Read This Article]  [Top] Sep 14, 2001 - Charting the Internet Including charts on a Web site is now commonplace, but often these are static and therefore quickly outdated. In this article by Mark Mathieson, we first explore how to create charts generated on the fly from a database, using IntrChart. Secondly, we delve into IntrChart's hot-spot capabilities to dynamically drill down to other pages or charts. [Read This Article]  [Top] Sep 11, 2001 - Randomizing a Recordset Ed Myers' article shows several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. A simple tool is provided for verifying that the results are uniformly random. A technique for bubbling records with certain attributes to the top of an otherwise randomized list is also shown. [Read This Article]  [Top] Aug 24, 2001 - Advanced Form Presentation and Printing w/ PDF, FDF, ASP, and DHTML - Part 3 In the third and final installment of Advanced Form Presentation and Printing, Eric Coffman describes how to separate form presentation in a browser from the way the form prints out without processing the form through a CGI script or other means; everything is handled client-side. Learn how to create pleasing-looking forms without the need for Adobe Acrobat or Adobe Acrobat Reader. [Read This Article]  [Top] Aug 23, 2001 - Advanced Form Presentation and Printing w/ PDF, FDF, ASP, and DHTML - Part 2 In part two of advanced form presentation and printing, Eric Coffman uses the FDF Toolkit ActiveX version to show the versatility of the FDFApp object and demonstrates how to handle a Forms Data Format (FDF) file in a real-world situation. [Read This Article]  [Top] Aug 22, 2001 - Advanced Form Presentation and Printing w/ PDF, FDF, ASP, and DHTML - Part 1 This three-part article by Eric Coffman details the dynamic creation of Adobe Acrobat 5.0 PDF forms with ASP and describes the handling of all the most common form elements. You will be able to connect Adobe Acrobat 5.0 PDF forms to a database and retain, even extend Adobe's acclaimed portability and printability. This is like eating your cake and having TWO left! And if that's not enough, part three describes a method of simulating Adobe's features with CSS level 2's @media features combined with DHTML. [Read This Article]  [Top] Jul 23, 2001 - ADO.NET Code Transitions to New Beta With the release of the .NET Framework SDK Beta 2, Microsoft has made some fundamental changes. One area that has been changed is ADO.NET. This article illustrates these changes so you can move your ADO code from Beta 1 to Beta 2 as simply as possible. [Read This Article]  [Top] Jul 18, 2001 - Interrogating a Stored Procedure with ADO Repetitive tasks are nothing new to a developer. Writing ADO interface code is one of these tasks. In this article David R. K. DeLoveh shows us how to write code to generate code for calling stored procedures in SQL Server 7. [Read This Article]  [Top] Jun 29, 2001 - AddCriteria Simplifies SQL Queries AddCriteria is a short function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. [Read This Article]  [Top] Jun 18, 2001 - ASP AND SQL-DMO - Part 2 S.S. Ahmed's article will demonstrate the usage of the SQL-DMO library to administer the SQL Server remotely. It shows how to create a component capable of creating SQL tasks remotely. Once the task is executed successfully, the task would be deleted automatically. [Read This Article]  [Top] Jun 7, 2001 - Is Paging with Recordsets the Best Method? Members of the 15Seconds discussion list offer ideas on the best ways to collect data for paging. [Read This Article]  [Top] Jun 6, 2001 - Database Connection Optimization Members of the 15Seconds discussion list debate the best methods for connecting to a database while philosophizing about code optimization. [Read This Article]  [Top] Jun 5, 2001 - Integrating Flash with an Access Database In this article, Matt Duckhouse describes how to connect a Macromedia Flash movie to an Access database using an ASP page as the data-transfer mechanism. [Read This Article]  [Top] May 14, 2001 - The Truth About Access When should it be used and when should it not? Members of the 15 Seconds discussion list provide some insight into using Microsoft Access for Web applications. When should it be used and when should it not? [Read This Article]  [Top] Apr 23, 2001 - Integrating User Search with ASP and SQL Server Full-Text Search This article presents sample source code for a user query parser that allows users to submit full-text search queries from ASP to SQL Server 2000. [Read This Article]  [Top] Apr 11, 2001 - Create a Fully Functional, Multifeatured ASP Shopping Basket Many hosted e-commerce Web sites today still rely on their ISPs for shopping cart functionality - at additional monthly fees. This article by Manny Agrinya shows how you can painlessly design and program a multifunctional shopping cart application using standard hosting plan features like SQL Server, ASP, and ODBC. [Read This Article]  [Top] Mar 29, 2001 - Overcome Data Shaping Limitations At some point in their career, most developers have had to create and store a hierarchy of information. Craig Huber will show you a brief overview of ADO Data Shaping and its associated limitations. Then he will explore a solution that overcomes the limitations and supports infinite levels in a hierarchy. [Read This Article]  [Top] Feb 28, 2001 - The Truth About VarChar Read what members of the 15Seconds Discussion list had to say on the properties of SQL VARCHAR. [Read This Article]  [Top] Feb 15, 2001 - The Nature of A Recordset Members of the 15Seconds discussion list clear up some confusion about the properties of ADO recordsets. [Read This Article]  [Top] Feb 9, 2001 - Importing Files into A Database Read what advice members of the 15Seconds Discussion list had to offer on importing files into a database where field 1 contains the filename and field 2 contains the contents. [Read This Article]  [Top] Jan 16, 2001 - Using the TDC to Access and Manipulate Legacy Data Client Side IE provides the perfect tool for accessing legacy data stored in various formats over the Web. Ian Vink shows us how to harness the power of the Tabular Data Control feature. [Read This Article]  [Top] Nov 2, 2000 - Retrieving Dynamic XML from SQL Server 7.0 and 2000 SQL Server is packed with features for retrieving XML documents. Steven Woods offers a demonstration of extending a SQL Query via the RAW, AUTO, and EXPLICIT modes to illustrate the functionality available. The article then discusses the concept of templates, which allow the creation of dynamic parameter-based XML documents, and how templates can be executed via Visual Basic. [Read This Article]  [Top] Oct 30, 2000 - ASP AND SQL-DMO - Part 1: Create a Server Component Encompassing the SQL-DMO Functionality Creating an ASP component to manage SQL Server remotely is fairly easy. It only requires a basic knowledge of ASP, VB, and SQL Server. S.S. Ahmed's article demonstrates how to create a component that harnesses the power of SQL-DMO so you can manage SQL tasks remotely. [Read This Article]  [Top] Oct 25, 2000 - ASP Data Access for Beginners If you're an ASPiring developer looking for a solid foundation in dynamic Web site creation, then look no further. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC). [Read This Article]  [Top] Sep 20, 2000 - How to Display File ACLs on Your Web Page without Active Directory Thought displaying file ACLs on a Web page in a browser was impossible without Active Directory installed? Think again. Through a patchwork of technologies, Larry Schwartz proves otherwise. [Read This Article]  [Top] Aug 31, 2000 - Creating Dependent Select Objects With ASP Select boxes must often communicate with one another (i.e., a Child select object's option values depend on the value selected in the Parent object). Jason Butler details how to create a hierarchy of select objects using ASP, SQL, ADO, and JavaScript. [Read This Article]  [Top] Aug 17, 2000 - Introduction to Transact SQL User-Defined Functions User-defined functions are a new feature in SQL Server 2000. Karen Gayda shows how UDFs can be used to enhance queries and provide functionality that was previously unavailable. [Read This Article]  [Top] Aug 10, 2000 - Calling Stored Procedures From Active Server Pages With a low-level database, offering only basic data storing functionality, SQL code often needs to be embedded in Active Server Pages. With a more sophisticated database, stored procedures can be far more effective. Here's a case study, including code, showing how a database was converted to stored procedures. [Read This Article]  [Top] Jul 14, 2000 - Content Management Made Easy with ASP Automated content management is a must for many web sites. It's difficult to provide fresh new content without a standard automated system. This article discusses how to generate a general submission system, as well as how to manage the work flow, all with examples! [Read This Article]  [Top] Jun 21, 2000 - Keeping Track of Who's In Charge Today Many offices, particularly in military and government organizations, are required to have someone in charge during office hours. If the official manager is absent, that person delegates responsibility to someone else as acting, but who? A Key Personnel Today table shows who is acting in every official position and how to reach them. [Read This Article]  [Top] Jun 8, 2000 - Get Your Data Faster with a Data Cache Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times. In my tests, I've seen as much as a 5000% increase in performance. [Read This Article]  [Top] Mar 23, 2000 - Using an ADO Standalone/Custom Recordset in VBScript Developer Stephan Onisick shows us how to create a standalone/custom recordset and use its organizational ability to perform logical tasks with data without connecting to a database. This article uses a small application written using VBScript, ADO 2.1, and an Excel spreadsheet to record and print computer expenses for tax preparations. The standalone recordset is saved in XML format, and the file can be updated with new data simply by reopening as a recordset and using normal recordset methods. [Read This Article]  [Top] Mar 9, 2000 - SQL Solutions Cindy Cruciger claims there is a better way to write a functional Active Server Page that allows interaction between a database file and the Web, without getting caught in an SQL nightmare. She offers a snippet of SQL code and adds some logical layers, error checking and formatting. [Read This Article]  [Top] Feb 4, 2000 - Creation and Maintenance of Appealing ASP Pages with Dynamically Generated Contents Boaz Sigelman shows how to seamlessly convert between HTML form entry and database storage. The article contains example and code that shows how to use the 1touch component. [Read This Article]  [Top] Jan 31, 2000 - ASP-Oracle Connectivity Using OO4O Selva Kumar’s article shows how to create practical Oracle database connectivity from ASP using Oracle Objects for OLE (OO4O). OO40, the Oracle middleware, allows native access to Oracle from client applications using the Microsoft Object Linking and Embedding (OLE) standard. Sample code is provided. [Read This Article]  [Top] Nov 11, 1999 - Database-Driven WWW Help System The help system presented in Vujosevic and Laberge's article is self contained and can be updated and altered without impacting the original Web application. Much like an online book, the help icon in the Web application dives into an application system for the help option. Each Web page has its own separate help page with a database that contains one row in a table for every calling Web page. Sample code is provided. [Read This Article]  [Top] Oct 21, 1999 - Updating Excel From the Web Bill Jeffries's article on Excel's Web Query tool demonstrates how to update selected spreadsheet cells instantly over an HTTP connection. [Read This Article]  [Top] Apr 15, 1998 - File Repository Weblication using IIS 4.0 In this article Amos El-Roy demonstrates how to create a file repository using ASP pages. A seamless approach that maximizes accessibility and lowers administrative overhead is illustrated in the article's example, which is available for download. [Read This Article]  [Top] May 31, 1997 - Connection Pooling with ASP Connection pooling might be the easiest way to speed up your dynamic web pages reading from SQL Server. Unfortunately, connection pooling within is turned off by default in Active Server pages. Probably because connection pooling is rarely understood in its entirety. This issue discusses connection pooling with ASP, ISAPI, IDC, and Visual Basic applications. Included is a discussion about ODBC 3.0 and the newest bug fix for ODBC. [Read This Article]  [Top] Dec 10, 1996 - ODBC 3.0 Connection Pooling This issue of 15 Seconds contain an example of how to create an ISAPI server extension in MSVC 4.2 with ODBC 3.0 connection pooling. There is also an evaluation of ODBC 3.0, OLEDB, ADO and DAO. [Read This Article]  [Top] Books Working with Active Server Pages Michael Corning, Steve Elfanbaum, David Melnick Teach yourself Active Web Database Programming ... Dina Fleet, Matt Warren, Joyce Chen, Alexander Stojanovic Code Samples Creating a Unique Cookie with SQL Server Using File DSNs Connecting Database on the Fly Number of Recordset(s) returned by a query or stored procedure Making Your SQL Universal Knowledge Base Articles INFO: ODBC Connection Pooling and ADO Q166886 - 1997.06.23 FIX: Repetitive Connect/Disconnect May Shut Dow... Q164734 - 1997.06.23 INF: SQL Logs 17832 With Multiple TCP\IP Connec... Q154628 - 1997.06.23 INF: How to Access SQL Server Within Active Ser... Q169377 - 1997.06.23 INF: Frequently Asked Questions About ODBC Conn... Q169470 - 1997.07.10 HOWTO: Redistributing ADO 1.0 or ADO/R 1.0 with... Q168122 - 1997.08.09 HOWTO: Calling SQL Server Stored Procedures fro... Q164485 - 1997.08.21 HOWTO: Determining How to Define a Stored Proce... Q165156 - 1997.08.21 PRB: Accessing SQL Database Fails on Second Att... Q166659 - 1997.09.06 INFO: Underlying OLE and OLEDB Provider Errors ... Q168354 - 1997.09.23 PRB: ADO Error -2147217896 when Calling MoveFir... Q174225 - 1997.11.17 FILE: ADOVC Demonstrates using ADO with Visual C++ Q174565 - 1997.11.17 PRB: ODBC Error when Passing Date Parameters to... Q174638 - 1997.12.26 PRB: 80020009 Error When Retrieving Data from SQL Q175239 - 1997.12.26 ORA-00000 Error Message with ASP, MTS, and Conn... Q183345 - 1998.06.05 PRB: NextRecordset Fails When Called On A Disco... Q193352 - 1998.10.06 PRB: Missing Parameter Error Running Stored Pro... Q193348 - 1998.10.06 HOWTO: Create a Recordset From a Variant Array ... Q193331 - 1998.10.06 FIX: ADO 2.0 Generates Error 0115 When Used wit... Q193310 - 1998.10.06