Hi 


I have installed 64bit matlab and have problems to setup the connection to a acccess 2007 database. First I did setup my databasebase by using the 32-bit version of ODBC: c:\windows\sysWOW64\odbcad32.exe. 

Then I did try to connect to my database:

conn = database('Test', '', '') %Test is name of database

I got:

>> conn = database('Test', '', '')
 
conn =
 
       Instance: 'Test'
       UserName: ''
         Driver: []
            URL: []
    Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
        Message: [1x173 char]
         Handle: 0
        TimeOut: []
     AutoCommit: 'off'
           Type: 'Database Object'


Anybody that have experienced comparable problems when trying to setup acces database on 64bit win7 computer. I have earlier got it to work on a 32bit winXP computer.

"Jens " <robinh887@gmail.com> wrote in message <ie8h59$6ve$1@fred.mathworks.com>...
> Hi 
> 
> 
> I have installed 64bit matlab and have problems to setup the connection to a acccess 2007 database. First I did setup my databasebase by using the 32-bit version of ODBC: c:\windows\sysWOW64\odbcad32.exe. 
> 
> Then I did try to connect to my database:
> 
> conn = database('Test', '', '') %Test is name of database
> 
> I got:
> 
> >> conn = database('Test', '', '')
>  
> conn =
>  
>        Instance: 'Test'
>        UserName: ''
>          Driver: []
>             URL: []
>     Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
>         Message: [1x173 char]
>          Handle: 0
>         TimeOut: []
>      AutoCommit: 'off'
>            Type: 'Database Object'
> 
> 
> Anybody that have experienced comparable problems when trying to setup acces database on 64bit win7 computer. I have earlier got it to work on a 32bit winXP computer.

Paste the content of conn.Message

Oleg

"Oleg Komarov" <oleg.komarovRemove.this@hotmail.it> wrote in message <ie8kqt$jm9$1@fred.mathworks.com>...
> "Jens " <robinh887@gmail.com> wrote in message <ie8h59$6ve$1@fred.mathworks.com>...
> > Hi 
> > 
> > 
> > I have installed 64bit matlab and have problems to setup the connection to a acccess 2007 database. First I did setup my databasebase by using the 32-bit version of ODBC: c:\windows\sysWOW64\odbcad32.exe. 
> > 
> > Then I did try to connect to my database:
> > 
> > conn = database('Test', '', '') %Test is name of database
> > 
> > I got:
> > 
> > >> conn = database('Test', '', '')
> >  
> > conn =
> >  
> >        Instance: 'Test'
> >        UserName: ''
> >          Driver: []
> >             URL: []
> >     Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
> >         Message: [1x173 char]
> >          Handle: 0
> >         TimeOut: []
> >      AutoCommit: 'off'
> >            Type: 'Database Object'
> > 
> > 
> > Anybody that have experienced comparable problems when trying to setup acces database on 64bit win7 computer. I have earlier got it to work on a 32bit winXP computer.
> 
> Paste the content of conn.Message
> 
> Oleg


Thanks 

It is in Danish , but it sayes something like the DSN contains a difference in architure between driver and the program.  Please verify that login information and database url are valid.

I tried to download the "Microsoft Access Database Engine 2010 Redistributable ", but it did not work. 

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d


I also cannot get access to the Access drivers in the "Administrator" in the command window. I tried the 32bit, but it did also not work: 

C:\Windows\SysWOW64

"Jens " <robinh887@gmail.com> wrote in message <ie8nqh$hu7$1@fred.mathworks.com>...
> "Oleg Komarov" <oleg.komarovRemove.this@hotmail.it> wrote in message <ie8kqt$jm9$1@fred.mathworks.com>...
> > "Jens " <robinh887@gmail.com> wrote in message <ie8h59$6ve$1@fred.mathworks.com>...
> > > Hi 
> > > 
> > > 
> > > I have installed 64bit matlab and have problems to setup the connection to a acccess 2007 database. First I did setup my databasebase by using the 32-bit version of ODBC: c:\windows\sysWOW64\odbcad32.exe. 
> > > 
> > > Then I did try to connect to my database:
> > > 
> > > conn = database('Test', '', '') %Test is name of database
> > > 
> > > I got:
> > > 
> > > >> conn = database('Test', '', '')
> > >  
> > > conn =
> > >  
> > >        Instance: 'Test'
> > >        UserName: ''
> > >          Driver: []
> > >             URL: []
> > >     Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
> > >         Message: [1x173 char]
> > >          Handle: 0
> > >         TimeOut: []
> > >      AutoCommit: 'off'
> > >            Type: 'Database Object'
> > > 
> > > 
> > > Anybody that have experienced comparable problems when trying to setup acces database on 64bit win7 computer. I have earlier got it to work on a 32bit winXP computer.
> > 
> > Paste the content of conn.Message
> > 
> > Oleg
> 
> 
> Thanks 
> 
> It is in Danish , but it sayes something like the DSN contains a difference in architure between driver and the program.  Please verify that login information and database url are valid.
> 
> I tried to download the "Microsoft Access Database Engine 2010 Redistributable ", but it did not work. 
> 
> http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d
> 
> 
> I also cannot get access to the Access drivers in the "Administrator" in the command window. I tried the 32bit, but it did also not work: 
> 
> C:\Windows\SysWOW64

Did you try the actual set up that Matlab asks to do for beginners? using the Nwind database? 

"Manikandan Mohan" wrote in message <ie8pqo$qqt$1@fred.mathworks.com>...
> "Jens " <robinh887@gmail.com> wrote in message <ie8nqh$hu7$1@fred.mathworks.com>...
> > "Oleg Komarov" <oleg.komarovRemove.this@hotmail.it> wrote in message <ie8kqt$jm9$1@fred.mathworks.com>...
> > > "Jens " <robinh887@gmail.com> wrote in message <ie8h59$6ve$1@fred.mathworks.com>...
> > > > Hi 
> > > > 
> > > > 
> > > > I have installed 64bit matlab and have problems to setup the connection to a acccess 2007 database. First I did setup my databasebase by using the 32-bit version of ODBC: c:\windows\sysWOW64\odbcad32.exe. 
> > > > 
> > > > Then I did try to connect to my database:
> > > > 
> > > > conn = database('Test', '', '') %Test is name of database
> > > > 
> > > > I got:
> > > > 
> > > > >> conn = database('Test', '', '')
> > > >  
> > > > conn =
> > > >  
> > > >        Instance: 'Test'
> > > >        UserName: ''
> > > >          Driver: []
> > > >             URL: []
> > > >     Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
> > > >         Message: [1x173 char]
> > > >          Handle: 0
> > > >         TimeOut: []
> > > >      AutoCommit: 'off'
> > > >            Type: 'Database Object'
> > > > 
> > > > 
> > > > Anybody that have experienced comparable problems when trying to setup acces database on 64bit win7 computer. I have earlier got it to work on a 32bit winXP computer.
> > > 
> > > Paste the content of conn.Message
> > > 
> > > Oleg
> > 
> > 
> > Thanks 
> > 
> > It is in Danish , but it sayes something like the DSN contains a difference in architure between driver and the program.  Please verify that login information and database url are valid.
> > 
> > I tried to download the "Microsoft Access Database Engine 2010 Redistributable ", but it did not work. 
> > 
> > http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d
> > 
> > 
> > I also cannot get access to the Access drivers in the "Administrator" in the command window. I tried the 32bit, but it did also not work: 
> > 
> > C:\Windows\SysWOW64
> 
> Did you try the actual set up that Matlab asks to do for beginners? using the Nwind database? 

"Robin Jens" wrote in message <ie8h59$6ve$1@fred.mathworks.com>...
> Hi 
> 
> 
> I have installed 64bit matlab and have problems to setup the connection to a acccess 2007 database. First I did setup my databasebase by using the 32-bit version of ODBC: c:\windows\sysWOW64\odbcad32.exe. 
> 
> Then I did try to connect to my database:
> 
> conn = database('Test', '', '') %Test is name of database
> 
> I got:
> 
> >> conn = database('Test', '', '')
>  
> conn =
>  
>        Instance: 'Test'
>        UserName: ''
>          Driver: []



>             URL: []
>     Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
>         Message: [1x173 char]
>          Handle: 0
>         TimeOut: []
>      AutoCommit: 'off'
>            Type: 'Database Object'
> 
> 
> Anybody that have experienced comparable problems when trying to setup acces database on 64bit win7 computer. I have earlier got it to work on a 32bit winXP computer.

MS Access DB on Matlab database toolbox.  I have been able to use MS Access 2010 DB on Matlab 2011a 32bit but not 64 bit version on Windows 7 64 bit OS.

1) You need to run the 32 bit version of Matlab - your license should allow you to download both versions, one in Program files the other to Program files (x86) - 32 bit.

2) In Access you need to set permissions for the DB, I found that even though I created the DB and could manipulate it in Access, I had to set user permissions to all computer users to get Matlab to open it.  (there may be more specific permissions that work - use password security if this is a concern)

3) Set up the ODBCAD32 in Windows/SYSWOW64 running as administrator (right click on file name and click run as administrator)

4) Add Access DB as an Access DB  type   (.mdb or .mdb .accdb), assign reference "DB name" to Access DB - this is what is used in the database( ) statement.

5) The connect = ('DB name", '', '',) if no user-password set in Access

6) You should see handle: xxxxxxxxxxxxxxxxxxxx

7) handle: 0 is an error meaning the DB did not connect.

I run my DB scripts in 32 to create .mat file (all are 64 bit).  I then run my numerical intensive operations in Matlab 64bit.

This may not be the simplest/most elegant solution but is the only one I found to work so far.  I do not believe that you can access the 32bit Access DB files from a 64 bit application since there is no ODBCAD64 drivers for Access (??).  The ODBCAD32 drivers only work with 32 bit applications (e.g. Matlab 32 ??)

I am not 100% sure of the (??) statements and would appreciate input from anyone else that has delt with this problem.  There are a lot of 32bit Access DB out there as SQL Sever is a real pain to install.  Seems MS wants to either limit the migration of Access or has hit the wall with legacy issues moving to 64 bit.

See my post "A general problem in 64-bit Matlab with establishing
connections to 64-bit ODBC databases".

Kirill