This manual was compiled by Project A Web Development as a project supported by Jim Teece. It was written by Ethan Townsend as a documented means of migrating our ADO ASP application, SIB (Site­in­a­box), from Microsoft SQL Server 7.0 to an open source database. SIB is a large database­ driven application that includes many views, stored procedures, and complex SQL executed from the ASP pages.
Read the rest of this entry »

• 0 Comments

The Forest Service has the capability to access data residing in Oracle and other databases with Office 2000. Microsoft Access is part of the Office 2000 suite and has a strong ability to “link” to tables in other databases including Oracle. The purpose of this paper is to explain how to configure a PC for the linkage and illustrate how to make the connection. The primary benefit of using Access to manipulate data is its rich interface to quickly design queries, reports, and forms for data entry.
Read the rest of this entry »

• 0 Comments

There are several ways to import Microsoft Access tables into SAS. They are as follows:
1) Using SAS/ACCESS to ODBC:
1) SAS/CORE, SAS/BASE and SAS/ACCESS interface to ODBC licensed and installed at your site.
2) The Microsoft Access ODBC driver must be installed and configured on your PC.
3) Use the following code to read the Microsoft Access file into a SAS dataset. Libname sasuser ‘c:\foo’;
Read the rest of this entry »

• 0 Comments

The purpose of this white paper is to demonstrate how to use the ODBC driver plugin with Microsoft® Access® database files. This allows LISTSERV® Maestro to use Access databases as a data source, making it possible to have LISTSERV Maestro extract data directly from an Access database [3].
Read the rest of this entry »

• 0 Comments