Browsed by
Category: Uncategorized

How to eliminate blank rows while exporting to Excel?

How to eliminate blank rows while exporting to Excel?

align to top arrange lines The first align to top: Select all fields on the row, right click, align to top move the selection to the top of details section (no space between the details section and the section above remove remaining space at the bottom of the details section The second: right click details click on arrange lines right click details again click on fit section This solved the issue for me. Sometimes only the first part is necesarry.

Git for Windows with TFS and SSL behind a proxy

Git for Windows with TFS and SSL behind a proxy

If you run your TFS on prem and use git for windows you may run into two issues. The first occurs if you use SSL for your TFS. The second occurs if you are behind a proxy. Use Git for Windows with a corporate SSL certificate If you have a corporate SSL certificate and want to clone your repo from the console or VSCode you get the following error: fatal: unable to access ‘https://myserver/tfs/DefaultCollection/_git/Proj/’: SSL certificate problem: unable to get…

Read More Read More

How to make IIS7 play nice with Office Interop

How to make IIS7 play nice with Office Interop

Source I’ve just started working on a new project for which we had to dig out one of our older libraries. We wrote it to retrieve data from MS Excel workbooks using the Office interop assemblies, and thus far it has never given us issues. A slight change this time round was that we were using our library in an ASP.NET site rather than a desktop application. As a result I was faced with two errors that we’d never seen…

Read More Read More

Setting up MVC 5.2.3.0 site with .Net 4.6 on IIS 7.5 on 2008R2SP1

Setting up MVC 5.2.3.0 site with .Net 4.6 on IIS 7.5 on 2008R2SP1

Thank you for that. After a bit of Googling I documented my setup roughly like this: – Install .Net 3.5.1 Features via Server Manager -> Add features wizard – Install .Net 4.6: – Install IIS 7.5: — Make sure you include the following features in IIS: IIS management console, IIS Management Script and Tools, Management Service, Static content, Directory Browsing, HTTP Errors, HTTP Redirection, ASP, ASP .Net, ISAPI Extensions, ISAPI Filters, .Net Extensibility, Default Document, HTTP Logging, Logging Tools, Basic…

Read More Read More

Visual studio connect Oracle failed

Visual studio connect Oracle failed

Error Message: “failed to connect to server or failed to parse connect string” 1. Navigate to visual studio tools for oracle directory and under the network/admin folder look for the sqlnet.ora file 2. modify and change “SQLNET.AUTHENTICATION_SERVICES= (NTS)” to “SQLNET.AUTHENTICATION_SERVICES= (NONE)” 3. Restart Visual Studio and Try again.