Manoj Chaurasia Posted February 5, 2015 Share Posted February 5, 2015 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. Link to comment Share on other sites More sharing options...
christopher sawtelle 2 Posted October 23, 2015 Share Posted October 23, 2015 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. Link to comment Share on other sites More sharing options...
Sean Riley Posted October 26, 2015 Share Posted October 26, 2015 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. Link to comment Share on other sites More sharing options...
christopher sawtelle 2 Posted October 28, 2015 Share Posted October 28, 2015 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now