[Carob] perl to carob

Tue, 22 Aug 2006 07:20:46 -0700

Hello.
 
I  connect from console.sh:
 
localhost:1090 > sql client jdbc:sequoia://localhost/sequoia_cmhostdb
Login > user
Password > pass
jdbc:sequoia://localhost/sequoia_cmhostdb (user)  > select * from table
 
and this work too, I get all records from this table;

 

if I use:

carob version 0.5.2

ODBSequoia version 0.5.2a

Sequoia version   2.8.2

Linux Debian 3.1

db is PostgreSQL

 

use DBI;
use DBD::ODBC;

my $dsn = "dbi:ODBC:seqsource;host=localhost";
my $dbh = DBI->connect($dsn, 'user','pass') or die print "Error".$DBI::errstr;

my $sth = $dbh->prepare('select * from table');
      $sth->execute;
  my $record;
            while($record=$sth->fetchrow_array){
            print "  $record\n";
     }

 

and I have this 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)

 [unixODBC][Driver Manager]Driver does not support this function (SQL-IM001)(DBD: dbd_db_login/SQLSetConnectOption
 err=-1)

 

and sequoia error is:

 

09:16:43,936 WARN  virtualdatabase.VirtualDatabaseWorkerThread.sequoia_cmhostdb Client (login:user,host:localhost.localdomain closed connection with server)

 

Please help me make connection from perl to carob.

 

 

 

Thank you for your help. 

With best wishes

 
 
_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob

Reply via email to