DBD::Sybase

I managed to get DBD::Sybase installed and working by doing this as root:

cat /opt/sybase/OCS-15_0/lib > /etc/ld.so.conf.d/sybase.conf
/sbin/ldconfig

#!/usr/bin/perl -w

# import modules
use strict;
use DBI;
use Data::Dumper;

# connection details
my $database = 'master';
my $server = 'VMCENTOS43';
my $username = 'testuser';
my $password = 'testpwd';

# connect to sybase
my $dbh;
eval {
	$dbh = DBI->connect("DBI:Sybase:server=$server;database=$database",
		$username, $password, {RaiseError => 1, AutoCommit => 0});
};

# check for errors
if ($@) {
	print DBI::errstr;
}
else {
	# limit results
	$dbh->do('set rowcount 5');

	# prepare and execute sql
	my $sth = $dbh->prepare('select * from spt_values');
	$sth->execute;

	# loop through results, printing to debugger
	while (my $data = $sth->fetchrow_hashref()) {
		print Dumper $data;
	}

	# finish statement and disconnect from db
	$sth->finish;
	$dbh->disconnect;
}

I’ve also found that the TinyMCE editor (even in HTML mode) doesn’t like the quickcode tags, so I have to use BloGTK as my editor, I’m currently trying out the Codesnippet plugin, which has nice syntax-highlighting, but doesn’t have the nice scrollbars and hide/show functionality.