Troubleshooting Common Problems
The syntax used for creating and running queries is very sensitive. Often, a query will not run because a particular text object is either used incorrectly or not specified.
The following examples depict incorrectly written scripts, along with an explanation of why they are incorrect:
Example 1
WinSQL –xStudentTemplate.wet –dStudentDSN –uAdmin –pAdmin
You cannot specify any other parameter along with –x. The template file stores all the necessary connection parameters.
Example 2
WinSQL –dStudentDSN –uAdmin –qc:\updateStudents.sql –oc:\output.txt -a
Here, the –p option for password is not specified. If WinSQL Professional does not see a –p option, it will prompt the user for a password. If the password is blank or your database does not need a password, you must still provide this parameter with no value specified.