Accessing .sql database file

So first of all, I have almost zero database experience. I've mainly used MATLAB for modeling purposes in the past, but now I need to do some calculations with some data stored in an SQL database.

I've been provided with a .sql file, containing the database. This database contains several tables which I'd like to access and run queries on in order to perform calculations.

I've downloaded the Database Toolbox package, and have been trying to make a connection using the 'database' command, but there seems to be an issue concerning the JDBC drivers.

My question is: what do I need to do, what do I need to install and configure in order to be able to perform SQL queries on the Database.sql file?

As I said, I've never worked with databases before so I have minimal knowledge.

Many thanks in advance,

Greg

Answer 1

[Aldin]

Look here for connection:

http://www.mathworks.com/matlabcentral/answers/32618-connecting-to-mysql-using-jdbc

and here for SQL Query: type:

doc database

[Greg]

thanks, I'd already checked that out, but what I don't get is: is the JDBC driver something that needs to be downloaded and installed separately, or does it come with the database toolbox?

I'm using Mac OS X 10.6 btw.

Answer 2

[ajith]

refer the following link its been useful

http://radio.feld.cvut.cz/matlab/pdf_doc/database/database.pdf

Answer 3

[Tony]

Make use of sql 2005 fix

Solution http://www.fixmdf2005.sqlmdffix.com must assist you