Skip to Content.
Sympa Menu

freetds - Help Freetds 0.53 - removing messages printed to STDERR

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Michael Horowitz" <michael.horowitz AT storagenetworks.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Help Freetds 0.53 - removing messages printed to STDERR
  • Date: Wed, 2 Jan 2002 16:44:33 -0500


Hello,

I am testing out freetds-0.53 for possible use with various versions of
Microsoft SQL Server 7.0 and above. I compiled and installed the distro
on a Solaris 2.6 machine. I am using them through DBD-Sybase-0.94 for use
with the Perl DBI interface. They work great, but there is one little
problem: on connecting they print a message to STDERR with certain
freetds.conf settings. (I need "emulate little endian = yes" or the
datetime fields have their bytes switched.)

For example:
Lets say I have these entries in my freetds.conf file:
[DBNAME1]
host = hostname1.com
port = 9999
tds version = 4.2
emulate little endian = yes
[DBNAME2]
host = hostname2.com
port = 9999
tds version = 7.0

I have a Perl program with this line:
my $dbh = DBI->connect('DBI:Sybase:DBNAME1','user','pass')
or die "Could not connect to database: $DBI::errstr";

After running that line the following is printed out to STDERR:
Changed database context to 'dbname'.

If I do the same connecting to DBNAME2 which uses tds version 7.0 it
prints the following to STDERR:
Changed database context to 'dbname'.
Changed language setting to us_english.

If I remove "emulate little endian = yes" from the DBNAME1 entry, then
those messages are not printed at all to STDERR.

I am not positive that this is done by freetds, and not DBD::Sybase, but
since it changes based on the freetds.conf settings, it seems to indicate
that it comes from the freetds libraries.

I would appreciate it if someone could help me disable those messages from
being printed.

Thank you,
Mike




Archive powered by MHonArc 2.6.24.

Top of Page