dbi-link with Sybase - Mailing list pgsql-general

Hi there,

This may not be the best list for my question, but I'm sure someone there will he able to help me
;-)

I'm trying to use dbi-link under RHEL5.3. Using PostgreSQL and Perl rpms from distro, installed
Sybase ASE 1.5.5 developers edition and DBD::Sybase using cpan -i.

My test programs, using pubs2 example database, work fine. They connect as:

$dbh = DBI->connect("dbi:Sybase:server=RHEL53I386", "teste", "123testando");

So I have a working DBD::Sybase install. But then I try to initialize dbi-link using the statement:

SELECT make_accessor_functions(
    'dbi:Sybase:server=RHEL53I386',
    'teste',
    '123testando',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'pubs2'
);

I get the error (from postgresql logs)

OpenClient message: LAYER = (7) ORIGIN = (2) SEVERITY = (6) NUMBER = (6)
Message String: ct_con_alloc(): unable to get layer message string: unable to ge
t origin message string: error string not available
NOTICE:  ct_con_alloc failed at /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread
-multi/DBD/Sybase.pm line 92.

CONTEXT:  SQL statement "SELECT dbi_link.cache_connection( 1 )"
        SQL statement "SELECT dbi_link.create_accessor_methods(
            'pubs2',
            NULL,
            NULL,
            'dbi:Sybase:server=RHEL53I386',
            'teste',
            '123testando',
            1
        )
        "
ERROR:  error from Perl function: error from Perl function: error from Perl func
tion: DBI connect('server=RHEL53I386','teste',...) failed: (no error string) at
line 137 at line 36. at line 53.

I already tried forcing my database to en_US.UTF-8 and sourced SYBASE.sh from postgres bash_profile
script. Before that, the error was aboit missing dynamic libs.

I know this looks more a sybase thing than a postgresql thing but maybe someone can understand the
sybase error message and help me. After all I hope someone out there does use dbi-link


[]s, Fernando Lozano