Introduction to Database Support
This section assumes that you are familiar with CopiaFacts scripting and database programming. The CopiaFacts reference manual contains a complete description of scripting commands along with a number of examples. The sample scripts shown within this document will be used to illustrate the database access features of CopiaFacts. You should refer to the reference manual for a more in depth discussion of any scripting commands not discussed here.
In order to use the database DLL, you must have at least MDAC version 2.5 running on the CopiaFacts server. This version is included as a standard part of Windows 2000 and is normally installed with Microsoft Office 2000 or Internet Explorer 5. You may be able to run with earlier versions as well. We have not tested with earlier versions. However, we do not (at this time) use any features of ADO that rely on version 2.5 specifically. If you need to upgrade your system, you should visit the Microsoft site at http://msdn.microsoft.com/en-us/data/aa937730.aspx.
You will also find the component checker that may be used to check your system to determine what version of MDAC you have installed and whether there are any incompatibilities between components. The checker has also been known to silently fix some problems even when it reports no errors. You may also need to download a separate upgrade of the Jet service provider if you upgrade to MDAC 2.6. Refer to the discussion about the Jet provider on Microsoft's site. We use the Jet provider for database access to Microsoft Access, FoxPro, dBase, Paradox, Outlook, and Exchange. You may also need this for access to XML and ADSI databases. The Jet provider is still a part of MDAC 2.5 and is usually a part of a Microsoft Access installation as well.
When CF8DATABASE.DLL is loaded, COPIAFACTS automatically acts as if you have enabled the run-time option Support COM in DLL, whatever the state of the corresponding checkbox . Since ADO is a COM technology, this is always needed.
The FFTESTDB utility is provided to test the operation of Database functions.