DBUSE - Create and/or open a SQL database file

DBUSE Create and/or open a SQL database file

Top Previous Next

Syntax:	DBUSE	[ dbfile ] [ /options ]
Arguments:	[ dbfile ]	Variable or string defining a database file name; if no path is defined, Robo-FTP’s working folder is used.
Options:	/new	Create the file if it does not exist.
	/odbc	Use an ODBC Data Source Name (DSN) instead of a filename.
	/pw=x	Optional password to use with the /odbc option.
	/user=x	Optional username to use with the /odbc option.

This script command is used to create and/or open a SQL database file. Issue the command with no options to open an existing file.

Add the /new option if the file does not exist and you wish a new file to be created. When a new file is created it is just an empty file - you must still create one or more tables in the database file via the DBQUERY script command before data can be saved to the file.

Add the /odbc option if you wish to instead connect to an ODBC data source. Data sources are defined in the Data Sources tool in the Administrative Tools folder under the Control Panel. The /user and /pw options can optionally be combined with the /odbc option.

Just a single database connection may be open at any one time.

Note: Robo-FTP is a 32 bit application. If you want to use a System DSN on the 64 bit version of Windows 2008 be sure to use the 32 bit version of the ODBC Administrator: %systemroot%\sysWOW64\odbcad32.exe

Related Command(s): DBCLOSE, DBGETRESULTS, DBQUERY, BROWSE