Testing that a database server can be found (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 demo12 is running the sample database (which can be started with the command dbeng12 -n demo12 "%SQLANYSAMP12%\demo.db"). The following string returns a message indicating that the ping was successful if a database server named demo12 is running on the local computer and has a database named demo running:

dbping -d -c "Server=demo12;DBN=demo;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

Testing that a database server can be found (dbping)

Examples

See also