GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  OSQL (1)

NAME

osql - utility to test FreeTDS connections and queries

CONTENTS

Synopsis
Description
Options
Example
Files
Notes
History
Authors

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 everything 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 output 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
.An James K. Lowden Ns .
Search for    or go to Top of page |  Section 1 |  Main Index


Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.