odbctest

---

odbctest - Interactive ODBC test utility.

Synopsis

odbctest

Description

odbctest is used to test your DSNs for their connectivity to databases. For example, to connect to the DEMODATA database included with Pervasive.SQL, load odbctest, then enter DSN=DEMODATA You will then be in an interactive state with the database. From there you can enter a query such as SELECT * FROM Department.

To connect to a secure database, use the following syntax:

'dsn=DEMODATA;uid=Master;pwd=masterpwd'

You must include the single quotes for a secure database.

Options

?	Displays a list of DSNs. You can use this option only after loading odbctest.

Examples

To connect to an unsecure database:

odbctest dsn=demodata 

To connect to a secured database:

odbctest 'dsn=demodata;uid=Master;pwd=mypass' 

To enable security on a database using odbctest, first connect to the database as the 'Master' user, then use the SET SECURITY statement in SQL to set the Master user password:

odbctest 'dsn=demodata;uid=Master;pwd='

SQL>SET SECURITY='masterpwd'