Bat File \ SQLEXP Password Question

Thanks in advance.

I was supplied a bat file to grant new permissions to a Progress user. However, the password for our sysprogress account contains a dollar sign and will not connect to the db. Is there a way to escape the dollar sign (I've tried ^ and \). Or have the password pulled from a text file?
call c:\epicor\oe101b\bin\sqlexp mfgsys -H localhost -S 8350 -user sysprogress -password pa$sword -infile C:\epicor\odbctableList400.txt -outfile C:\epicor\odbcresults.txt -sqlverbose

Open in new window

NotSoShabbyAsked:
Who is Participating?
 
NotSoShabbyAuthor Commented:
It turns out the problem was not a batch problem. It was actual an issue with the SQL Connect utility which did not allow dollar signs in the password. Changed the password to something without special characters and I am all set
0
 
tillgeffkenCommented:
Poking around in the dark here: try using double dollar sign as in pa$$sword
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.