<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <HTML ><HEAD ><TITLE >ODBC-only configuration</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="FreeTDS User Guide" HREF="index.htm"><LINK REL="UP" TITLE="Preparing ODBC" HREF="prepodbc.htm"><LINK REL="PREVIOUS" TITLE="DSN-less configuration" HREF="dsnless.htm"><LINK REL="NEXT" TITLE="ODBC-combined configuration" HREF="odbcombo.htm"><LINK REL="STYLESHEET" TYPE="text/css" HREF="userguide.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" ><SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN > User Guide: A Guide to Installing, Configuring, and Running <SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="dsnless.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 4. Preparing ODBC</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="odbcombo.htm" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="ODBCINIONLY" >ODBC-only configuration</A ></H1 ><P >An ODBC-only configuration relies solely on <TT CLASS="FILENAME" >odbc.ini</TT > for server properties. Other <SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN > libraries don't know about <TT CLASS="FILENAME" >odbc.ini</TT >. <DIV CLASS="EXAMPLE" ><A NAME="E.G.SAMPLEODBCONLY" ></A ><P ><B >Example 4-4. Sample ODBC-only <TT CLASS="FILENAME" >odbc.ini</TT > file</B ></P ><PRE CLASS="PROGRAMLISTING" > [ODBC Data Sources]<A NAME="AEN1995" HREF="#FTN.AEN1995" ><SPAN CLASS="footnote" >[1]</SPAN ></A > JDBC = Sybase JDBC Server [JDBC] Driver = /usr/local/freetds/lib/libtdsodbc.so Description = Sybase JDBC Server Trace = No Server = jdbc.sybase.com Database = pubs2 Port = 4444 TDS_Version = 5.0 [Default] Driver = /usr/local/freetds/lib/libtdsodbc.so </PRE ></DIV ></P ></DIV ><H3 CLASS="FOOTNOTES" >Notes</H3 ><TABLE BORDER="0" CLASS="FOOTNOTES" WIDTH="100%" ><TR ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="5%" ><A NAME="FTN.AEN1995" HREF="odbcinionly.htm#AEN1995" ><SPAN CLASS="footnote" >[1]</SPAN ></A ></TD ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="95%" ><P >Several DSNs might be listed here. In this example, we have only one, <SPAN CLASS="QUOTE" >"JDBC"</SPAN >. It matches the <TT CLASS="LITERAL" >[JDBC]</TT > entry later in the file.</P ></TD ></TR ></TABLE ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="dsnless.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.htm" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="odbcombo.htm" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >DSN-less configuration</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="prepodbc.htm" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >ODBC-combined configuration</TD ></TR ></TABLE ></DIV ></BODY ></HTML >