Hi "sylver_b",
just a simple & quick saniy check:
How did you start your MonetDB server?
Can you connect with `mclient -lsql`?
Stefan
On Tue, Sep 09, 2008 at 04:56:47PM -0700, sylver_b wrote:
Hi Eveyone,
I'm trying to connect to monetdb with this time, ODBC - but still no luck.
Here is the output of my script :
./monetdb2.pl DBI connect('DSN_MonetDB','monetdb',...) failed: [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1) at ./monetdb2.pl line 6 [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection (SQL-08001)(DBD: db_login/SQLConnect err=-1)
cat monetdb2.pl #!/usr/bin/perl
use DBI();
my $dbh = DBI-> connect('dbi:ODBC:DSN_MonetDB', 'monetdb', 'monetdb', {database => demo}) or die ($DBI::errstr . "\n");
if (!$dbh) { print "$DBI::err\n$DBI::errstr\n$DBI::state"; } else { $dbh->disconnect if ($dbh); }
my $sth = $dbh->prepare('SELECT * FROM env() env'); $sth->execute; $sth->dump_results;
This the merovingian output : tail -f /root/MonetDB/var/log/merovingian.log MSG demo[11229]: # MonetDB server v5.6.0, based on kernel v1.24.0 MSG demo[11229]: # Serving database 'demo' MSG demo[11229]: # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked MSG demo[11229]: # Copyright (c) 1993-2008 CWI, all rights reserved MSG demo[11229]: # Visit http://monetdb.cwi.nl/ for further information MSG demo[11229]: # Listening for connection requests on mapi:monetdb://ulys:50001/ ERR merovingian[11224]: client error: no database specified MSG merovingian[11224]: database 'demo' already running since 2008-09-10 00:17:32, up min/avg/max: 30/2181/7036, crash average: 0.00 0.00 0.00 (6-5=0) MSG merovingian[11224]: proxying client 127.0.0.1:59244 for database 'demo' to mapi:monetdb://ulys:50001/ MSG merovingian[11224]: client has 127.0.0.1:59244 disconnected from proxy
ERR merovingian[11224]: client error: no database specified
This is the content of my odbc.ini & odbcinst.ini :
[DSN_MonetDB] Description = ODBC Driver for MonetDB SQL Server Driver = /root/MonetDB/lib/libMonetODBC.so Port = 50000 Host = localhost Database = demo User = monetdb Password = monetdb Debug = 1 Trace = 1 DebugFile = /var/log/odbc-debugfile.log TraceFile = /var/log/odbc-tracefile.log
odbcinst.ini [DSN_MonetDB] Description = ODBC Driver for MonetDB SQL Server Driver = /root/MonetDB/lib/libMonetODBC.so Setup = /root/MonetDB/lib/libMonetODBCs.so FileUsage = 1 CommLog = 1 Debug = 1
I also tried with PHP odbc, same result - how to specify the DB right from the script ?
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers