Create csv file - goes into wrong folder on server (works on dev)

[m.r.davies]

Hi all
This is my first post, so hopefully some one can help

I'm an asp.net developer and have written my first VB.net app,
Its an over night job that basically queries a SQL DB and then spits out a CSV file

This all works fine, however, when i put it on the server, the CSV file is generated in the same folder as the EXE file, and not in the custom location that is in the config file.
i've tried pointing to the C drive in the config file like so....
<add key="FileLocation" value="C:\" />

however, it ignores that for some reason and puts it at the same level as the EXE
What puzzles me is it works on my dev box!

any ideas what i'm doing wrong? is there some permissions thing i'm missing?
Cheers
Mark

 

[giadich]

where does your application resides on the dev/prod machine?

how are your saving the file?

 

[JuggaloBrotha]

paste the section of code that specifies where the file is saved here, I bet it has something to do with the root of the path

My guess is that your dev machine has a drive letter mapped to the folder on the server in which the server does not have that drive letter so the program needs to be changed and re-built before it's ran on the server.