WinSQL » Knowledge base

Document information

Document ID:807
Subject:Passing a connection string from command line?
Creation date:7/29/09 4:35 PM
Last modified on:7/29/09 4:35 PM

Passing connection string from command line

Use the following syntax on a command line to pass a connection string.

winsql "-cYourConnectionString"

For example:
winsql "-cDRIVER=SQL Server;SERVER=(local);Trusted_Connection=Yes"

Another way of specifying a connection string is to use it as a DSN name. For example:

winsql "-dDSN=YourDSNName" -p-1 -u-1

The above example demonstrate how to connect to a DSN called YourDSNName. User id and password is set to -1, which means these values will be read from the DSN manager.

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.


Social Media

Powered by