Skip to Content.
Sympa Menu

freetds - some troubles

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Alexander Titaev" <tit AT irk.ru>
  • To: freetds
  • Subject: some troubles
  • Date: Fri, 16 Jun 2000 22:30:59


i have

freebsd 3.4
perl5.005
freetds (last stable)
DBD-Sybase-0.22
DBI-1.13

and MS SQL 7 on win2000

my perl script only insert data to sql server. Regularly when the length
insert query becomes more critical I receive the following message on a
mistake
for example
$string="sp_ADD_TRACE '20000617 01:36:51', 'oasis.irk.ru', 195.113.31.123',
'195.206.40.161', '2.428', '195.206.40.101', '6.664', '195.206.40.211',
'7.652', '194.186.0.49', '79.37', '194.186.157.113', '188.896',
'194.67.16.193', '139.936', '194.186.157.162', '127.784', '195.158.226.53',
'142.914', '192.121.154.153', '119.834', '195.158.226.82', '134.901',
'195.
158.247.38', '170.672', '195.158.235.34', '182.325', '195.158.235.38',
'134.028', '195.158.236.30', '148.033', '192.121.157.102', '158.232',
'195.113.144.5', '140.199', '195.113.69.105', '176.359', '195.113.68.129',
'151.725', '195.113.30.2', '146.265', '195.113.31.123', '156.924'";
$sth = $dbh->prepare($string);
$rc=$sth->execute || die "Can't prepare the SQL statement: $DBI::errstr";

Can't prepare the SQL statement: Server message number=10018 severity=9
state=0 line=0 server=OpenClient text=The connection was closed

i did and ./configure --with-tdsver=7.0 and ./configure --with-tdsver=5.0
and ./configure --with-tdsver=4.2, but this problem does not disappear

help me please



  • some troubles, Alexander Titaev, 06/16/2000

Archive powered by MHonArc 2.6.24.

Top of Page