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.