1 and trying to connect to MS-Access .

[Manoj Chaurasia]

MS-Access connection: running Spotfire 5.5.1 and trying to connect to MS-Access .accdb files but I can not even see the files. Converting file to .mdb it is giving me the error I do not have the required OLE DB provider installed. Could someone help me on this

thank you in advance.

 

Riccardo.

[christopher sawtelle 2]

My guess is you have a 64 bit operating system and 32 bit MS office. If so it's a nogo. There is a workaround but it's not supported so use at your own risk.

[Sean Riley]

Starting in Spotfire 6.5, you can directly open 32-bit Access, Excel, and SAS files on 64-bit OSs with a 64-bit Spotfire instance since Spotfire now handles these connections "out-of-process". This means that a separate 32-bit process is launched by the primary 64-bit Spotfire process to handle these connections. This allows connections to Access, Excel, and SAS files via the following method:

 

File > Add data table > Add > File > .accdb file

 

But the connection via locally installed Data Providers (ODBC, OleDb, etc.) is not implemented for out-of-process handling, and therefore does not allow you to use locally installed 32-bit Data Providers on 64-bit OSs with a 64-bit Spotfire instance, which would be performed with the following method:

 

File > Add data table > Add > Other > Database > ODBC Data Provider, OleDb Data Provider, etc.

 

So it is possible with this limited method mentioned above, which is much better then having no supported option like before.

[christopher sawtelle 2]

Just to add to it. In version 6.5 & on accessing 32-bit Access with a 64-bit OS/SF install works fine as Sean describes in the first part of his explanation.