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

Download the following file, which corrects the issue described in this article. The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:

Odbcfix.hqx

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center.

To install the updated ODBC file, follow these steps:

Quit Microsoft Excel.

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

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
Version : MACINTOSH:
Platform : MACINTOSH
Issue type : kbbug