dsnadd

Availability


Windows	Linux	Clients	Engines

Description

dsnadd simplifies the setup of a new ODBC data source that uses the Pervasive ODBC Client Interface driver. It modifies the odbc.ini file by adding appropriate information about the new data source. For the latest information on dsnadd, see the man page.

Synopsis

To add a data source, execute the following command:

dsnadd -dsn=server_DSN -db=DB_name 
[-ini=inifile] [-desc=DSN_description] 
[-drv-desc=driver_description]

dsnadd -dsn=myDSN -desc=datasource 
-db db_name -host=psqlhost -sdsn=svDSN

myDSN
is a name you want to assign to the new data source.

datasource
is any string to describe the data source.

psqlhost
is the name of the network host where your Pervasive PSQL is installed.

svDSN
is the name of the data source on the Pervasive PSQL host.

Options


`-help`	gives help on the `dsnadd` utility
`-odbc-ini, -ini`	ODBC.ini file name ($HOME/.odbc.ini)
`-dsn-name, -dsn`	Data Source Name
`-dsn-desc, -desc`	DSN description [[driver_description:]host/DSN]
`-srv-host, -host`	server host name
`-srv-port, -port`	server port number [1583] (See also Changing the Default Communication Ports in Getting Started With Pervasive PSQL (Server Edition).)
`-sdsn`	server DSN [localDSN]
`-drv-path, -drv`	`[`/usr/local/psql/lib:$HOME/lib`]`
`-drv-desc`	driver description [Pervasive ODBC Client interface]

Examples

To add a Client DSN named localDSN that references an Engine DSN named remoteDSN on a machine named server12, enter the following command:

dsnadd -dsn=localDSN -desc=any_text -host=server12 
-svr-dsn=remoteDSN