sql script from Bat file Micros 3700 1

[ddrafts]

I have my SQL script finished. Want to set it up to run from a Batch file. From what I have read you would setup the bat file as..

dbisql.exe -c "userid=custom;password=custom" drink.sql

Every time I try to run it a help box comes up.

How do I do this.

Thanks in advance.
Doug

 

[pmegan]

Try this instead

dbisql.exe -c uid=custom;pwd=custom;dbf=micros drink.sql

You may want to put the full path to drink.sql in there as well. When you get it working put a -q argument before the -c to keep the sql screen from displaying when the batch runs.

Pat

 

[ddrafts]

That worked.

Thank you so much
Doug