Welcome to Portfolio 7.0.4 SQL Connect for MySQL! 

Portfolio 7 SQL Connect allows large and small workgroups to store their Portfolio database information in a popular database format for easier customization and integration.

README CONTENTS

(A) System Requirements
(B) Installation Information
(C) Technical Support Contact Information
(D) Serialization/Registration Information
(E) Compatibility and Technical notes on Portfolio 7 SQL Connect


(A) SYSTEM REQUIREMENTS
_________________________________________________________

Portfolio SQL Connect for MySQL requires:

Macintosh G3 (G4, G4 Dual, or faster, recommended)
1GB RAM

OS X 10.2 or 10.3

MySQL 4.1.3 (or higher)
MyODBC 3.51.6 (or higher)


(B) INSTALLATION INFORMATION
___________________________________________________________

MySQL server and MyODBC should be installed prior to installing Portfolio 7.0.4 SQL Connect for MySQL. These can be downloaded from http://dev.mysql.com/downloads/.

The Portfolio 7.0.4 SQL Connect for MySQL installs required files into the Portfolio 7 Server directory structure.  The Portfolio 7 Server should be installed prior to installing SQL Connect. The following files are added:
	Services/Portfolio SQL Service
	Portfolio Server Files/create_script_mysql.sql

Please see the Portfolio Server User Guide for detailed installation instructions for Portfolio Server, Portfolio SQL Connect and MySQL.
	

(C) TECHNICAL SUPPORT CONTACT INFORMATION
___________________________________________________________

To reach us for technical support questions:

Web/email: http://www.extensis.com/support/

For customer service please use one of the following methods:

Web/email: http://www.extensis.com/customerservice/
Phone: (800) 796-9798


(D) SERIALIZATION/REGISTRATION INFORMATION
_____________________________________________________________

After installing Portfolio 7.0.4 SQL Connect for MySQL, you will need to serialize the product. In the Portfolio 7 client, choose File > Administer Server and click Serialize.


(E) TECHNICAL NOTES FOR PORTFOLIO SQL CONNECT
_____________________________________________________________

For optimal performance, it is recommended that the Portfolio client and Portfolio Server be installed on different machines.

SQL Connect:
When switching a served SQL catalog from level based security to user based security, the Portfolio Server must be restarted before any users can connect to the database as an Administrator.

When items are deleted from a catalog, all of their keywords remain in the catalog.  Extensis provides a script that removes unreferenced keywords upon request. Please contact technical support for more information.

We have implemented a performance workaround to the MySQL implementation of row counting which indirectly updates the items count field at the top of the gallery window every 30 seconds.  As a result, performance is much improved but there is an up to a 30 second delay in updating the items count in the user interface when adding or removing items from a catalog.


(c) 2004 Extensis, Inc., a Celartem company. This document and the software described in it are copyrighted with all rights reserved.