Tried to import an Excel 2010 spreadsheet (file extension xlsx) into SQL Server 2012 using the import wizard and selecting Microsoft Excel 2007:-
Then I had the following error on my Windows 7 x64 PC:-
SQL Server Import and Export Wizard Error
Additional Information: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)
This is strange as I have Office 2010 x64
Fix: you need to install
the x86 (32bit) Office drivers. This is a simple download from Microsoft called "2007 Office System Driver: Data Connectivity Components".
Url - http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
Had the following error appear on a Visual FoxPro Application running under Citrix:-
Error Number: 1957
Error message: Error accessing printer spooler.
I found out that this error was caused because sometimes FoxPro cannot determine the default printer. So a work around was to use the winspool.drv and force FoxPro to the Default Printer name.
Example code as follows (I am defaulting to Win2PDF if no printer is found as this is installed on all our Citrix clients):-
SET PRINTER TO NAME (cDefaultPrinter)
REPORT FORM "TestReport.frx" TO PRINTER PROMPT NOCONSOLE
DECLARE INTEGER GetDefaultPrinter IN winspool.drv;
STRING @ pszBuffer,;
INTEGER @ pcchBuffer
&&Return default printer name
nBufsize = 250
cPrinter = REPLICATE(Chr(0), nBufsize)
= GetDefaultPrinter(@cPrinter, @nBufsize)
cDefaultPrinter = SUBSTR(cPrinter, 1, AT(Chr(0),cPrinter)-1)
lnPrinterCount = APRINTERS(oPrinters)
FOR lnPCount = 1 TO lnPrinterCount
IF oPrinters[lnPCount,1] = 'Win2PDF'
SET PRINTER TO NAME "Win2PDF"
When issuing a DBCC SHRINKDATABASE or DBCC SHRINKFILE T-SQL Command (or using the shrink option in Microsoft SQL Server Management Studio), it is often nice to find out what the process is doing. You can look at sp_who2
but it mainly just tells you the process is running. I therefore use a simple T-SQL command to view what stage the Shrink File is at:-
percent_complete, [status], wait_type, estimated_completion_time, cpu_time, total_elapsed_time
command in ( 'DbccFilesCompact', 'DbccSpaceReclaim', 'DbccLOBCompact')
The first field Percent_Complete is the most useful, but also check field [Status] is not suspended, if so check field wait_type and see why it is not running.
So you have successfully installed and used the Master Data Services Configuration Manager in SQL Server 2012, but when trying to run the web url you get the following error:-
HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid.
Config Error: Cannot read configuration file due to insufficient permissions.
Config File: \\?\c:\Program Files\Microsoft SQL Server\110\Master Data Services\WebApplication\Web.config
Now the only difference in the setup is I
am using a Network login for the Application Pool that this MDS Web Application uses.
So bascially this error means that Application Pool user doesn't have permission to read the web.config at:-
C:\Program Files\Microsoft SQL Server\110\Master Data Services\WebApplication\Web.config
That is fine, grant it read permission and now we get another error:-
The current identity (AppPoolUser) does not have write access to 'C:\Program Files\Microsoft SQL Server\110\Master Data Services\MDSTempDir'.
OK so again we need to give the Application Pool user write permission to the MDSTempDir directory.
I am using Windows Server 2008 R2 Enterprise but it is boardly the same for most Windows Servers
Open Windows Explorer and locate the folder
Right Click -
Select 'Security' Tab
Click 'Change Permissions...'
Locate the user
And Select 'Full Control' for permissions
Now run your MDS Web Page and it should look something like:-
So you have successfuly installed the Master Data Services Add-In for Microsoft Excel and now you want to connect to your Master Data Services on your Server.
Select the "Master Data" tab in Excel
Create a new connection
In the Add New Connection put in your Web URL from the Server.
If you get the following error:
The connection failed because the URL is not valid or the
Mast Data Manager web application version is not supported.
This is usually because you just need to remove the default.aspx from the Web URL
http://MSDServer:8081/Default.aspx (as seen in IE)
http://MSDServer:8081 (in MDS Excel Add-In)
Simple when you realise this!
Whilst trying to create a new SQL Server Database I had the following error:-
TITLE: Microsoft SQL Server Management Studio
Create failed for Database 'Test'. (Microsoft.SqlServer.Smo)
Could not obtain exclusive lock on database 'model'.
Retry the operation later.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 1807)
Some people suggest disconnecting and reconnecting your SQL Server Management Studio Session, but this did not work for me.
More than likely someone or something is accessing the model database (which might have been yourself hence the suggestion of closing SSMS). So this is the first thing to check, either open Activity Monitor and filter by Database model or just use the following command (in a new query window):-
SELECT * FROM sys.sysprocesses WHERE DB_NAME(dbid)='model'
Check that nothing is using the database, in my case it was because the Standard Full Model Database backups where running and had become suspended on the model database. Shutting this process down or killing the processes (be careful here as
there maybe a geniue reason for the usage) and re-run your create database command.
If you want to be able to search Active
Directory in Windows 7 this is quite easy.
First install the Remote Server Administration Tools for Windows 7 (currently with
Service Pace 1 (SP1)) at:-
The install will looks something like this:-
Once Installed you now need to add this feature.
Go to Control Panel - Programs
Under "Programs and Features" select "Turn Windows Features on or Off"
Scroll down and expand "Remote Server Administration Tools"
Expand "Role Administration Tools" and select all under "AD DS and AD LDS Tools"
Click OK and these will install.
Now under Start Button - All Programs - Administrative Tools you will have some new programs. The main one to use is "Active Directory Users and Computers".
I needed to de-compile an old .Net EXE that we didn't have the source code for (yes I know it should have been in the Source Control software, but a previous employee who was my boss didn't do this).
So I had the free version of .Net Reflector and noticed that you can get a extension to re-build a project and de-compile the EXE. Excellent but how
do you get it to work.
First if you do not have .Net Reflector then please find the free version, I am using version 6
Next download Reflector.FileDisassembler, remember to match the versions - I used this website to download http://www.denisbauer.com/Home/ReflectorFileDisassembler
Extract .Net Reflector to a directory
Extract Reflector.FileDisassembler to the same directory
Start Reflector (Run as Admin) and you see something like
From the View Menu - Select Add-Ins
Select Add and add the Reflector.FileDisassembler.dll
Close this form
On the main screen, File, Open and find the EXE you want to de-compile
Select the file on the Main screen
Then Tools - Select File Disassembler (ignoring the top
menu item disassemble)
A new screen will be displayed and this will let you build a new project.
Had another strange SharedPoint issue when trying to edit the front page of our
WSS 3.0 SharePoint Web Site.
Clicked Site Actions
Clicked Edit Page
Clicked Edit dropdown on the Web Part I wanted to change
Hmmm - where did "Modify Shared
Web Part" go?
Checked permissions - yep had sufficient rights. So what could it be?
I was using IE9, and noticed before it does some weird things so put it into Compatibility mode - and bingo working again!
I had a Visual Studio 2012 Database Project along with my Visual Studio Asp.Net Project
for storing my Stored Procedures in TFS. However whenever I tried to Build my Project I kept getting Error 2 SQL70001: This statement is not recognized in this context. I had made sure that my Database Project wasn't included in the build process so why was I getting these errors. I then took a look at the properties of the Stored Procedures and noticed the following:-
The Build Action was set to Build!
So the fix was fairly easy, just change to None:-