FreeTDS Development Group

[Casey Allen Shobe <cshobe AT secureworks.net>]

On Thursday 25 April 2002 09:30, Rick Gigger wrote:
> Unfortunately our experience hasn't been "not a single problem yet" by
> any means.  Just out of curiosity, what version of freetds did you first
> use in production.  You may know something that I don't about setting it
> up in a way that will be less problematic.

I'm using FreeTDS v0.53 to access data on MS SQL Server 2000 running on
Windows 2000 Server.

freetds-0.53 installed with the following options on Sat Jan 26 20:49:12 EST
2002
   ./configure --prefix=/usr --sysconfdir=/etc --with-tdsver=4.2
--with-unixodbc=/usr &&
   make &&
   make install

php-4.1.2 installed with the following options on Thu Apr 25 02:29:14 EDT 2002
   <Hack -lcs, -lcomn, -lsybtcl out of configure script> &&
   ./configure --prefix=/usr --sysconfdir=/etc --without-mysql
--with-unixODBC=/usr --with-apxs=/usr/sbin/apxs --enable-memory-limit
--with-zlib --with-bz2 --with-exec-dir=/www/htdocs --with-openssl=/usr 
--with-config-file-path=/etc --enable-track-vars --with-sybase-ct=/usr 
--enable-java=/usr/java --enable-bcmath &&
   make &&
   make install

/etc/freetds.conf:
[global]
        tds version = 7.0
        initial block size = 512
        swap broken dates = no
        swap broken money = no
        try server login = yes
        try domain login = no
        nt domain = SECUREWORKS
        cross domain login = yes
        dump file = /tmp/freetds.log
        debug level = 10
[192.168.24.6]
        host = 192.168.24.6
        port = 1433
        try domain logins = no
        try server logins = yes
[192.168.24.182]
        host = 192.168.24.182
        port = 1433
        try domain logins = no
        try server logins = yes

PHP include script that connects to the DB2 and MSSQL databases:
<?php

$db2_alias = 'sw_p';
$db2_username = 'xxxxxxxx';
$db2_passwd = 'xxxxxxxx';
$db2_conn = odbc_connect ($db2_alias, $db2_username, $db2_passwd) or die 
('<br><font size="+2"><b>Unable to connect to DB2 Database!!</b></font>');

$piv_alias = '192.168.24.6';
$piv_username = 'xxxxxxxx';
$piv_passwd = 'xxxxxxxx';
$piv_conn = sybase_connect ($piv_alias, $piv_username, $piv_passwd) or die
('<br><font size="+2"><b>Unable to connect to Pivotal
Database!!</b></font>');
sybase_select_db ('xxxxxxxx', $piv_conn);

?>

Hope this helps...

--
Casey Allen Shobe / Network Security Analyst & PHP Developer
SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
cshobe AT secureworks.net / http://www.secureworks.net
Content is my own and does not necessarily represent my company.