fsgateway(1) [debian man page]

FSGATEWAY(1)						      General Commands Manual						      FSGATEWAY(1)

NAME

       fsgateway - FUSE module to browse database's metadata, sugar datastores and xml files

SYNOPSIS

       mono fsgateway storage_type connection_string [fuse_option] mountpoint

DESCRIPTION

       FsGateway allows you to use your preferred directory navigation tool to inspect a database's metadata, sugar datastores and xml files.

       FsGateway  allows  you to compare two database structures in an easy way using the diff tool, or to find where a field is defined using the
       grep tool.

   storage_type can be:
       tagfs
	   You must provide the root directory of tree to examine as connection_string parameter.

       xmlfs
	   You must provide the need the XML file to read as connection_string parameter.

       postgresql
	   Specify the connection_string parameter like this one:
	       Server=localhost; Database=mydb; User ID=username; Password=password; Port=5432;

       sugar_datastore
	   You must specify the directory used by the Sugar datastore as connection_string parameter.

       MySQL5
	   Specify the connection_string parameter like this one:
	       Server=localhost; Database=mydb; User ID=username; Password=password; Port=3306;

       SqlServer
	   Specify the connection_string parameter like this one:
	       Server=localhost,port; Database=mydb; User ID=username; Password=password;
	   or like this one:
	       Server=localhost,port; Database=mydb; User ID=domainnameusername; Password=password; Integrated Security=SSPI
	   For detail information about the parameters connection look at http://www.mono-project.com/SQLClient

SEE ALSO

       fusermount(1)

AUTHOR

       fsgateway was written by Torello Querci <torello@torosoft.com>

       This manual page was written by Marco Nenciarini <mnencia@debian.org>, for the Debian project (and may be used by others).

								   January 2010 						      FSGATEWAY(1)

PDO_SQLSRV-DSN(3)							 1							 PDO_SQLSRV-DSN(3)

PDO_SQLSRV DSN - Connecting to MS SQL Server and SQL Azure databases

	The PDO_SQLSRV Data Source Name (DSN) is composed of the following elements:

	      o DSN prefix
		- The DSN prefix is sqlsrv:.

	      o APP - The application name used in tracing.

	      o ConnectionPooling - Specifies whether the connection is assigned from a connection pool (1 or TRUE) or not (0 or FALSE).

	      o Database - The name of the database.

	      o Encrypt - Specifies whether the communication with SQL Server is encrypted (1 or TRUE) or unencrypted (0 or FALSE).

	      o Failover_Partner  - Specifies the server and instance of the database's mirror (if enabled and configured) to use when the primary
		server is unavailable.

	      o LoginTimeout - Specifies the number of seconds to wait before failing the connection attempt.

	      o MultipleActiveResultSets - Disables or explicitly enables support for multiple active Result sets (MARS).

	      o QuotedId - Specifies whether to use SQL-92 rules for quoted identifiers (1 or TRUE) or to use  legacy  Transact-SQL  rules  (0	or
		false).

	      o Server - The name of the database server.

	      o TraceFile - Specifies the path for the file used for trace data.

	      o TraceOn - Specifies whether ODBC tracing is enabled (1 or TRUE) or disabled (0 or FALSE) for the connection being established.

	      o TransactionIsolation   -  Specifies  the  transaction  isolation  level.  The  accepted  values  for  this  option  are  PDO::SQL-
		SRV_TXN_READ_UNCOMMITTED, PDO::SQLSRV_TXN_READ_COMMITTED, PDO::SQLSRV_TXN_REPEATABLE_READ, PDO::SQLSRV_TXN_SNAPSHOT, and PDO::SQL-
		SRV_TXN_SERIALIZABLE.

	      o TrustServerCertificate	-  Specifies  whether the client should trust (1 or TRUE) or reject (0 or FALSE) a self-signed server cer-
		tificate.

	      o WSID - Specifies the name of the computer for tracing.

       Example #1

	      PDO_SQLSRV DSN examples

	       The following example shows how to connecto to a specified MS SQL Server database:

	      $c = new PDO("sqlsrv:Server=localhost;Database=testdb", "UserName", "Password");

	       The following example shows how to connect to a MS SQL Server database on a specified port:

	      $c = new PDO("sqlsrv:Server=localhost,1521;Database=testdb", "UserName", "Password");

	       The following example shows how to connecto to a SQL Azure database with server ID 12345abcde. Note that when you  connect  to  SQL
	      Azure with PDO, your username will be UserName@12345abcde (UserName@ServerId).

	      $c = new PDO("sqlsrv:Server=12345abcde.database.windows.net;Database=testdb", "UserName@12345abcde", "Password");

PHP Documentation Group 													 PDO_SQLSRV-DSN(3)