I've created a VB.Net app that reads a csv file, does some processing, and then loads to a SQL Server DB. The code works fine on our web server. But, we would like to place the csv file on another secured network drive. We can limit it to specific groups, and keep it off our web server.
I've been using the following code:
Dim strFileName As String
strFileName = "V:\VMI\" + ddlPlantNum.SelectedItem.Value + txtCustNum.Text + ".csv"
Dim file As FileInfo = New FileInfo(strFileName)
I've read some articles about using UNC instead of mapped drives, but both return the same error:
Could not find file "V:\VMI\121367.csv".
Could not find file "\\server\VMI\121367.csv".
Permissions are set as 'Full Access' for 'Everyone'. I would like to restrict that in the future, but need to solve the current problem first.
Thanks for your help.