Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

When you connect to SAS^reg; ODBC driver from Microsoft Access and you run the query SELECT MIN(MONTH) on SASHELP.PRDSALE or on a Scalable Performance Data Server (SPDS) data set that is directly linked to the ODBC driver, you will receive the following error:

When you use the MIN or MAX functions to perform queries on tables, Microsoft Access attempts to fetch data from the result using the original type of the function target. For example, if you use MIN(SOMEDATE), Access attempts to use the type of SOMEDATE. However, the MIN and MAX functions return numeric results with no format information applied, so the results are returned as double-bytes. If Access requests an unsupported conversion, a failure will occur.

Selecting File ► Get External Data ► Link Tables in Access creates an error. This error might occur because Access asks for metadata about the table and gets the type of the MONTH column as the date (or timestamp).

If you select File ► Get External Data ► Import Tables, Access retrieves all of the data, performs additional operations on the client side, and returns a result without an error.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS ODBC Driver 9.1.3 is available at: