August 16, 2010 at 12:54 pm
I have a simple osql statement that I can run from a command prompt just fine, however when I try to run if from a batch file it errors out
Here is the command line
osql -E -S CMSBLACKBERRY\BLACKBERRY -i\ c:\bbup.sql
August 16, 2010 at 1:05 pm
How are you running this from the batch file?
The -E parameter uses Windows authentication. If you run from the command line, it uses your Windows credentials. If you schedule this in a batch file, or give it to someone else, it runs under their security.
August 16, 2010 at 1:16 pm
Good point for now I am running it under same account when it works and when it fails
August 16, 2010 at 1:57 pm
osql -E -S CMSBLACKBERRY\BLACKBERRY -i\ c:\bbup.sql
Your syntax looks to be off.
I believe it should look like this (unless above is typo)
osql -E -S CMSBLACKBERRY\BLACKBERRY -i c:\bbup.sql
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply