ODBC drivers vary a great deal. If you experience any difficulties connecting to the database, the first thing to check is that you are using the latest ODBC driver available for your database.
With the exception of the last one (which only pertains to Oracle) all of the notes below have been verified using Microsoft Access. There is a chance that your ODBC driver might be more (or less) restrictive.
Missing values are indicated by whatever rules are used by the native database. Every database recognizes the distinction between zeroes and missing values. If you want, you can encode leading and trailing missing values as zeroes. In that case you must make sure that “Ignore leading zeros” and/or “Ignore trailing zeroes” is selected on the Format tab of the Settings Options dialog box.
Table names and variable names should begin with a letter and should not include blank spaces.
If you are not using attribute fields each variable name must be unique.
If you are using attribute fields to define product groupings within a hierarchy, each variable name within a given group must be unique.
Oracle Users: Some Oracle drivers will only work if the Hist_Value field is defined as FLOAT (not NUMBER). All other numeric fields can be NUMBER with the decimal places set to zero.