asp could not find a part of the path

[silviufn]

hi there,
i have a problem. i have searched this isue to see if it was posted but i could not find any solutions.
a try to import excel file into msql. it was working just fine but now a have two erros:
- asp could not find a part of the path
- unspecified error

on test server its working ok but on production server i get this errors.
please some help
thank you very much

[Nightwalker83]

Are you using ASP, ASP.NET?

[silviufn]

asp.net
thanx

[stanav]

hi there,
i have a problem. i have searched this isue to see if it was posted but i could not find any solutions.
a try to import excel file into msql. it was working just fine but now a have two erros:
- asp could not find a part of the path
- unspecified error

on test server its working ok but on production server i get this errors.
please some help
thank you very much

No code = not able to help you further...

[silviufn]

the code seems to be ok. it was workin just fine. but lately i get this error. thanx

If FileUpload1.FileName <> "" Then
If Session("Import") = "Cazare" Then

GridView1.Visible = True
Dim sSQLTable As String = "tbl_TM_TempTableForCazareDanubiusExcelImport"
'Dim sExcelFileName As String = ""
'sExcelFileName = FileUpload1.PostedFile.FileName
'Dim sExcelFileName As String = Server.MapPath("~") + "\" + FileUpload1.FileName

Dim sExcelFileName As String = "F:\Danubius\" + FileUpload1.FileName ' PROD

Me.hfExcelFileName.Value = FileUpload1.FileName

FileUpload1.SaveAs(sExcelFileName)
Dim sWorkbook As String = "[Raport$]"
Dim sExcelConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sExcelFileName & ";Extended Properties=""Excel 8.0;HDR=YES;"""
'Dim sExcelConnectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & sExcelFileName & ";Extended Properties=""Excel 12.0;"""
Dim sSqlConnectionString As String = WebConfigurationManager.ConnectionStrings("TravelManagementConnectionString").ToString
'Me.txtMsgErr.Text = "helllo" 'sExcelConnectionString + ";" + sExcelFileName
'OleDbConn = New OleDbConnection(sExcelConnectionString)
OleDbConn.ConnectionString = sExcelConnectionString
Dim OleDbCmd As OleDbCommand = New OleDbCommand(("SELECT * FROM " & sWorkbook), OleDbConn)


'Create our connection strings
'Execute a query to erase any previous data from our destination table
Dim sClearSQL = "DELETE FROM " & sSQLTable
Dim SqlConn As SqlConnection = New SqlConnection(sSqlConnectionString)
Dim SqlCmd As SqlCommand = New SqlCommand(sClearSQL, SqlConn)
SqlConn.Open()
SqlCmd.ExecuteNonQuery()
SqlConn.Close()
OleDbConn.Close()

Try
OleDbConn.Open()
Catch ex As Exception
OleDbConn.Close()
'Me.txtMsgErr.Text = "fff"
strer = MesgBox.script(ex.Message.ToString)
ClientScript.RegisterStartupScript(strer.GetType(), "Eroare", strer)
End Try

'If ConnectionState.Broken Then
' Throw New Exception()
'End If

Dim dr As OleDbDataReader = OleDbCmd.ExecuteReader()
Dim bulkCopy As SqlBulkCopy = New SqlBulkCopy(sSqlConnectionString)

bulkCopy.DestinationTableName = sSQLTable
bulkCopy.ColumnMappings.Add(0, "Delegatie")
bulkCopy.ColumnMappings.Add(15, "NrFactura")
bulkCopy.ColumnMappings.Add(16, "DataFactura")
bulkCopy.ColumnMappings.Add(11, "Localitate")
bulkCopy.ColumnMappings.Add(10, "NrNopti")
bulkCopy.ColumnMappings.Add(8, "DataInceputServiciu")
bulkCopy.ColumnMappings.Add(9, "DataSfarsitServiciu")
bulkCopy.ColumnMappings.Add(13, "DocumentCost")
bulkCopy.ColumnMappings.Add(22, "Cazare")
bulkCopy.ColumnMappings.Add(23, "TVACazare")
bulkCopy.ColumnMappings.Add(24, "TaxaTranzactie")
bulkCopy.ColumnMappings.Add(25, "TVATaxaTranzactie")
bulkCopy.WriteToServer(dr)

OleDbConn.Close()
SqlDataSource1.DataBind()
GridView1.DataBind()

FileUpload1.Visible = False
Button1.Visible = False

End If
End If

[stanav]

1st error is most likely caused by an IOException (i.e. non existent folder, the account that runs the web app doesn't have write permission to that directory...) Does the directory F:\Danubius exist? If it does then does the uploaded file get saved in F:\Danubius\ folder?

2nd error is the result of the 1st error. You assume that everything went well and the uploaded file had been saved to its destination. What if the uploaded file failed to be saved?

[silviufn]

the folder exist. and yes the uploaded file is saved.

[silviufn]

last time i tried to import the file on the production application gave me this error. and i saw the file saved on F:\danubius folder
After that i ran it in debugger and imported from a local path. that's my workaround for the moment

[silviufn]

UNSPECIFIED ERROR. i saw other people having on this problem
http://support.microsoft.com/kb/827190

[stanav]

So where (which line) does it throw the exception then?

[silviufn]

it doesn,t show ...because the error apears only in production. just a message with

[Nightwalker83]

UNSPECIFIED ERROR. i saw other people having on this problem

Is that still related to the original problem?

Edit:

it doesn,t show ...because the error apears only in production. just a message with

Have you tried running the release version of the site on the development machine?

[RobDog888]

Thread Moved

[silviufn]

yes. is the same version.

[silviufn]

hi there,
this thread can be close.

[KGComputers]

hi there,
this thread can be close.

You mean this thread is resolved? if yes, mark this thread as resolved..

KGC