-.TH sqlsharp 1 "21 October 2004"
+.TH sqlsharp 1 "9 September 2008"
.SH NAME
sqlsharp \- Mono SQL Query command-line tool
.SH SYNOPSIS
Example:
SQL# \\ConnectionString Database=testdb
+ or
+ SQL# \\cs Database=testdb
For more examples, see section CONNECTION STRING EXAMPLES.
Example: to set the provider for MySQL:
SQL# \\provider mysql
+ or
+ SQL# \\p mysql
Note: if you need to load an external provider in SQL#,
see the SQL# command \\loadextprovider
+.fi
+.TP
+.I "ListProviders"
+List ADO.NET 2.0 Providers available
+.nf
+
+Example:
+ SQL# \\ListProviders
+ or
+ SQL# \\listp
+
+.fi
+.TP
+.I "BCS"
+Prompts you for building each connection parameter and builds the connection string
+and also allows you to enter a password wich does not echo.
+.nf
+
+Example:
+ SQL# \\bcs
+
+ ConnectionString Option: Data Source [] SQL# blazer
+
+ ConnectionString Option: Persist Security Info [False] SQL#
+
+ ConnectionString Option: Integrated Security [False] SQL#
+
+ ConnectionString Option: User ID [] SQL# scott
+
+ Password: *****
+
+ ConnectionString Option: Enlist [False] SQL#
+
+ ConnectionString Option: Pooling [True] SQL#
+
+ ConnectionString Option: Min Pool Size [0] SQL#
+
+ ConnectionString Option: Max Pool Size [100] SQL#
+
+ ConnectionString Option: Unicode [False] SQL#
+
+ ConnectionString Option: Load Balance Timeout [0] SQL#
+
+ ConnectionString Option: Omit Oracle Connection Name [False] SQL#
+ ConnectionString is set.
+
.fi
.TP
.I "LoadExtProvider"
PROVIDER NAME NAMESPACE ASSEMBLY
-Oracle Oracle 8i System.Data.OracleClient System.Data.OracleClient
-PostgreSql NetPostgreSQL Npgsql Npgsql
-MySQL 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
-OleDb 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
+oracle Oracle 8i-11g System.Data.OracleClient System.Data.OracleClient
+postgresql NetPostgreSQL Npgsql Npgsql
+bytefx ByteFX MySQL ByteFX.Data.MySqlClient ByteFX.Data
+sqlclient MS SQL 7-2008 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
+firebird Firebird SQL FirebirdSql.Data.FirebirdSql FirebirdSql.Data.Firebird
+mysql MySQL AB MySql.Data.MySqlClient MySql.Data
+
+NOTES:
-NOTES
+Ngsql is the .Net Data Provider for PosgreSQL. The
+latest verison can be downloaded from
+http://npgsql.projects.postgresql.org/
-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
-Firebird is not included with Mono.
+MySql.Data is the MySQL Connector/Net for connecting to MySql databases.
+For MySQL, it is strongly recommend to use MySql.Data instead of the old
+ByteFX.Data provider. Unfortunately, MySql.Data is not included with Mono.
+You can download the latest MySQL Connector/Net from MySQL AB at
+http://dev.mysql.com/downloads/
+
+FirebirdSql.Data.Firebird can be downloaded from here:
+http://www.firebirdsql.org/index.php?op=files&id=netprovider
.fi
.SH CONNECTION STRING SAMPLES
Microsoft SQL Server via System.Data.SqlClient
-or Mono.Data.TdsClient provider:
- Server=DANPC;Database=pubs;User ID=saPassword=
+ Server=DANPC;Database=pubs;User ID=saPassword=;
+
+ For Integrated Security, bear in mind that Mono is not
+ integrated with Windows, SQL Server client nor server, nor
+ Windows Server. Therefore, you must provide the Windows Domain
+ name and domain user name and password for this user.
+
+ Server=DANPC;Database=pubs;User ID=DOMAIN\user;Password=pass;Integrated Security=SSPI
+ For a server locally, you can use localhost.
ODBC via System.Data.Odbc provider using
a DSN named "MSSQLDSN" I set up
DSN=MSSQLDSN;UID=danmorg;PWD=freetds
+To use ODBC ON Unix, consider unixODBC from http://www.unixodbc.org/
+or use iODBC from http://www.iodbc.org/
SQL Lite via Mono.Data.SqliteClient
provider which connects to the
URI=file:SqliteTest.db
-
-OLE DB via System.Data.OleDb provider
-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
+ If you prefer to not use a tnsnames.ora file, you can
+ use a connection string which allows a
+ TNS network description that is parentheses delimited
+ like the following which has the host, port, and
+ service name. For host, you can specify an IP address
+ instead of a hostname.
+
+User ID=SCOTT;
+Password=TIGER;
+Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TESTDB)))
+
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
+
+ Please use MySql.Data instead.
Server=localhost;Database=test;User ID=mysql;Password=
-FirebirdSql via FirebirdSql.Data.Firebird (not included with Mono)
+
+FirebirdSql via FirebirdSql.Data.Firebird (download latest form FirebirdSql.org)
Database=C:\\FIREBIRD\\EXAMPLES\\EMPLOYEE.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=localhost
+MySQL via (MySql.Data) MySQL Connector/Net 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 Query Tool was written
.nf
-by Daniel Morgan <danielmorgan@verizon.net>
+by Daniel Morgan <monodanmorg@yahoo.com>
.fi
.PP
.SH LICENSE
.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:
.fi
.PP
.SH SEE ALSO
-mono(1), mint(1)
+mono(1)