Error 42s02 microsoft odbc text

Note If you downloaded a hotfix or an update for the communication components, you must register the. Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section. For more information, click the following article number to view the article in the Microsoft Knowledge Base:.

The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations. Dynamics NAV More Need more help? Expand your skills.

Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Visual C. Sign in to vote. I have only one sheet in the workbook, in this case, it is xlWorksheet Thanks. Create a COM object for everything that is referenced Excel.

It seems Open is not correct here? ExecuteReader ; xlWorkbook. Close false ; xlApp. Quit ;. Thursday, March 28, AM. Hi I have reproduced your problem. You could try the following change. Just always specify the schema - e. Add a comment. Active Oldest Votes. Improve this answer. John N John N 1, 16 16 silver badges 21 21 bronze badges. I was able to connect to Azure Synapse with InitialCatalog but couldn't actually query until I switched the param to Database.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.