<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >ODBC-combined 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="ODBC-only configuration" HREF="odbcinionly.htm"><LINK REL="NEXT" TITLE="Troubleshooting ODBC connections" HREF="odbcdiagnose.htm"><LINK REL="STYLESHEET" TYPE="text/css" HREF="userguide.css"></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="odbcinionly.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="odbcdiagnose.htm" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="ODBCOMBO" >ODBC-combined configuration</A ></H1 ><P >Like the DSN-less configuration, ODBC-combined keeps server properties in <TT CLASS="FILENAME" >freetds.conf</TT >. The difference is that your applications can refer to the server by its DSN. To make that possible, the DSN entry in <TT CLASS="FILENAME" >odbc.ini</TT > refers to the dataserver entry in <TT CLASS="FILENAME" >freetds.conf</TT >. <DIV CLASS="EXAMPLE" ><A NAME="E.G.SAMPLEODBCCOMBO" ></A ><P ><B >Example 4-5. Sample ODBC-combined <TT CLASS="FILENAME" >odbc.ini</TT > file</B ></P ><PRE CLASS="PROGRAMLISTING" >[ODBC Data Sources]<A NAME="AEN1750" HREF="#FTN.AEN1750" ><SPAN CLASS="footnote" >[1]</SPAN ></A > JDBCdsn = Sybase JDBC Server [JDBCdsn] Driver = /usr/local/freetds/lib/libtdsodbc.so Description = Sybase JDBC Server Trace = No Servername = JDBC<A NAME="AEN1754" HREF="#FTN.AEN1754" ><SPAN CLASS="footnote" >[2]</SPAN ></A > Database = pubs2 [Default] Driver = /usr/local/freetds/lib/libtdsodbc.so</PRE ></DIV > <DIV CLASS="EXAMPLE" ><A NAME="E.G.SAMPLECOMBOFILE" ></A ><P ><B >Example 4-6. Sample ODBC-combined <TT CLASS="FILENAME" >freetds.conf</TT > file</B ></P ><PRE CLASS="PROGRAMLISTING" >; ; freetds.conf ; [JDBC] host = jdbc.sybase.com port = 4444 tds version = 5.0</PRE ></DIV > </P ><P >With this arrangement, an application can connect to the server in two ways, via its DSN (<TT CLASS="LITERAL" >JDBCdsn</TT >), or its dataserver name (<TT CLASS="LITERAL" >JDBC</TT >). </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.AEN1750" HREF="odbcombo.htm#AEN1750" ><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" >"JDBCdsn"</SPAN >. It matches the <TT CLASS="LITERAL" >[JDBCdsn]</TT > entry later in the file. </P ></TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="5%" ><A NAME="FTN.AEN1754" HREF="odbcombo.htm#AEN1754" ><SPAN CLASS="footnote" >[2]</SPAN ></A ></TD ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="95%" ><P >Refers to the <TT CLASS="LITERAL" >[JDBC]</TT > entry in <TT CLASS="FILENAME" >freetds.conf</TT >. </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="odbcinionly.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="odbcdiagnose.htm" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >ODBC-only 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" >Troubleshooting ODBC connections</TD ></TR ></TABLE ></DIV ></BODY ></HTML >