If yes, then following the instructions below[ref]Please ensure you test any script taken from my website on a test/development machine, before running on a production server.[/ref], from MSDN (http://msdn.microsoft.com/en-us/library/ms179254.aspx): Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them. See my note below Export […]
If you are trying to install SQL Server 2005, and receive an error regarding the SQL Server Native Client package being missing, go to your “servers” install CD/folder, and right-click on the sqlncli.msi file, and click on Uninstall. Once uninstalled, just re-run the setup again, and it should install successfully.
I was in the middle of writing an application to retrieve the list of Access Database Tables, but I was getting the error “The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine.” I discovered, that as I was using Vista x64, I needed to change the “Advanced Compiler Options” in Visual Studio to target […]