Dave's Technophorical Times

A blog about Microsoft's Technologies!
SharePoint :: MVC :: ASP.NET :: IIS :: SQL Server :: Visual Studio :: MS Access

If you use Tortoise SVN and notice that the overlay icons are not showing then it probably due to the fact that you have not configured Tortoise SVN to use Network Drive. By deault, this is disabled. To switch it on goto Tortoise SVN Settings. Select Icon Overlays and check the Network drives box. Click ON and Refresh your Windows Explorer.


OR What this guy said http://www.sitepoint.com/missing-tortoisesvn-file-status-overlay-icons/

For many Windows-based developers, Subversion and TortoiseSVN is a great source control solution. It’s free, is regularly updated, works on most versions of Windows and integrates well within the OS. TortoiseSVN will be one of the first systems developers install after upgrading to Windows 7.

Tortoise normally shows an overlay icon on every version-controlled file to indicate whether it has been added to the SVN repository, is new, modified, etc. While it may not be absolutely essential, the overlay offers a quick view of the current project status.

Tortoise icon overlays

Unfortunately, Windows Tortoise users can encounter an issue where the file overlays disappear. It’s not an issue specific to Tortoise and it can affect any application which adds several icon overlays. The problem is caused by the number of overlays permitted in different versions of Windows. Vista 32-bit appears to support 15 overlay types, whereas Windows 7 64-bit supports 11. Installing a program which adds its own icon overlays can therefore disable them in another application.

Windows registers 3 icon overlays (this may differ between versions). Tortoise registers another 9. Dropbox registers 3 and will re-install them if they’re missing when the application is restarted. So Windows 7 64-bit users will only be able to view Tortoise icons if at least 4 (non-Dropbox) overlay types are removed from the system.

Here be dragons!
The fix I’m about to describe involves tampering with the Windows registry. It’s dangerous and one false move could trash your Windows installation!

If you’re willing to take the risk, fire up the Windows Registry Editor (regedit.exe) and navigate to: HKEY_LOCAL_MACHINE SOFTWARE Microsoft Windows CurrentVersion Explorer ShellIconOverlayIdentifiers

Export the branch as a .reg file — this will allow you to restore the old settings should anything go wrong.

You will see the Tortoise and other icon overlay identifiers as sub-branches. You can delete unnecessary icon overlay types by right-clicking a branch and selecting Delete:

registry editing

Choosing which overlays are unnecessary is your decision and will depend on your requirements. There may be overlays for applications you do not use or have uninstalled. I removed the TortoiseLocked and TortoiseReadOnly types because I rarely use those SVN facilities. You could also delete the lesser-used Windows Offline Files and SharingPrivate.

Once you’re done, reboot Windows and check whether the Tortoise icon overlays have reappeared.

The version of Windows you’re running will determine how many branches you need to delete. If in doubt, remove one at a time, reboot and check.

I was recently given the task of copying a Web Application from one machine to another. It seemed like a simple task so I began by pulling a backup using stsadm, then thought I could simply do a restore into a web app that I had just created on the other box. It seemed simple enough but I ran into a version issue as shown here. One thing to note here is that I was going from 32-bit (Win 2003) to 64-bit (Win 2008 R2), however I don't think that really matters in this instance.

Interesting. So I went to Central Admin. Operations->Servers in Farm on the destination box and said it was version Not the version I need!

I then discovered this site, well my partner in crime, Rod, found it: http://sharepointingitout.blogspot.com/2008/12/sharepoint-2007-version-numbers.html

I proceeded to download KB2553022 which was the one I needed as I'm running WSS 3.0. Once you get to the download just click on the View and request hotfix download as shown here.

I had to fill in my e-mail address etc and then I got the link for the download. It took about 5 minutes to install. I then had to re-run SharePoint.exe to Repair my set-up as the install appeared to take offence to my SharePoint installation as I couldn't open CA or the web app after the install. After I did the Repair I then rebooted and ran the SharePoint Products and Technical Configuration Wizard after it came back up.

That was it, I then opened up CA again and now I have version and the restore WORKED!



If you are working with SQL Stored Procedures and Functions, it's simple to add the db_owner role to your own login. However, when you want to release your database to a production environment you really want to take away the db_owner role as it has the ability to add, edit and remove database objects in a production environment. The proper way of assigning permissions is to give the user\group in question db_reader and db_writer privilages ONLY and remove the db_owner role. You then need to GRANT the user\group EXECUTE permission on all the Stored Procedures.

To do this you may need to run the following script in order to generate the script so this may be done quickly rather than applying the permission one by one. Once run, simply copy the results to a new window and Execute all lines.

DECLARE @User varchar(50)
SELECT @User = '[domain\userid]'

SELECT 'GRANT EXEC ON ' + name + ' TO ' + @User
FROM  dbo.sysobjects
WHERE type IN ('P', 'FN')
AND category = 0

OR if you want to GRANT to PUBLIC

DECLARE @User varchar(50)

SELECT 'GRANT EXEC ON ' + name + ' TO ' + @User
FROM  dbo.sysobjects
WHERE type IN ('P', 'FN')
AND category = 0

This link had more details regarding the objects you might need to query.

I came across this error message when searching my SharePoint Foundation Site. I had already configured the Search and it is working so this message caught me off guard. Luckily I was able to find a quick solution for it before my demo that afternoon. 

To resolve this issue go to Central Admin. Under Application Management, click on Manage Web Applications, then click on Service Connections in the Manage section of the Ribbon. 


You may notice that it opens with the [default] settings that are all selected.


Click on the list and select the configuration you need to update. In this case it's the [custom] configuration.
Then simply click on the Search Service Application check box and click OK.

That's all there is to it, so hopefully this post will help someone else out there.


I had some issues with my Outlook 2003 Calendar at the office and had to create a new Calendar and remove the original one. I then discovered that the Reminders stopped working so this is what I did to correct that issue.

  1. Archive the Calendar using today's data as the 'older than' criteria, using File->Archive
  2. Shutown Outlook via File->Exit.
  3. Run the following Commad via Start->Run. outlook /CleanReminders.
  4. Shutown Outlook via File->Exit.
  5. Run the following Commad via Start->Run. outlook /ResetFolders.
  6. Done! The reminders sprung back to life.

Enjoy! I hope was helpful for someone out there!

While crawling SSL enabled web applications in SharePoint 2010, it may fail giving the following error.

Error message: An unrecognized HTTP status was received. Check that the address can be accessed using Internet Explorer. (WebExceptionStatus TrustFailure The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

This happens mostly when we implement self signed certs or certs from untrusted authorities in the web servers. In order to avoid the error message and to successfully crawl contents, make the following changes in farm level search settings in Central Administration.

  1. Go to Application Management > Search Service Application Settings > Farm Search Administration
  2. Change the setting “Ignore SSL warnings” from No to Yes.

Installing Microsoft SQL Server 2008 Management Studio Express

Microsoft SQL server 2008 Management Studio Express offers management tools for Microsoft SQL Server 2008 Express, Express with Advanced Services and Compact editions. If your database is hosted on an SQL 2005 Express server, install Microsoft SQL Server Management Studio Express. SQL server 2008 Management Studio Express runs on Windows 7, Windows Vista service pack 1 and Windows XP service packs 2 and 3, Windows server 2003 service pack 2, Windows server 2008 and Windows Server 2008 R2.

This article includes instructions for installing all of the necessary prerequisites. Each installation will be different depending upon the operating system, patch level and previous software installations on the computer. You must log in to the computer with administrative rights to install software.

Install Windows Installer

  1. Download the appropriate installation file for your version of Microsoft Windows from the Microsoft Download Center.
  2. http://www.microsoft.com/download/en/details.aspx?id=8483 is the 4.5 Installer for SQL 2008 Studio!
  3. Open the Windows installer file.
  4. Click “Next” when presented with the “Software Update Installation Wizard.”
  5. Select the option beside “I agree” to answer the licensing agreement query.
  6. Click the “Next” button.
  7. Press “Finish.”

Install the .NET Framework

  1. Download the current version of the .NET Framework for your operating system from the Microsoft Download Center.
  2. Open the .NET Framework installation file.
  3. Select the option button for “I have read and accept the terms of license agreement” to agree to the licensing terms.
  4. Press “Install.”
  5. Click “Exit” when the message that the setup has completed appears.

Install Windows PowerShell

  1. Download Windows PowerShell for Windows XP or for Windows 2003 Server from Microsoft's download center.
  2. Execute the Windows PowerShell setup file.
  3. Click “Next” in the Software Update Installation” window.
  4. Select “I Agree” to accept the licensing agreement. Click “Next.”
  5. Press “Finish” when the installation has completed successfully.

Install Microsoft SQL Server 2008 Management Studio

  1. Download Microsoft SQL Server 2008 Management Studio Express from the Microsoft Download Center.
  2. Double-click the Microsoft SQL Server 2008 Management Studio Express executable file.
  3. Choose “Installation” in the SQL Server Installation Center window.
  4. Click on the link to “New SQL Server stand-alone installation or add features to an existing installation.”
  5. Check for warnings and errors in the “Setup Support Rules” pane.
  6. Resolve any failures before clicking the “OK” button.
  7. Click “Install.”
  8. Check for warnings and errors in the “Setup Support Rules” pane.
  9. Resolve any failures before clicking the “Next” button.
  10. Select “Perform a new installation of SQL Server 2008.” Click “Next” and “Next.”
  11. Check the box beside “I accept the license terms.” Click “Next.”
  12. Check the box beside “Management Tools – Basic” beneath the shared features.
  13. Click “Next” and “Next.”
  14. Accept the defaults in the “Error and Usage Reporting” screen and click “Next.”
  15. Select the “Next” button and click “Install.”
  16. Click “Next” and “Close” when you see the message that the setup process is complete.

Microsoft SQL 2008 Server Management Studio Express simplifies management of SQL 2008 Server Express and Compact editions. Authorized users and administrators can run scripts, create tables, assign rights, schedule backups, replicate, shrink and restore databases from the Object Explorer window. While a long process, installation of the prerequisites and the software will save you time and effort when administering your SQL databases.

Copyright from Maria Montoya’s suite 101 site: Installing Microsoft SQL Server 2008 Management Studio Express | Suite101.com

If you want to switch on the Trace log for MSAccess linked tables to SQL Server then set the following registry key to 1. If you can't see the key then create a new REG_DWORD key and set the value to 1. The log file will be called sqlout.txt and it will be produced in the Default database folder as indicated in MSAccess Tools->Options->General->Default database folder.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC] TraceSQLMode

Hope this helps! Also don't forget to switch it off when you don't need it.

When I was trying to deploy the SharePoint 2010 Web Part on a server using PowerShell, I got this error when I tried to run the Install -SPSolution command saying that:

Install-SPSolution: Admin SVC must be running in order to create deployment timer job

So all I needed to do was to go to the Services and look for the service called SharePoint 2010 Administration. It woill not be running so I switched it to Automatic and then started it. Then I was able to re-run my Installation script!

This is how to list all Tables and Fields in an Access Database Project (ADP).

Option Compare Database
Option Explicit

Public Sub ListTablesAndFieldsADP()
    'Reference is needed for: Microsoft ADO Ext. 2.x for DDL and Security
    Dim cat As New ADOX.Catalog 
    Dim tbl As ADOX.Table       
    Dim col As ADOX.Column       
    Dim fs As Object
    Dim output As Object

    Set fs = CreateObject("Scripting.FileSystemObject")
    Set output = fs.CreateTextFile("c:\Tables_Views_And_Fields.txt", True)
    Set cat.ActiveConnection = CurrentProject.Connection
    For Each tbl In cat.Tables
        If Left(tbl.Type, 6) <> "SYSTEM" Then
            output.WriteLine tbl.Name & " (" & tbl.Type & ")"
            For Each col In tbl.Columns
                output.WriteLine "  " & col.Name
        End If
    Set col = Nothing
    Set tbl = Nothing
    Set cat = Nothing
End Sub

The Blogger

Dave Stuart I'm a Developer with a passion for coding. I enjoy the challengers that come with the job! SharePoint is one of my expert areas along with .NET Web Development with MVC and good old MS Access VBA coding. I Blog so that I can remember how I did that way back when; PLUS all this stuff is searchable! I constantly study and run my own business, Dafran Inc. I have passed 22 Microsoft Exams since 1998 when I first jumped on the treadmill of knowledge. I hope that you enjoy this Blog as much as I enjoy updating it. All the very best from Calgary, Alberta, Canada. contact me at linkedin @ dafran.ca


<<  March 2020  >>

View posts in large calendar

Sign in