error please help??do not know??

[zishan876]

hi I get the following error when I try the code below the error:
Technical Information (for support personnel)

Error Type:
Provider (0x80030103)
Can't save.
/generate_xml.asp, line 113


Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; IEMB3; IEMB3)

Page:
GET /generate_xml.asp

Function GenerateXMLDataFile()
	Dim strFullFileName
	Const adPersistXML = 1
' Delete existing file
	Dim objFSO
	Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
	If objFSO.FileExists(Server.MapPath("test.xml")) Then
	    objFSO.DeleteFile Server.MapPath("test.xml")
	End IF
	Set objFSO = Nothing
' Declare our variables... always good practice.
	Dim cnnXML  ' ADO connection
	Dim rstXML  ' ADO recordset
	Dim xDb_Conn_Str
	
	xDb_Conn_Str="PROVIDER=SQLOLEDB.1;SERVER=CSNTSFDC;UID=sa;PWD=systems;DATABASE=SFDC;"
' Create an ADO Connection to connect to the scratch database.
' We're using OLE DB but you could just as easily use ODBC or a DSN.

	Set cnnXML = Server.CreateObject("ADODB.Connection")
	cnnXML.Open xDb_Conn_Str

	Set rstXML = Server.CreateObject("ADODB.Recordset")

	Set rstXML = cnnXML.Execute("Select SF_GUID from SFNAFILE")

' Save the file to XML format.
	rstXML.Save Server.MapPath("test.xml"), adPersistXML

rstXML.Close
Set rstXML = Nothing
cnnXML.Close
Set cnnXML = Nothing
end function

Please help Thanks

 

[Sheco]

It might be a permissions problem, try temporarily changing the default security to disable anonymous access... either that or give the default local account Write permission to the destination folder.

 

[zishan876]

How do I do that... I am pretty new at this..
Thanks

 

[Sheco]

Use the MMC snap-in app for administering IIS. Look in the control panel Administrative Tools for a link, else right-click on MyComputer and choose "Manage" from the popup context menu then look under Services and Applications. If you don't have physical access to the machine or if you can't terminal in then you can connect remotely from your workstation although you might want to download the IIS 6 admin kit if your workstation is XP and your server is 2003.