|
I thank you for your help.
Now I need to set connectivity from perl to postgreSQL with use Carob. I write simple code but it no work.
why?
-------------------------------------------------------------------------------------------------------------
#!/usr/local/bin/perl -w
use DBI; use DBD::ODBC; my $dsn; my $usr; my $pas; $dsn = "dbi:ODBC:seqsource",
$usr='user'; $pas='';
my $dbh=DBI->connect($dsn,$usr,$pas);# or die print "\nmy Error: ".$DBI::errstr."\n"; my $sth = $dbh->prepare("select id,name from mytable"); $sth->execute; my ($id,$name); while(($id,$name)=$sth->fetchrow_array){ print " $id | $name\n"; } -------------------------------------------------------------------------------------------------------------
Settings in 'odbcinst.ini' and 'odbc.ini' is:
odbcinst.ini:
[Sequoia]
Description = Sequoia ODBC driver Driver = libodbsequoia.so Debug = 1 CommLog = 1 FileUsage = 1 LogLevel = DEBUG odbc.ini
[seqsource]
Description = Test Sequoia Driver = Sequoia Servername = localhost Database = sequoia_cmhostdb UserName = user Password = Port = 25322 BackendIdentifiers = [postgresql.org][PG] -------------------------------------------------------------------------------------------------------------
a code gives out an error
DEBUG: (RoundRobinConnectPolicy::getController) Selected
controller[0]:localhost:25322
INFO: (Connection::initConnection) Authenticating with controller localhost:25322 DEBUG: (JavaSocket::Create) Creating socket... DEBUG: (JavaSocket::Create) Socket created. DEBUG: (JavaSocket::connectTo) Connecting... INFO: (JavaSocket::connectTo) Connection to localhost:25322 succeeded DBI connect('seqsource','user',...) failed: [unixODBC][Driver Manager]Driver does not support this function (SQL-IM001)(DBD: dbd_db_login/SQLSetConnectOption err=-1) I usually can try use of libmysequoia to make connection
from perl to db with that code, but it gives error to.
LD_PRELOAD=/usr/lib/libmysequoia.so perl TestCarob03.pl
Error: *** glibc detected *** free(): invalid pointer: 0x08150910
***
Aborted |
_______________________________________________ Carob mailing list [email protected] https://forge.continuent.org/mailman/listinfo/carob
