File Exchange

image thumbnail

MS SQL JDBC connection

version 1.6 (3.22 KB) by

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

4 Downloads

Updated

View License

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 oleg.komarov@hotmail.it.

p3v4

Comments and Ratings (3)

Oleg Komarov

Oleg Komarov (view profile)

Yes.
It is essentially a MSSQL wrapper of the database function from the Database TB.
So in order to have it working you should have the proper java drivers (read above) and the Database TB.

Oleg,
I accidently pushed the rating but couldn't change it. Im sorry for that. This file will make a connection between Matlab and MSSQL possible and works aswell?

Oleg Komarov

Oleg Komarov (view profile)

Testing additional feature to use Windows Authentication login.

Updates

1.6

Added windows authentication feature, changed syntax and edited description.

1.5

Corrected some minor bugs and reorganized some code.

1.4

Added: single input syntax and screenshot. Edited description.

1.1

Edited description; added link to FEX MSSQLconn in the help part of the function

MATLAB Release
MATLAB 7.9 (R2009b)

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video