[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