Archive | Computer Misc RSS feed for this section

How to check version of odbc

12 Mar

To check for correct version of odbc, below is how to access odbc on Windows 64 bits:

  • odbc 32 bit
    • c:\windows\SysWOW64\odbcad32.exe
  • odbc 64 bit
    • c:\windows\System32\odbcad32.exe

 

 

You can also check what verson of odbc are installed by going to:

  • odbc administrator – drivers tab – check if 32/62 dll are installed for the different sw (e.g Oracle, sql server)

 

Read more:

https://community.oracle.com/message/10839853

http://www.connectionstrings.com/download-oracle-11g-release-2-client-odbc-drivers/

http://www.simba.com/wp-content/uploads/2010/10/HOW-TO-32-bit-vs-64-bit-ODBC-Data-Source-Administrator.pdf

 

 

 

Error while opening Excel in Sharepoint2010

3 Feb

If you get error

‘Unable to process the request. Wait a few miniutes and try performing this operation again”

you need to edit the file

‘C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML’

Remove/comment out lines containing xls/xlsx

<Mapping FileExtension=”xlsx” RedirectUrlTemplate=”/_layouts/xlviewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate=”/_layouts/xlviewer.aspx?new=1″/>

 

Reset IIS with through e.g command prompt:

iisreset /restart

Read more

http://sharepoint2010tutor.blogspot.no/2011/11/unable-to-process-request-while-opening.html

http://sharepoint.stackexchange.com/questions/64795/excel-document-opening-in-browser-unsupported-features

https://msdn.microsoft.com/en-us/library/ff595319(v=office.14).aspx

https://technet.microsoft.com/en-us/library/ee837425(v=office.14).aspx

http://stackoverflow.com/questions/22084561/difference-between-iisreset-and-iis-stop-start-command

 

 

 

Exchange log full – mailbox in quarantine

1 Oct

Sometimes when you experience Exchange log (disk) is full, and some mailboxes will have the status in quarantine. You can do the following:

  1. Check if any users are in quarantine (powershell)
    • Get-MailboxDatabase|Get-Mailbox |Get-Mailboxstatistics |Select Displayname,IsQuarantined |FT -Autosize | Export-Csv c:\temp\mailboxusers.csv
    • Get-MailboxStatistics -identity USERNAME| FL Isquarantined
  2. Solution
    1. Can wait on for the default 6 hours to let exchange release the quarantine
    2. Delete registry (doesn’t work all the time) – use following powershell to check registry for quarantine mailbox
      • Get-ChildItem -Path HKLM:\SYSTEM\CurrentControlSet\services\MSExchangeIS\$env:COMPUTERNAME\ |
        Where-Object {$_.pschildname -ne ‘logstate’ -and $_.pschildname -notlike ‘public*’} |
        Select-Object -ExpandProperty pschildname |
        ForEach-Object {
        Get-ChildItem -Path HKLM:\SYSTEM\CurrentControlSet\services\MSExchangeIS\$Env:COMPUTERNAME\$_\QuarantinedMailboxes |
        Select-Object -ExpandProperty pschildname |
        Get-Mailbox |
        Select-Object -Property name
        }
    3. dismount and mount the maildatabase (powershell)
      • Dismount-Database -Identity MAILBOXDB-Confirm:$False
      • Mount-Database -Identity MAILBOXDB -Confirm:$False
  3. Check status of the mailboxdatabase:
    • Get-MailboxDatabase -Identity MAILBOXDB -Status | Format-Table Name, Mounted, BackupInProgress, OnlineMaintenanceInProgress

 

Read more

http://blogs.technet.com/b/sjimmie/archive/2010/07/09/mailbox-quarantine.aspx

http://felipecgoncalves.blogspot.no/2011/08/how-to-check-exchange-databases-status.html

http://felipecgoncalves.blogspot.no/2011/08/how-to-dismountmount-mailbox-databases.html

http://mikefrobbins.com/2013/11/21/insane-powershell-one-liner-to-return-the-name-of-users-with-quarantined-mailboxes-in-exchange-2010/

http://blogs.technet.com/b/rmilne/archive/2014/01/13/how-to-set-mailbox-quarantine-in-exchange.aspx

http://technet.microsoft.com/nb-no/library/10a2b32c-b844-44f1-b750-d5150e0b249c.aspx

http://support2.microsoft.com/kb/2603736/en-us

http://technet.microsoft.com/library/bb331958.aspx#SH

http://whitecraneltd.blogspot.no/2013/02/exchange-2010-and-powershell.html

 http://www.falconitservices.com/support/KB/Lists/Posts/Post.aspx?ID=72

 

 

Reset IIS – clear cache

3 Sep

In order to reset IIS or clear cache, you need to do the following:

  1. iisreset or
  2. remove cache
    • Click “Start” on your server, open “Administrative Tools” and then open the “IIS” program
    • Navigate to the website in IIS from which you want to remove the caching feature
    • Right-click on your website, then click “Properties.”
    • Click “Home Directory,” click “Configuration,” then click “App Mappings.”
    • De-select the “Cache ISAPI Applications” box, then click “OK.”

 

Read more:

http://stackoverflow.com/questions/3036397/how-to-reset-iis-or-otherwise-clear-cache-when-restarting-a-web-application

http://www.ehow.com/how_7393530_remove-iis-cache.html

 

 

 

Clear .Net cache

3 Sep

If something strange happens on your application/system, you need to clear .NET cache once in a while. You need to do the following from the command line – you might need to start as administrator:

IISRESET
Del /F /Q /S %LOCALAPPDATA%\Microsoft\WebsiteCache\*.*
Del /F /Q /S %LOCALAPPDATA%\Temp\VWDWebCache\*.*
Del /F /Q /S “%LOCALAPPDATA%\Microsoft\Team Foundation\3.0\Cache\*.*“
Del /F /Q /S “C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\*.*“
Del /F /Q /S “C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\*.*“
Del /F /Q /S “C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\*.*“
Del /F /Q /S “C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\*.*“

This is only an example of .NET version that we have on our system, you need to modify the .NET version to suit yours. If you want to schedule clearing the .net you can put everything above in a .bat file and schedule in it windows scheduler.

 

Read more:

http://blogs.k10world.com/technology/delete-net-cache-versions-server/

 

Find SQL Server running port

24 Mar

In order to find which port the sql server instance is running on – run this query towards the database:

USE master GO xp_readerrorlog 0, 1, N'Server is listening on' GO

or

SELECT DISTINCT
local_tcp_port
FROM sys.dm_exec_connections
WHERE local_tcp_port IS NOT NULL

From the command line when you have PID (task manager for sqlsrv.exe)
netstat -ano | findstr *PID*

 

Read more

http://stackoverflow.com/questions/12297475/how-to-find-sql-server-running-port

http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/