I'm trying to get the trial Enterprise version running using MySQL on Dreamhost.com shared server. I've succeeded only partly, and need help filling in the details. Can you please: tell me: Your database file specifies the ANSI character set, but Dreamhost's MySQL installation used Unicode. Should I use the ANSI or UNICODE MySQL ODBC connector? What import settings should be used? Character set: (default is utf8, but I chose latin1) Partial import (default is checked) SQL compatibility mode (default is NONE; I presume this means compatibility with MySQL 5.x. Is your SQL file built for another version instead? The other relevant choices are MYSQL323 and MYSQL40.) [*]Using the above settings, I get these errors once in AssetManage: On launching, after selecting the ODBC driver: DBC--call failed. (3146) GetRows failed. The requested column is not a member of this recordset. (4098) After that, I can interact with the database a little bit, but doing the following in the application results in these errors: Clicking on Main Office results in the same 4098 error above. Add Item launches the dialog box without error, but pressing OK results in the 4098 error followed by "encountered an improper argument". Clicking OK again results in "Update or CancelUpdate without AdNew or Edit. (3020)". That's as far as I've gotten. In setting up the application, I followed the procedures I wrote below. Dreamhost database configuration Shared MySQL servers on Dreamhost have a few limitations that impact setup and usage: v Database creation must be done in Dreamhost Control Panel o From the menu, select “Goodies”, then “MySQL Databases” o Scroll down to the bottom of the page to “Create a new MySQL database”, choosing whatever hostname and user is appropriate for your use, then click the “Add new database now!” button. o Modify the AssetMng.sql file to eliminate the CREATE DATABASE command (which will fail. Delete these lines:: CREATE DATABASE `assetmng2007` CHARACTER SET `latin1` COLLATE `latin1_swedish_ci`; o Database names must be unique on the shared server. If Dreamhost reports that database name is already in use, you will have to change the database name from the default. If you do, change the following line in AssetMng.sql to match: USE `assetmng2007`; AssetManage Enterprise Configuration An ODBC connector (driver) for MySQL must be installed prior to configuring AssetManage for a database. 1. Download the 32-bit connector http://dev.mysql.com/downloads/connector/odbc/ (you will need an Oracle.com account) 2. Install the connector. It will not be visible as a separate application. 3. Install AssetManage Enterprise application 4. Launch AssetManage by right-clicking the application icon and then left-clicking Run as Administrator 5. In the Select Data Source dialog box that appears next, switch to the Machine Data Source tab, click the New button, select the System Data Source radio button and click the Next button. 6. In the Select a driver… list, scroll to the bottom and select “MySQL ODBC 5.3 ANSI Driver? The click the Next button, then the Finish button. 7. In the MySQL Connector/ODBC Data Source Configuration dialog box, enter the following: a. Data Source Name: “ARCBA_DST_ASSETS” b. Description: “ARCBA DST Asset Tracking” c. TCP/IP Server: “mysql.arcba.net” Port: “3306” d. User: “arcba” e. Password: “DST-WB6RC-R@d!0” f. Database: “assetmng2007” g. Click the OK button 8. Back in the Select Data Source dialog box, make sure the entry you just made is highlighted, then click the OK button