Added IL regression data (not enabled yet)

[mono.git] / man / sqlsharp.1

diff --git a/man/sqlsharp.1 b/man/sqlsharp.1
old mode 100755 (executable)
new mode 100644 (file)
index 5353280..9742dd4
--- a/man/sqlsharp.1
+++ b/man/sqlsharp.1
@@ -1,18 +1,18 @@
-.TH sqlsharp 1 "10 December 2002"
+.TH sqlsharp 1 "25 December 2005"
 .SH NAME 
-sqlsharp \- Mono SQL# command-line SQL Query tool
+sqlsharp \- Mono SQL Query command-line tool
 .SH SYNOPSIS
 .B sqlsharp 
 [\-f filename] [\-o filename] [\-s]
 .SH DESCRIPTION
-sqlsharp is the Mono SQL# tool used for entering SQL queries
-to a database using Mono ADO.NET providers.
+sqlsharp is a Mono SQL tool used for entering SQL queries
+to a database using Mono data providers.
 .PP
 .SH OPTIONS
 The following options are supported:
 .TP
 .I "-f filename"
-Output file to load SQL# commands from.
+Output file to load SQL commands from.
 .TP
 .I "-o filename"
 Output file to send results.
@@ -21,7 +21,7 @@ Output file to send results.
 Silent mode.
 .PP
 .SH HOW TO USE
-The SQL# tool accepts commands via its command line interface.  Commands
+The SQL tool accepts commands via its command line interface.  Commands
 begin with a backslash followed by the command name.
 .PP
 Example:
@@ -342,16 +342,34 @@ ption defaulting to true.
 .SH PROVIDERS
 .nf
 
-PROVIDER    NAME          NAMESPACE                  ASSEMBLY
+PROVIDER   NAME          NAMESPACE                  ASSEMBLY
 
-OleDb       OLE DB        System.Data.OleDb          System.Data 
-SqlClient   MS SQL 7/2000 System.Data.SqlClient      System.Data
-Odbc        ODBC          System.Data.Odbc           System.Data
-MySql       MySQL         Mono.Data.MySql            Mono.Data.MySql
-Sqlite      SQL Lite      Mono.Data.SqliteClient     Mono.Data.SqliteClient
-Sybase      Sybase        Mono.Data.SybaseClient     Mono.Data.SybaseClient
-Tds         TDS Generic   Mono.Data.TdsClient        Mono.Data.TdsClient
-PostgreSql  PostgreSQL    Mono.Data.PostgreSqlClient Mono.Data.PostgreSqlClient
+oracle     Oracle 8i     System.Data.OracleClient   System.Data.OracleClient
+postgresql NetPostgreSQL Npgsql                     Npgsql
+bytefx     ByteFX MySQL  ByteFX.Data.MySqlClient    ByteFX.Data
+sqlclient  MS SQL 7/2000 System.Data.SqlClient      System.Data
+odbc       ODBC          System.Data.Odbc           System.Data
+sqlite     SQL Lite      Mono.Data.SqliteClient     Mono.Data.SqliteClient
+sybase     Sybase        Mono.Data.SybaseClient     Mono.Data.SybaseClient
+olebb      OLE DB        System.Data.OleDb          System.Data 
+tds        TDS Generic   Mono.Data.TdsClient        Mono.Data.TdsClient
+msodbc     MS ODBC       Microsoft.Data.Odbc        Microsoft.Data.Odbc
+firebird   Firebird SQL  FirebirdSql.Data.FirebirdSql FirebirdSql.Data.Firebird
+mysql      MySQL AB      MySql.Data.MySqlClient     MySql.Data
+
+NOTES:
+
+npgsql maps to postgresql above.
+mysqlnet maps to mysql above.
+odbc is treated as an external provider for .NET 1.1 and above.
+msodbc is an external provider for compatibility with .NET 1.0
+
+MySql.Data has replaced the mysql provider.  If you still need to use ByteFX.Data, then
+use bytefx.
+
+MySql.Data is not included with Mono.  You need to 
+download the MySQL Connector/Net from MySQL AB at
+http://dev.mysql.com/downloads/connector/net/1.0.html
 
 .fi
 .SH CONNECTION STRING SAMPLES
@@ -371,20 +389,6 @@ or Mono.Data.TdsClient provider:
 
        Server=DANPC;Database=pubs;User ID=saPassword=
 
-               
-PostgreSQL via Mono.Data.PostgreSqlClient provider:
-
-       host=localhost;dbname=test;user=postgres;pass=fun2db
-
-                         or
-
-       Server=localhost;Database=test;User ID=postgres;Password=fun2db
-
-               
-MySQL via Mono.Data.MySql provider:
-
-       Server=localhost;Database=test;User ID=mysql;Password=
-
        
 ODBC via System.Data.Odbc provider using 
 a DSN named "MSSQLDSN" I set up 
@@ -407,20 +411,46 @@ which connects to a PostgreSQL database:
 
        Provider=PostgreSQL;Addr=127.0.0.1;Database=rodrigo
 
+               
+Oracle via System.Data.OracleClient
+
+       Data Source=testdb;User ID=scott;Password=tiger
+
+               
+Npgsql (.NET PostgreSQL) from 
+http://gborg.postgresql.org/project/npgsql/projdisplay.php
+
+       Server=localhost;Database=test;User ID=postgres;Password=fun2db
+
+               
+ByteFX (ByteFX MySQL) from 
+
+       Server=localhost;Database=test;User ID=mysql;Password=
+
+
+FirebirdSql via FirebirdSql.Data.Firebird (not included with Mono)
+
+       Database=C:\\FIREBIRD\\EXAMPLES\\EMPLOYEE.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=localhost
+
+
+MySQL (MySQL AB) from http://www.mysql.com/
+
+       Server=localhost;Database=test;User ID=mysql;Password=mypass;Pooling=false
+
 
 .fi
-.SH DEBUGGING SUPPORT
-No debugging support.
+.SH TRACING SUPPORT
+No support for tracing right now.
 .SH AUTHORS
-The Mono SQL# Tool was written 
+The Mono SQL Query Tool was written 
 .nf
-by Daniel Morgan <danmorg@sc.rr.com>
+by Daniel Morgan <danielmorgan@verizon.net>
 .fi
 .PP
 .SH LICENSE
-The Mono SQL# Tool is released under the terms of the GNU GPL.
+The Mono SQL Query Tool is released under the terms of the GNU GPL.
 Please read the accompanying `COPYING' file for details.  Alternative
-licenses are available from Ximian or Daniel Morgan.
+licenses are available from Novell or Daniel Morgan.
 .SH BUGS
 To report bugs in the compiler, you can use `bug-buddy', or you can
 file bug reports in our bug tracking system:
@@ -431,12 +461,12 @@ http://bugzilla.ximian.com.
 .SH MAILING LISTS
 For details, visit:
 .nf
-http://mail.ximian.com/mailman/mono-list 
+http://lists.ximian.com/mailman/listinfo/mono-devel-list
 .fi
 .SH WEB SITE
 For details, visit: 
 .nf
-http://www.go-mono.com 
+http://www.mono-project.com 
 .fi
 .PP
 .SH SEE ALSO