Skip to Content.
Sympa Menu

freetds - Re: Thanks, Developers of FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Casey Allen Shobe <cshobe AT secureworks.net>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Thanks, Developers of FreeTDS
  • Date: Fri, 26 Apr 2002 18:35:52 -0400


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.




Archive powered by MHonArc 2.6.24.

Top of Page