Categories
Apache

APACHE – How to disable directory browsing

Find and open Apache’s configuration file: httpd.conf Using a editor like notepad++ , edit the httpd.conf file and scroll until you find a line like this: Options All Indexes FollowSymLinks MultiViews To disable directory browsing carefully remove the line that says: Indexes and leave the line like this: Options All FollowSymLinks MultiViews Restart your apache […]

Categories
SQL Server

How To Obtain a List of DTS Packages

exec msdb..sp_enum_dtspackages

Categories
Windows

How to take ownership of a file or folder in Windows XP

I keep getting the error message below, so I did a search and found the solution at the link below. Error: You do not have permission to view or edit the current permission settings for (filename), but you can take ownership or change auditing settings. Solution: http://support.microsoft.com/kb/308421

Categories
SQL Server

DTS Package – Check for file before importing into database

‘ Rename File from Connection Option Explicit Function Main() Dim oFSO Dim sFileName sFilename = DTSGlobalVariables.Parent.Connections(“Text File (Source)”).DataSource Set oFSO = CreateObject(“Scripting.FileSystemObject”) ‘ Check for file and return appropriate result If oFSO.FileExists(sFilename) Then ‘Main = DTSTaskExecResult_Success Main = DTSStepScriptResult_ExecuteTask Else ‘Main = DTSTaskExecResult_Failure Main = DTSStepScriptResult_DontExecuteTask End If Set oFSO = Nothing End Function

Categories
SQL Server

DTS Package – Move Imported Data File to an Archive Directory

‘ Rename File from Connection Option Explicit Function Main() Dim oPkg Dim oConn Dim oFSO Dim oFile Dim sFilename Dim sFileDestination Dim sMonth Dim sDay Dim sYear Dim sHour Dim sMinute Dim sSecond ‘ Get reference to the current Package object Set oPkg = DTSGlobalVariables.Parent ‘ Get reference to the named connection Set oConn = […]

Categories
Visual Studio

Another cause to “Error while trying to run project: unable to start debugging on the server” for ASP.NET application.

I found out today that if IE security (Tools-> Internet options-> Security -> Internet or Intranet -> Custom level -> User authentication) is set to anonymous logon, you will get the above error. I didn’t find any mention for this cause so here it is.

Categories
Visual Studio

Error while trying to run project: Unable to start debugging on the web server

The solution that worked for me: Open your Internet Information Services manager and from the [your machine]/Web Sites/ Default Web Site node select the virtual folder which stores your project. Right Click and select Properties to select the ASP.NET tab page. Make sure the correct version ASP.NET Version is selected.