From: Alok on
Hello all !!
I am a first time user of MATLAB. I want to connect databases created in MS-ACCESS with the MATLAB 7.5 (i.e. i want to import and export the data from and to ACCESS)..i have read the tutorials for DATABASE TOOLBOX and followed the instructions to connect the demo database called "tutorial.mdb".
I have SET UP DATA SOURCE for use with ODBC driver.
but when i try to use the data source that i've SET UP it asks me for a username and password. I am stuck here as it is not accepting blank quotes.
Kindly help by giving a step by step instruction to the problem.

Thanking You
From: Oleg Komarov on
"Alok " <
> Hello all !!
> I am a first time user of MATLAB. I want to connect databases created in MS-ACCESS with the MATLAB 7.5 (i.e. i want to import and export the data from and to ACCESS)..i have read the tutorials for DATABASE TOOLBOX and followed the instructions to connect the demo database called "tutorial.mdb".
> I have SET UP DATA SOURCE for use with ODBC driver.
> but when i try to use the data source that i've SET UP it asks me for a username and password. I am stuck here as it is not accepting blank quotes.
> Kindly help by giving a step by step instruction to the problem.
>
> Thanking You

Have you tried:
conn = database('datasourcename','','')
conn.message

Oleg
From: Matt on
Hello there,
I originally had the same problem, but I got it to work using
user= Admin
pw = Admin

i.e.
dbconnection=database('database_name','Admin','Admin')