File not uploading but not getting errors.

[dougancil]

I have a site that I've almost completed and while testing it today noticed that it's not uploading any files or doing the bulk insert in SQL that I need it to. Here is my codebehind:

Imports System.IO
Imports System.Data   
Imports System.Data.SqlClient
Partial Class _Default
    Inherits System.Web.UI.Page
    Protected Sub Submit1_Click(ByVal sender As Object, ByVal e As EventArgs)
 
        If Not File1.PostedFile Is Nothing And File1.PostedFile.ContentLength > 0 Then
            Dim fn As String = System.IO.Path.GetFileName(File1.PostedFile.FileName)
            Dim SaveLocation As String = Server.MapPath("Data") & "\" & fn
            Try
                File1.PostedFile.SaveAs(SaveLocation)
                Response.Write(<center>Thank you for your submission.</center>)
 
                ' get the file that was submitted and check if it was .txt file   
                Dim theFile As FileInfo = New FileInfo(SaveLocation)
                If theFile.Extension <> ".txt" Then
                    Response.Write(<center>Please submit a text file.</center>)
                End If
 
                Dim importPath As String = Server.MapPath("Data") & "\upload.txt"
                If File.Exists(importPath) Then
                    ' do something with existing upload.txt file, maybe archive?   
                End If
 
                ' rename the uploaded file to upload.txt for importing   
                theFile.MoveTo(importPath)
 
                ' and bulk import the data:   
                Dim connection As String = ConfigurationManager.ConnectionStrings("Dialerresults").ConnectionString
                Dim results As New DataTable
 
                Using con As New SqlConnection(connection)
                    con.Open()
 
                    ' execute the bulk import   
                    Using cmd As SqlCommand = con.CreateCommand
                        cmd.CommandText = "bulk insert dialerresults from '" & importPath & "' " & _
                            " with ( fieldterminator = ',', rowterminator = '\n' )"
                        cmd.ExecuteNonQuery()
                    End Using
                End Using
 
            Catch Exc As Exception
                Response.Write("Error: " & Exc.Message)
            End Try
        Else
            Response.Write(<center>Please select a file to upload.</center>)
        End If
 
    End Sub
End Class

Can anyone see why the file is not being uploaded? I'm sure its something simple but I've been working on this for a while and may have missed something. Any assistance would be welcome.

Thank you,

Doug

[Frinavale]

Do you have permissions to open the file?
ASP.NET User has to have permissions to that folder.

[dougancil]

that file has an "everyone" permission on it with all values checked. So in short your answer would be yes or do I have to create an asp.net user specifically?

[Frinavale]

Well your code couldn't open the file for some reason so ...
I would be inclined to say that you should specifically set these permissions.
These permissions will depend on the operating system you're using.
I recommend googling this one ;)

[dougancil]

Frinny,

I've looked into this, I have made sure that even the sql server user has rights to that admin rights to this folder. I've read a couple of articles stating that I have to have the UNC path to the saved destination. I've tried that too, any ideas as to what may be causing that error?

[Jerry Winston]

I've tried to catch up with this thread but I still have a few questions.

Does the file actually go to your data folder? The error suggests that the file name/path is incorrect. The file was not found - there was no mention of permissions errors. I suggest removing any old upload.txt files from any/all data folders and trying a clean run. I'll bet the upload.txt file is getting dumped elsewhere hence the file not found error.

Does the server have access to the directory and not just the file?
The server will require permissions on the folder and not the file as the file and associate permissions will be deleted regularly.