MoveFile problem

[b00gieman]

Hello!
I'm using the MoveFile method for moving files between 2 servers , one running my asp script and the other running my database.My problem is that I'm getting the error:

Microsoft VBScript runtime error '800a0035'

File not found

The command for moving files:
fs.MoveFile Server.MapPath("upload/tmb2.xls"), "\\tmav035a\Test\AssetDB_test\tmb2.xls"

the first location is a file on the asp server.
Could somebody tell me what's the cause of the errors?

Thanks!

[jhardman]

I would guess that the asp server can't find the location on the other server. There are a lot of things that could prevent that, I don't even know where to send you to fix it, but it occurs to me that both paths are supposed to start with a drive letter. The mapPath function provides this for the first path, but it doesn't look like the second one does. And since it is on a different server, I don't even know how you could make that work. Can you not put a script on the other server?

Jared

[markrawlingson]

I'd tend to agree, I didn't think you could supply a virtual path with the MoveFile method, I thought it had to be a physical path. Though I could be wrong, I researched a little on google and a few items I pulled up suggest that you can use a virtual path. Even so, the first path is upload/tmb2.xls - if nothing else that's where your problem is.. I'm fairly certain that has to be a full path. C:/devdirectory/upload/tmb2.xls

If you still get the problem, I would try just moving the file around on your 1 server first and see if that works.. remove the virtual directory as the destination and replace it with a physical path on the same computer, different drive or something.. if that doesn't work then you know that's not the problem obviously!

If this is the case, Another option you may have is to network the servers together if at all possible. For instance, if networked together - the virtual server you're referencing might be drive H: - so you could do something like :

fs.MoveFile Server.MapPath("C:/upload/tmb2.xls"), "H:/Htmav035a/Test/AssetDB_test/tmb2.xls"

[b00gieman]

I would guess that the asp server can't find the location on the other server. There are a lot of things that could prevent that, I don't even know where to send you to fix it, but it occurs to me that both paths are supposed to start with a drive letter. The mapPath function provides this for the first path, but it doesn't look like the second one does. And since it is on a different server, I don't even know how you could make that work. Can you not put a script on the other server?

Jared

I can't place the database and the asp script on the same server...:(

[b00gieman]

I'd tend to agree, I didn't think you could supply a virtual path with the MoveFile method, I thought it had to be a physical path. Though I could be wrong, I researched a little on google and a few items I pulled up suggest that you can use a virtual path. Even so, the first path is upload/tmb2.xls - if nothing else that's where your problem is.. I'm fairly certain that has to be a full path. C:/devdirectory/upload/tmb2.xls

If you still get the problem, I would try just moving the file around on your 1 server first and see if that works.. remove the virtual directory as the destination and replace it with a physical path on the same computer, different drive or something.. if that doesn't work then you know that's not the problem obviously!

If this is the case, Another option you may have is to network the servers together if at all possible. For instance, if networked together - the virtual server you're referencing might be drive H: - so you could do something like :

fs.MoveFile Server.MapPath("C:/upload/tmb2.xls"), "H:/Htmav035a/Test/AssetDB_test/tmb2.xls"

I tried the MoveFile method with both of the files situated on the same server.It worked...the servers are on the same network..