The Data Source utility
92
$ For more information, see "CommLinks connection parameter" on
page 52.
Display debugging information (–z) Provide diagnostic information on
communications links on startup.
$ For more information, see "Debug connection parameter" on page 56.
Server name Connect to the named server. Only the first 40 characters are
used.
$ For more information, see "The Database Server" on page 13.
Write a definition of the data source newdsn. Do not prompt for
confirmation if the data source already exists.
dbdsn -y -x tcpip -w newdsn -c "uid=DBA;pwd=SQL" -v
or, with a different switch order,
dbdsn -w newdsn -c "uid=DBA;pwd=SQL" -x tcpip -y
List all known user data sources, one data source name per line:
dbdsn -l
List all known system data sources, one data source name per line:
dbdsn -ls
List all data sources along with their associated connection string:
dbdsn -l -b
Report the connection string for user data source MyDSN:
dbdsn -g MyDSN
Report the connection string for system data source MyDSN:
dbdsn -gs MyDSN
Delete the data source BadDSN, but first list the connection parameters for
BadDSN and prompt for confirmation:
dbdsn -d BadDSN -v
Delete the data source BadDSN without prompting for confirmation.
dbdsn -d BadDSN -y
Create a data source named NewDSN for the database server MyServer:
dbdsn -w NewDSN -c "uid=DBA;pwd=SQL;eng=bar"
If a NewDSN already exists, the previous definition is overwritten.
Examples
To Next Page
Loading...