dbi-link with Sybase

From: fernando(at)lozano(dot)eti(dot)br
To: pgsql-general(at)postgresql(dot)org
Subject: dbi-link with Sybase
Date: 2009-12-26 22:30:30
Message-ID: 4b368e86.351.4d78.1561299114@lozano.eti.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2009-12-26 22:54:26 Re: Finding the bin path
Previous Message Allan Kamau 2009-12-26 13:12:34 Re: Session based transaction!!