When I select a table to query I receive the error " The query cannot be executed because some files are either missing or not registered. Run setup again to make sure the required files are registered." I am running XP Pro on the desktop. This is the path that I select: Enterprise Manager - SQL server to attach to - select the database - select the table - select to query all rows. The odd thing about this is that it was working fine on Friday & on Monday it doesn't work. I have uninstalled & reinstalled the MDAC. Did not correct the problem.
Hope this isn't too painful, but if you have a restore point prior to flameout, you can use the system restore app in XP to bring your system back to where it was. You'll lose any programs you've installed
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful.
Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…