XL98: "INTERSOLV" Licensing Error Using SQL Functions

ID: Q184016

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you run a Microsoft Visual Basic for Applications macro in Microsoft Excel 98 Macintosh Edition, you may receive one or more error messages that are similar to the following:

   Warning

   [INTERSOLV][ODBC dBase driver]You are not licensed to use this INTERSOLV
   ODBC Driver under the license you have purchased.  If you wish to
   purchase a license for use with this application, then you may use this
   driver for a period of 30 days, during which...

CAUSE

This problem may occur if you use any of the following functions in your Visual Basic macro to use an external database:

   SQLBind
   SQLExecQuery
   SQLGetSchema
   SQLRequest
   SQLRetrieve
   SQLRetrieveToFile

RESOLUTION

The following file is available for download from the Microsoft Software Library, and corrects the issue described in this article:

 ~ ODBCFix.hqx (size: 66426 bytes)

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

To install the updated ODBC file, follow these steps:

1. Quit Microsoft Excel.

2. Use an appropriate program to decode and decompress the add-in.

3. Copy the Excel ODBC Support Library file to the following folder:

      Microsoft Office 98:Office:Excel Add-Ins:Msquery

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

When you receive the error message described earlier, click OK to allow your macro to continue.

Additional query words: XL98

Keywords          : kbfile kbdta xlvbainfo xlmac kbfaq
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbbug
Solution Type     : kbfix

Last Reviewed: January 7, 1999