[freetds] Connection to SQL2000 - Unicode data ina Unicode-only collation

Wilson Mak wilson.mak at digitalview.com
Mon Sep 26 05:31:15 EDT 2005


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




More information about the FreeTDS mailing list