Bat File \ SQLEXP Password Question

Posted on 2009-04-27
Last Modified: 2012-05-06
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

Question by:NotSoShabby
    LVL 9

    Expert Comment

    Poking around in the dark here: try using double dollar sign as in pa$$sword

    Accepted Solution

    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

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
    Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
    Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
    The viewer will learn how to dynamically set the form action using jQuery.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now