[MonetDB-users] SQL: Connect To statement, help request
I could use some pointers since I have trouble getting something started
I have 2 machines ow138 ip:146.50.7.21 and ow139 ip:146.50.9.30 Both machines run a database with the name of the machine Merovingian is running on both systems
monetdb discover
location mapi:monetdb://ow139:50000/ow139 mapi:monetdb://ow138:50000/ow138
I would like to connect these databases using SQL: CONNECT TO statement, however I cannot seem to get past syntax errors etc.
Thus something like
mclient -lsql -d ow138
sql> CONNECT TO ow139 .....
Can someone please help me fill in the dots
On 21-10-2009 15:04:46 +0200, Bart Buter wrote:
I could use some pointers since I have trouble getting something started
I have 2 machines ow138 ip:146.50.7.21 and ow139 ip:146.50.9.30 Both machines run a database with the name of the machine Merovingian is running on both systems
monetdb discover
location mapi:monetdb://ow139:50000/ow139 mapi:monetdb://ow138:50000/ow138
I would like to connect these databases using SQL: CONNECT TO statement, however I cannot seem to get past syntax errors etc.
Thus something like
mclient -lsql -d ow138
sql> CONNECT TO ow139 .....
we don't support this.
Just use mclient -lsql -d ow139 and your merovingian will redirect you to ow139.
participants (2)
-
Bart Buter -
Fabian Groffen