[Mono-list] nsqlcli

[Chris Aitken]

> Chris Aitken wrote:
> 
> >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've never tested on postgresql and wasn't too sure about the 
> connection string to use.
> 
> Please try:
> 
> $ mono nsqlcli.exe -t postgresql -e "SERVER=192.168.0.5" -d 
> chrisa -u chrisa -p ******
> 
> I'm not sure, but I think that this might work.

Thanks Colin, it did the trick:
chrisa@persephone:~/ASPNET/nsqlcli-0.1a$ mono nsqlcli.exe -t postgresql -e
"SERVER=192.168.0.5" -d chrisa -u chrisa \
 -p ****** -m auto
nsqlcli 0.1a: SQL Command Line Interface.
Copyright (C) 2004 Colin JN Breame (colin@breame.com).

Connecting...established.
Metadata has not been implemented for database type.
Please see db_meta.cs line 71.
Type 'help' for more information.
> list tables
nsqlcli: Metadata is not available for database type or has been disabled
(with -m).
nsqlcli: Quit and type `nsqlcli --help' for more information.
>

I tried it with -m postgresql, and got the same metadat too.

HTH

Chris


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