[Mono-list] nsqlcli

[Chris Aitken]

> Introducing nsqlcli: SQL Command Line Interface http://nsqlcli.sf.net
> 
> This is written in C# and allows connection to any database 
> supported by .Net.  It is similar in function to the mysql 
> cli client.  It also provides some metadata about the 
> connected database.
> 
> I've only tested it using the MS SQL provider and I was 
> hoping to find people who would be willing to test on MySql, 
> Postgresql and other databases using the standard mono distribution.
> 
> There are a few missing features (notably readline support) 
> but the core functionality is all there.

I am trying this under Debian (mono 1.0.3), with PostgreSQL.

I have tried:

chrisa@persephone:~/ASPNET/nsqlcli-0.1a$ mono nsqlcli.exe -t postgresql -h
192.168.0.5 -d chrisa -u chrisa -p ****** -m postgresql --stdin
nsqlcli 0.1a: SQL Command Line Interface.
Copyright (C) 2004 Colin JN Breame (colin@breame.com).

Connecting...
nsqlcli: Connection string argument missing!
Parameter name: SERVER
nsqlcli: Connection string:
Address=192.168.0.5;Database=chrisa;UID=chrisa;PWD=<censored>
nsqlcli: Could not open connection.

I can see from this that the connection string must be used:
 
-c, --connection-type[=TYPE-STRING] The type string of the database library
                                        connection class.  This is the
string
                                        that would be passed to
                                        System.Type.GetType and can be
obtained
                                        using gacutil -l.

I do not have gacutil on my debian system, but it exists on my windows
version mono. But it mentions nothing about a connection string in all the
guff it produces?

Any chance of a sample input?

Cheers

Chris


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.