hi people if anyone can help me i am running a helpdesk website in a big infrastucture. just added a uploading files function. the website runs on a server pc and im trying to upload the files from the website users to a differnt server pc but i keep on getting a permission denied error can anyone help me please
dim CallID,lConn,UserQuery,objcmd4,sqlText,intrecords
callID = session("ACallID")
Dim uploadsDirVar
uploadsDirVar="\\spmrfnp1\Attachments\"& CallID &""
Dim myFSO
'Initialize myFSO as a file system object
SET myFSO = Server.CreateObject("Scripting.FileSystemObject")
'If the folder does not already exist then create the folder
If NOT myFSO.FolderExists("\\spmrfnp1\Attachments\"& CallID &"") Then
myFSO.CreateFolder("\\spmrfnp1\Attachments\"& CallID &"")
Set lConn = Server.CreateObject("ADODB.CONNECTION")
lConn.Open "Provider=sqloledb;Data Source=AIWPH2CWESSELS;User Id=GCLS;Password=GCLSMGR;Initial Catalog=GCLS"
Set objCmd4 = Server.CreateObject ("ADODB.Command")
SQLText = "insert into [GCLS].dbo.Attachments (CallID,FolderURL) values ('"&CallID&"','"&UploadsDirVar&"')"
objCmd4.ActiveConnection = lconn
objCmd4.CommandType = &H0001
objCmd4.CommandText = SQLText
objCmd4.Execute intRecords
Set objCmd4 = Nothing
lconn.close
End If
and i know asp.net is 10000000 times better im in the process to take the website over to asp.net but they want this to be ready by end of the week
and i didnt create the website only got it to edit it
and the servers is on the same network and same domain