论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2009-05-20 17:01 |只看该作者 |倒序浏览

5可用积分

此贴已改
#!/usr/bin/perl

use DBI;

$dsn = 'DBI:Sybase:server=sql1';

my $dbh = DBI->connect($dsn, "test", 'test');
die "unable to connect to server $DBI::errstr" unless $dbh;

$dbh->do("use sqltest";

$query = "SELECT * FROM testtable";
$sth = $dbh->prepare ($query) or die "prepare failed\n";
$sth->execute( ) or die "unable to execute query $query error $DBI::errstr";

$rows = $sth->rows ;
print "$row rows returned by query\n";

while ( @first = $sth->fetchrow_array ) {
foreach $field (@first) {
   print "field: $field\n";
}
}

[root@nagios ~]# ./a
Segmentation fault
[root@nagios ~]#

————————————————————————————————————————————

/etc/freetds.conf文件内容为：
[sql1]
      host = fabu
      port = 1433
      tds version = 4.2

——————————————————————————
[root@nagios ~]# ping fabu
PING fabu (192.168.3.235) 56(84) bytes of data.
64 bytes from fabu (192.168.3.235): icmp_seq=0 ttl=128 time=1.81 ms

--- fabu ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 1.810/1.810/1.810/0.000 ms, pipe 2
[root@nagios ~]#

为什么这个程序不行呢我按照文档说的是运行tsql没有问题啊

[root@nagios ~]# tsql -S fabu -U test
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
1>
2>

多谢各位老大了我想之前的程序有问题应该也是一样吧？
抑或我的DBD::SYBASE

[ 本帖最后由 ppiqq 于 2009-6-1 16:39 编辑 ]

最佳答案

MMMIX

查看完整内容

你用嘛发行版？搜索过么？BTW，我倒是搜索了一下http://www.google.com/search?hl=en&q=rpm+dbd+sybase&aq=f&oq=&aqi=

文库|博客

MMMIX

广告杀手

论坛徽章:: 95

2楼 [报告]

发表于 2009-05-20 17:01 |只看该作者

原帖由 ppiqq 于 2009-6-1 16:18 发表

报告大大这个真的没有

你用嘛发行版？搜索过么？

BTW，我倒是搜索了一下
http://www.google.com/search?hl= ... =f&oq=&aqi=

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

ppiqq

家境小康

论坛徽章:: 0

3楼 [报告]

发表于 2009-05-20 17:02 |只看该作者

小弟看到了
If the automatic configuration fails, then you will have to edit the
CONFIG file, and set the EXTRA_LIBS entry according to your OS and
Sybase release, and then run
      perl Makefile.PL --file

The CONFIG file can be used to set certain system variables that
are needed for the build.
      SYBASE is the root directory of your Sybase installation. DBD::Sybase
      will use $SYBASE/lib and $SYBASE/include during the build.

      EXTRA_LIBS lists any extra libraries that are required on your
      system. For example, Solaris 2.x needs -ltli. See your OS specific
      documentation supplement from Sybase to determine what is required.

      DBI_INCLUDE is the directory where DBI installed its include files.
      Makefile.PL will normally deduce this directory from perl's Config
      module, so you only need to set this if Makefile.PL fails.

      LINKTYPE. Uncomment and set to 'static' if you want to build
      DBD::Sybase statically (ie always included in a new perl binary).