Let me start with my current setup
Frontend - IIS7 Server
Backend - SQL 2005 Server
I have an .net web form that upload an excel file to my server. I would like for this Excel file to be upload to my SQL server since it need to be process by a sql command and the SQL server cannot seems to be able to access the IIS7 when running the quary i needed. All i want to be able to do is to load this excel file to a folder within the SQL server.
Here is my web.config folder path -
<appSettings>
<add key="FolderPath" value="Uploads/"/>
</appSettings>
and here is the code -
Protected Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If FileUpload1.HasFile Then
Dim FileName As String = Path.GetFileName(FileUpload1.PostedFile.FileName)
Dim Extension As String = Path.GetExtension(FileUpload1.PostedFile.FileName)
Dim FolderPath As String = ConfigurationManager.AppSettings("FolderPath")
Dim FilePath As String = Server.MapPath(FolderPath + FileName)
FileUpload1.SaveAs(FilePath)
GetExcelSheets(FilePath, Extension, "Yes")
End If
End Sub
when i try to change the path in the web.config it will tell me it cannot use physical path only virtual.
I will appreacite any idea.
Thank you.