Skip to Content.
Sympa Menu

freetds - Re: 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: Re: Help Freetds 0.53 - removing messages printed to STDERR
  • Date: Wed, 2 Jan 2002 17:11:38 -0500


I am not sure what I should be looking for, but this is what I get back:

DBI 1.20-nothread dispatch trace level set to 3
Note: perl is running without the recommended perl -w option
-> DBI->connect(DBI:Sybase:DBNAME1, username, ****)
-> DBI->install_driver(Sybase) for solaris perl=5.006 pid=19266 ruid=0
euid=0
install_driver: DBD::Sybase version 0.94 loaded from
/opt/perl-5.6.0/lib/site_perl/5.6.0/sun4-solaris/DBD/Sybase.pm
New DBI::dr (for DBD::Sybase::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x1703dc)=>DBI::dr=HASH(0xfb4c8),
DBD::Sybase::dr, 0, Null!)
dbih_make_com(Null!, DBD::Sybase::dr, 84)
<- install_driver= DBI::dr=HASH(0x1703dc)
-> connect for DBD::Sybase::dr (DBI::dr=HASH(0x1703dc)~0xfb4c8
'DBNAME1' 'username' **** HASH(0xef160))
New DBI::db (for DBD::Sybase::db, parent=DBI::dr=HASH(0xfb4c8), id=)
dbih_setup_handle(DBI::db=HASH(0xfb480)=>DBI::db=HASH(0x1acfc8),
DBD::Sybase::db, 170130, Null!)
dbih_make_com(DBI::dr=HASH(0xfb4c8), DBD::Sybase::db, 1960)
Changed database context to 'dbname'.
syb_db_login() -> checking for chained transactions
syb_db_login() -> chained transactions are supported
<- connect= DBI::db=HASH(0xfb480) at DBI.pm line 426
-> STORE for DBD::Sybase::db (DBI::db=HASH(0x1acfc8)~INNER
'PrintError' 1)
STORE DBI::db=HASH(0x1acfc8) 'PrintError' => 1
<- STORE= 1 at DBI.pm line 451
-> STORE for DBD::Sybase::db (DBI::db=HASH(0x1acfc8)~INNER
'AutoCommit' 1)
<- STORE= 1 at DBI.pm line 451
<- connect= DBI::db=HASH(0xfb480)
<> DESTROY ignored for outer handle DBI::db=HASH(0xfb480) (inner
DBI::db=HASH(0x1acfc8))
-> DESTROY for DBD::Sybase::db (DBI::db=HASH(0x1acfc8)~INNER)
syb_db_disconnect() -> ct_close()
<- DESTROY= undef
-- DBI::END
-> disconnect_all for DBD::Sybase::dr (DBI::dr=HASH(0x1703dc)~0xfb4c8)
<- disconnect_all= 1 at DBI.pm line 468
-> DESTROY in DBD::_::common for DBD::Sybase::dr
(DBI::dr=HASH(0xfb4c8)~INNER)
<- DESTROY= undef during global destruction
<> DESTROY for DBI::dr=HASH(0x1703dc) ignored (inner handle gone)

Thanks,

Mike

> Michael Horowitz writes:
> >
> > 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.
>
> Add a DBI->trace(3) call before the DBI->connect(), and check the
> trace for various error messages coming from the server. I check for
> these messages in the server callback, but it is possible that MSSQL
> uses a different error numbering than Sybase.
>
> Alternatively there is a problem with the error numbers when emulating
> little endian in the FreeTDS code.
>
> Michael
> --
> Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
> mpeppler AT peppler.org - mpeppler AT mbay.net
> International Sybase User Group - http://www.isug.com




Archive powered by MHonArc 2.6.24.

Top of Page