Server Drives and network folders...

wenzation · #11 (**permalink**) September 10th, 2003, 03:08 AM

pgtips,
i know it's hard on you. But i really need help to get connected to the network drive(K:\) from the network folder. Can you help me please.

i'm a beginner, hoping to learn more.. please help... thanks a lot

digitaldxb · #12 (**permalink**) November 24th, 2006, 03:53 AM

Hi I have the same issue and I followed your instructions and created a virtual folder under the main website and i can see the content of the folder in IIS but i am not able to connect via asp script , could you please suggest i am getting below error message :

Microsoft VBScript runtime error '800a004c'

Path not found

/xyz/Addxls_auto.asp, line 111

My Code is below :

Code:

foldername=CStr(cyear) & mm & dd
Set objFolder = objFSO.GetFolder(Server.MapPath("myfolder"))
mPathName = "myfolder\"&foldername&"\"&"subdirectory"&"\"&"temp.xls"
' Response.Write mPathName & "<br>"

'-- Start of First Record Entry ------------------
If (fs.FileExists(mpathName)) = true Then
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
                      "DriverId=790;" & _
                      "Dbq=" & mpathName & ";" & _
                      "DefaultDir=B:\temp"