Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
OSQL(FreeTDS)		   FreeTDS Reference Manual		 OSQL(FreeTDS)

NAME
     osql -- utility to	test FreeTDS connections and queries

SYNOPSIS
     osql -S dsn -U username -P	password [-I ini_directory]

DESCRIPTION
     osql is a diagnostic tool provided	as part	of FreeTDS. It is a Bourne
     shell script that checks and reports on your configuration	files. If ev-
     erything checks out OK, it	invokes	isql.

     osql works	only with the isql that	comes with unixODBC.

OPTIONS
     -S	dsn  the Data Source Name to which to connect, as known	to odbc.ini.

     -U	username
	     database login name.

     -P	password
	     database password.

     -I	ini_dir
	     override odbc.ini file location.

EXAMPLE
     If	you have an odbc.ini with a section like this:

	   [myDSN]
	   servername =	myserver
	   TDS_Version = 5.0

     You would invoke osql as:

     osql -S myDSN [...]

FILES
     odbc.ini freetds.conf

NOTES
     If	you can	connect	with `osql -S servername -U user -P passwd', your
     FreeTDS ODBC installation is working.

     osql guesses where	unixODBC might look for	its odbc.ini by	examining the
     binary. This is not always	an effective approach. If it doesn't work,
     you'll receive a report of	candidate strings. Kindly pass along the out-
     put to help improve the guessing.

     If	osql cannot intuit your	odbc.ini directory, you	can force the issue
     with the -I option. However, you're then instructing osql what to test,
     not where unixODBC	will eventually	look. Your override is therefore only
     as	good as	you are. Look carefully	at the error output before overriding.

     If	you have suggestions for ways to make osql more	useful as a diagnostic
     tool, please post them to the FreeTDS mailing list.

HISTORY
     osql first	appeared in FreeTDS 0.65.

AUTHORS
     The osql utility was written by James K. Lowden.

FreeTDS	dev.1.2.10		April 26, 2012		    FreeTDS dev.1.2.10

NAME | SYNOPSIS | DESCRIPTION | OPTIONS | EXAMPLE | FILES | NOTES | HISTORY | AUTHORS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=osql&sektion=1&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help