I worked from home last night and came across an issue when using the pushd command to change directory. This is on a windows 7 laptop.
I have some batch files (.bat) and command files (.cmd) that load data to Oracle (on a separate server) via SQLLDR, run some oracle stored procs and use SQLPLUS to extract data.
All the various files are on network drives at work (\\server\share type thing)
In my bat, cmd and sql files i use the pushd command to change the current file path to one of these network drives (e.g. pushd "\\myserver.abc.com\cde\....." <-- using inverted commas)
This all works fine when I'm at work directly connected to the network but If I'm at home using a VPN connection then my bat/cmd files give an access denied message.
Now, when at home I can access these folders using windows explorer etc, I can save, ammed, create and delete files quite happily. But I'm getting this odd access denied msg when using pushd.
I specifically use pushd as the folder paths have spaces in them.
Can anyone help?