XL98: "INTERSOLV" Licensing Error Using SQL Functions (184016)



The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition

This article was previously published under Q184016

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

Download the following file, which corrects the issue described in this article. The following file is available for download from the Microsoft Download Center:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

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.

Modification Type:MinorLast Reviewed:9/12/2006
Keywords:kbbug kberrmsg kbfile kbfix kbGraphxLink KB184016