FreeTDS Development Group

[Rusty Phillips <rustyp AT freeshell.org>]

Shouldn't there be some kind of error message in the logs? I'm 
getting nothing at all.

I actually used my package management system to compile and install it, so 
the location for freetds.conf is /etc/freetds.conf

As far as your suggestion, using the perl script shown below, 
/tmp/tds/config is never created when run through the command line 
or otherwise, though /tmp/tds/normal is.
Shouldn't that do something?

#; use CGI::Carp qw{fatalsToBrowser}
; use DBI
; use Data::Dumper
; my $username = "dbadmin"
; my $password = "purplefish"
; $ENV{'TDSDUMP'} = '/tmp/tds/normal'
; $ENV{'TDSDUMPCONFIG'} = '/tmp/tds/config'
; my $dbh = DBI->connect('dbi:ODBC:IMAGER',$username,$password);
; my $servername = $dbh->selectcol_arrayref('SELECT @@Servername')->[0];
#|| die "Can't connect to database.";
; print "Content-type: text/plain\n\nTesting " . $servername . "\n";



On Thu, 25 Aug 2005, Lowden, James K wrote:

> > From: Scott Edwards
> > Sent: Wednesday, August 24, 2005 9:20 PM
> >
> > I'm attempting to use a MSSQL database from Perl on a FreeBSD
> > machine. I've installed FreeTDS and DBD::Sybase.
> >
> > DBI->connect is returning undef and $DBI::errstr is a literal "no
> > error string" after I attempt to connect to a mssql server.
>
> Failure to connect is either failure to find the server or failure to
> authenticate, probably the former.
>
> One guess: you're using
>         "/usr/local/etc/freetds/freetds.conf".
>
> The default location for that file is
>         "/usr/local/etc/freetds.conf".
>
> Unless you changed the default at configure time, FreeTDS is not reading
> your freetds.conf.
>
> If that's not the problem, I suggest you try TDSDUMP and TDSDUMPCONFIG
> to make sure your file is being read, and to see what response is coming
> back from the server.
>
> HTH.
>
> --jkl
>
> -----------------------------------------
> The information contained in this transmission may be privileged and
> confidential and is intended only for the use of the person(s) named
> above. If you are not the intended recipient, or an employee or agent 
> responsible
> for delivering this message to the intended recipient, any review, 
> dissemination,
> distribution or duplication of this communication is strictly prohibited. If 
> you are
> not the intended recipient, please contact the sender immediately by reply 
> e-mail
> and destroy all copies of the original message. Please note that we do not 
> accept
> account orders and/or instructions by e-mail, and therefore will not be 
> responsible
> for carrying out such orders and/or instructions.  If you, as the intended 
> recipient
> of this message, the purpose of which is to inform and update our clients, 
> prospects
> and consultants of developments relating to our services and products, would 
> not
> like to receive further e-mail correspondence from the sender, please "reply" 
> to the
> sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
> York,
> NY 10105.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds