X-Git-Url: http://wien.tomnetworks.com/gitweb/?a=blobdiff_plain;f=man%2Fsqlsharp.1;h=9742dd49eabeec0c12b2109b6723d94e022ac9d0;hb=730c189e2141f84c9d6701ac1db73226b3b08daa;hp=bb58b1571cc97aabdf4f3ca38cdd95a02f52524f;hpb=0b1a1f28a4070e932bd7e192fc58ecadd831d128;p=mono.git diff --git a/man/sqlsharp.1 b/man/sqlsharp.1 old mode 100755 new mode 100644 index bb58b1571cc..9742dd49eab --- 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: @@ -344,28 +344,32 @@ ption defaulting to true. PROVIDER NAME NAMESPACE ASSEMBLY -Internal --------- +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 -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 +NOTES: -External to 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 M PostgreSQL Mono.Data.PostgreSqlClient Mono.Data.PostgreSqlClient -DB2 IBM DB2 Mono.Data.DB2Client Mono.Data.DB2Client -Oracle Oracle 8i System.Data.OracleClient System.Data.OracleClient +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 -External to Mono ----------------- +MySql.Data has replaced the mysql provider. If you still need to use ByteFX.Data, then +use bytefx. -Npgsql NetPostgreSQL Npgsql Npgsql -MySQLNet ByteFX MySQL ByteFX.Data.MySQL ByteFX.Data +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 @@ -385,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;password=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 @@ -427,36 +417,40 @@ Oracle via System.Data.OracleClient Data Source=testdb;User ID=scott;Password=tiger -IBM DB2 Universal Database via Mono.Data.DB2Client - - DSN=sample;User ID=db2admin;Password=mysecret - - Npgsql (.NET PostgreSQL) from http://gborg.postgresql.org/project/npgsql/projdisplay.php Server=localhost;Database=test;User ID=postgres;Password=fun2db -MySQLNet (ByteFX MySQL) from -http://sourceforge.net/projects/mysqlnet/ +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 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 +by Daniel Morgan .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: @@ -467,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