FreeTDS Development Group

[Wilson Mak <wilson.mak AT digitalview.com>]

Lowden, James K wrote:

> > From: Christos Zoulas
> > Sent: Thursday, September 22, 2005 8:25 AM
> >
> > On Sep 22,  4:24pm, wilson.mak AT digitalview.com (Wilson Mak) wrote:
> > -- Subject: Re: [freetds] Connection to SQL2000 - Unicode data in
> > a     Unicode-o
> >
> > | Hi Christos,
> > | 
> > | Thanks for your input.  I tried to change it to TDS 8.0, but
> > | still it wont work.  Any clues?
> >
> > No clues, sorry. James and Freddy explained why it is difficult to
> > do this right.
> >    
>
> Wilson, 
>
> Your test was with tsql.  Could you tell us what you're really trying to
> do, and what API you intend to use?  Any fix -- if one is needed --
> won't necessarily be at the tsql level, although it wouldn't be hard to
> show you how to patch it, if that's really what you want.  
>
> If you're looking for a general purpose isql-style tool and aren't using
> ODBC, I'd rather make sure sqsh is up to snuff.  
>
>  
Thanks for your replay.  I try to use Perl (DBD::Sybase) with FreeDTS to 
connect to SQL2K.  It works perfectly with FreeDTS right now - I has 
tested it with TSQL.  But when i use Perl's DBD::Sybase, it got an error 
"panel: malloc" at line xxx. 

Perl:
         BEGIN {
         $ENV{SYBASE} = "/usr/local/freedts";
         }
use DBI;
my $dbh = DBI->connect("dbi:Sybase:SYBASE,database=TEST", 'sa', 
'ssmsadmin', {PrintError => 0, RaiseError => 1,
                           AutoCommit => 1
});
die "Unable for connect to server $DBI::errstr"
   unless $dbh;
my $rv;
my $sth;
               $sql = "SELECT * FROM ABC";
               $sth = $dbh->prepare($sql) || die "Can't prepare the SQL 
statement: $DBI::errstr";
               $sth->execute || die "Can't execute the SQL statement: 
$DBI::errstr";  /*(P.S. broken at this line xxx)*/
               $rv=$sth->execute();
$sth->finish;
$dbh->disconnect;

P.S Some tables can be fetched through this script.  Very Strange!!!

Many thanks,
Wilson

> --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
>
>
>