# # # $Id: freetds.conf,v 1.9 2003/12/04 22:26:55 freddy77 Exp $ # # The freetds.conf file is a replacement for the original interfaces # file developed by Sybase. You may use either this or the interfaces # file, but not both. # # FreeTDS will search for a conf file in the following order: # # 1) check if a file was set programatically via dbsetifile() and # is in .conf format, if so use that, # # 2) otherwise, if env variable FREETDSCONF specifies a properly # formatted config file, use it, # # 3) otherwise, look in ~/.freetds.conf, # # 4) otherwise, look in @sysconfdir@/freetds.conf # # If FreeTDS has found no suitable conf file it will then search for # an interfaces file in the following order: # # 1) check if a file was set programatically via dbsetifile() and # is in interfaces format, if so use that, # # 2) look in ~/.interfaces # # 3) look in $SYBASE/interfaces (where $SYBASE is an environment # variable) # # Only hostname, port number, and protocol version can be specified # using the interfaces format. # # The conf file format follows a modified Samba style layout. There # is a [global] section which will affect all database servers and # basic program behaviour, and a section headed with the database # server's name which will have settings which override the global # ones. # # Note that environment variables TDSVER, TDSDUMP, TDSPORT, TDSQUERY, # and TDSHOST will override values set by a .conf or .interfaces file. # # To review the processing of the above, set env variable TDSDUMPCONFIG # to a file name to log configuration processing. # # Global settings, any value here may be overridden by a database # server specific section [global] # TDS protocol version tds version = 4.2 ; initial block size = 512 # uses some fixes required for some bugged MSSQL 7.0 server that # return invalid data to big endian clients # NOTE TDS version 7.0 or 8.0 should be used instead ; swap broken dates = no ; swap broken money = no # Database server login method, if both server and domain # logins are enabled, domain login is tried first if a domain # is specified, and if that fails the server login will be used. # OBSOLETE ; try server login = yes ; try domain login = no # The default authentication domain, can be overridden by # specifying a username with a domain prefix, e.g. DOMAIN\username # OBSOLETE use DOMAIN\username as username ; nt domain = WORKGROUP # If the server responds with different domain try that one? # OBSOLETE never been used ; cross domain login = no # Whether to write a TDSDUMP file for diagnostic purposes # (setting this to /tmp is insecure on a multi-user system) ; dump file = /tmp/freetds.log ; debug level = 10 # Command and connection timeouts ; timeout = 10 ; connect timeout = 10 # If you get out of memory errors, it may mean that your client # is trying to allocate a huge buffer for a TEXT field. # (Microsoft servers sometimes pretend TEXT columns are # 4 GB wide!) If you have this problem, try setting # 'text size' to a more reasonable limit text size = 64512 # This is a Sybase hosted database server, if you are directly on the # net you can use it to test. #[JDBC] # host = 192.138.151.39 # port = 4444 # tds version = 5.0 # The same server, using TDS 4.2. Used in configuration examples for the # pool server, since the pool server supports only TDS 4.2. #[JDBC_42] # host = 192.138.151.39 # port = 4444 # tds version = 4.2 # The client connecting to the pool server will use this to find its # listening socket. This entry assumes that the client is on the same # system as the pool server. #[mypool] # host = 127.0.0.1 # port = 5000 # tds version = 4.2 # A typical Microsoft SQL Server 7.0 configuration ;[MyServer70] ; host = ntmachine.domain.com ; port = 1433 ; tds version = 7.0 # A typical Microsoft SQL Server 2000 configuration ;[MyServer2k] ; host = ntmachine.domain.com ; port = 1433 ; tds version = 8.0 # A typical Microsoft SQL Server 6.x configuration ;[MyServer65] ; host = ntmachine.domain.com ; port = 1433 ; tds version = 4.2 # rsmbobbn [MSSQL_FIBS] host = 194.95.207.84 port = 1433 tds version = 7.0 client charset = UTF-8