Troubleshooting: How to test connection strings (dbping)

Use the dbping utility to troubleshoot connections.

You can use the dbping utility with the -c option to test connection string parameters. By default, dbping does not connect to a database, it only connects to the server and it does not start the server. Use the -d option with the dbping utility to connect to the database and start the database server, if necessary.

Examples

For example, suppose a personal server with the name demo16 is running the sample database (which can be started with the command dbeng16 -n demo16 "%SQLANYSAMP16%\demo.db;"). The following command returns a message indicating that the ping was successful if a database server named demo16 is running on the local computer and has a database named demo running:

dbping -d -c "Server=demo16;DBN=demo;UID=DBA;PWD=sql"

The following command tests to see if a database server named demo16 is running with the database named demo and starts the server and database if it is not running:

dbping -d -c "Server=demo16;DBN=demo;DBF=c:\sa16\samples\demo.db;;ASTOP=no;UID=DBA;PWD=sql"

The following command tests to see if a database server can be found on a computer named Waterloo on the default port 2638:

dbping -c "Host=Waterloo"

The following command tests to see if a default database server is running on the current computer.

dbping

Troubleshooting: How to test connection strings (dbping)

Examples

See also