dsnadd

---

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] 

or

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.SQL is installed.

svDSN
is the name of the data source on the Pervasive.SQL 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]
-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 

See Also

btadmin(1), dbmaint(1)