Access Denied For XML File

[senthilnathan1985]

Hi

am Creating one web page in ASP.NET

and also implementing XML in my project am beginner to XML Creation

in my project i create XML document for every single Record in database table

I did this my level best

Its Run fine in local Environment

"But When i upload this page i can't get the XML document "

It will display the error like this "Access to the path 'C:\bay\passengers.xml' is denied."

"It doesn't create a XML file"

"In local Environment it works fine and also create every single record XML document"

This is my code for XML Creation

1 Sub WriteXMl()
2
3 Dim strCurrentPath As String = Request.PhysicalPath
4 Dim strXMLPath As String = Left(strCurrentPath, InStrRev(strCurrentPath, "\")) & "passengers.xml"
5 Dim strConnect As String
6 Dim objXMLWriter As XmlTextWriter
7 Dim dbReader As OleDbDataReader
8 Dim xmldoc As New XmlDocument
9 Dim objDataSet As New DataSet
10 Try
11 objXMLWriter = New XmlTextWriter(strXMLPath, Nothing)
12 Catch objError As Exception
13 Exit Sub
14 End Try
15
16 strConnect = WebConfigurationManager.ConnectionStrings("Webbay").ConnectionString
17 Dim objConnect As New OleDbConnection(strConnect)
18 Dim command As New OleDbCommand("SELECT PassengerNo,FirstName,LastName,Marketing FROM bay", objConnect)
19 objConnect.Open()
20 dbReader = command.ExecuteReader
21
22 objXMLWriter.Formatting = Formatting.Indented
23 objXMLWriter.Indentation = 3
24 objXMLWriter.WriteStartDocument()
25 objXMLWriter.WriteComment("Created on " & Now())
26 objXMLWriter.WriteStartElement("TRAMSDATA")
27 objXMLWriter.WriteElementString("Version", "0.10-2.07.00")
28 objXMLWriter.WriteStartElement("PROFILE")
29 While dbReader.Read()
30 objXMLWriter.WriteStartElement("PASSENGER")
31 objXMLWriter.WriteElementString("PASSENGERNO", dbReader("PassengerNo"))
32 objXMLWriter.WriteElementString("FIRSTNAME", dbReader("FirstName"))
33 objXMLWriter.WriteElementString("LASTNAME", dbReader("LastName"))
34 objXMLWriter.WriteElementString("MARKETING", dbReader("Marketing"))
35 objXMLWriter.WriteEndElement()
36 End While
37
38 objXMLWriter.WriteEndElement()
39 objXMLWriter.WriteEndElement()
40 objXMLWriter.Flush()
41 objXMLWriter.Close()
42 dbReader.Close()
43 objDataSet.DataSetName = "TRAMSDATA"
44 objDataSet.Load(command.ExecuteReader(), LoadOption.OverwriteChanges, "PASSENGER")
45 objDataSet.WriteXmlSchema(Request.MapPath("passengers.xsd"))
46
47 End Sub

Can You help me

Please Very Urgent

Thanks With Regards

S.Senthil Nathan

[kenobewan]

Web apps usually dont have access to local folders. If bay is set up as a directory through IIS you may a path using bay/passenger.xml. HTH.