Microsoft KB Archive/184016

= XL98: "INTERSOLV" Licensing Error Using SQL Functions =

Article ID: 184016

Article Last Modified on 9/12/2006

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



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:

Download Odbcfix.hqx now

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:  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: kbbug kberrmsg kbfaq kbfile kbfix kbgraphxlink KB184016

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.