[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

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

0
NotSoShabby
Asked:
NotSoShabby
1 Solution
 
tillgeffkenCommented:
Poking around in the dark here: try using double dollar sign as in pa$$sword
0
 
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now