> This may not be the best list for my question, but I'm sure someone there will he able to help me There's a mailing list dedicated to DBI-Link, see http://lists.pgfoundry.org/mailman/listinfo/dbi-link-general > 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 Do you know what that Sybase error means? If you know that, maybe you can figure out what's wrong... Does the connection to Sybase depend on environment variables? I have had a problem like this with Oracle and DBI-Link, environment variables of the postmaster didn't make it into DBI-Link functions. If that is your problem, you can use the fifth argument to make_accessor_methods to pass (YAML encoded) environment settings. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
