MS SQL JDBC connection

Establishes JDBC connection to MS SQL Easier to use than "database(…)" NEW! Windows authentication

MSSQLconn establishes a JDBC connection with MS SQL.
This function handles better the inputs and the error msgs than the database function.

MSSQLCONN(DBNAME, USERPASSMETHOD,OPTIONAL1...3) full syntax
- dbname: database name to which you want to connect (char format)
- userpassmethod --> {'username','password'}; 1st cell username,2nd cell password
- userpassmethod --> '-win'; use windows authentication (only for R2008b)
- userpassmethod --> '-manual'; supply credentials through inputdlg
- servername: string with the server where the database is hosted
- portnumber: integer of the port
- oldversion: if MS SQL is older than 2005 ed. supply '-old';
Only dbname is mandatory. Only one method to supply username and password is accepted at one time. Optionals can be supplied in any order and combination.

[OUT,SETTINGS] = ...
- Class 'database': connection to the server.
- Class 'structure' with the settings used to connect (except password).

DEFAULT SETTINGS:
- user = '';
- pass = '';
- server = 'localhost';
- port = 1433;
- driver = 'com.microsoft.sqlserver.jdbc.SQLServerDriver' (MS SQL 2005 and above);
- windows authentication: false;

Examples:
- MSSQLconn('MyDB') % use the whole set of default settings
- MSSQLconn('MyDB',{'Oleg','****'}) % supply username and password
- MSSQLconn('MyDB',{'Oleg',''}) % supply just the username, password by inputdlg
- MSSQLconn('MyDB','-win') % use windows authentication
- MSSQLconn('MyDB','-manual') % supply both username and password through inputdlg
- MSSQLconn(...,'myserver') % supply servername with any combination of dbname and userpassmethod
- MSSQLconn(...,1433, 'myserver','-old') % full set of optionals

Installing the driver:
1) If you don't have the drivers package download it from:
http://msdn.microsoft.com/en-us/data/aa937724.aspx
This page explains which driver fits your case.
2) Add the path of the .jar driver manually (better) to:
"matlabroot\toolbox\classpath.txt"
3) Check with "javaclasspath" (cmd pane) if the driver has been added correctly.
4) To be able to use windows credentials with '-win' userpassmethod, add just the directory where the .dll is to:
"matlabroot\toolbox\librarypath.txt"
The .dll is contained in the JDBC driver package. For more details:
http://www.mathworks.com/support/solutions/en/data/1-9SHNAT/

Comments/suggestions/error reports are welcome.

If other DBMS connection are required, plz write at [e-mail].

p3v4