Trouble shooting
- The module mmodbc cannot be initialized: check whether the ODBC driver manager is installed and can be found and accessed by the application (in particular on Unix platforms).
- Missing ODBC driver: the ODBC driver is a separate piece of software (not included in mmodbc) that is sometimes provided directly with the data source (typically the case under Windows), but in general it needs to be installed and set up separately.
- Connection strings should not contain any blanks. (This remark applies, for instance, to MySQL).
- Spreadsheets are not databases.
- Close the spreadsheet file while executing a Mosel model that writes to it.
- Make sure that the file is not opened in `Read only' mode (this may happen, for instance, if several users access the file at the same time).
- Columns in a spreadsheet range are not typed. The Excel driver scans the data in the first 8 rows to deduce the type of the data in every column. The number of rows scanned by the driver may be changed with the option MAXSCANROWS.
- You have to have enough space below the header line to fit in all the values you are going to write. So it is best to have nothing below the range.
- To delete data from a range in an Excel spreadsheet you cannot just delete the entries in the cells (otherwise further data will be added after a blank rectangle). You have to remove completely the data rows and the enlarged range with the sequence Edit » Delete » Shift cells up.
- Insertion failed: check whether a key field is defined and the database table holds already data. Check the structure of the data table (sufficient number of columns, column names, field types). Close the database/spreadsheet before running the Mosel model (especially under Windows).
- Reserved words: Prod, Time, Value, Params etc. Inadvertent use of database keywords (depending on the database) often leads to difficult-to-diagnose error messages. We therefore suggest using longer, problem-specific names or `myProducts', `myParameters', etc. that will not clash with any reserved words. It is also possible to use quotes to indicate that a word should not be interpreted by the database; please refer to the documentation of your database for further detail (quotation characters are database-dependent).
© 2001-2019 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.