How do I connect to MS Access database in JMP 10?

anasrullah — Fri, 03 Jun 2016 15:24:42 GMT

Hello,

I can't seem to connect to an MS Access database in JMP 10. The script below works fine in JMP 9. The error I get is, "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". Do I need to use a different driver ID?

Here is my script:

dt = Open Database(

"DSN=MS Access Database;DBQ=T:\Applications\Executables\Temescal Particle Count database.accde;DriverId=22;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;",

"SELECT [Particle Data].[Tool Number],

[Particle Data].Date,

[Particle Data].[Tool Type],

[Particle Data].[Inner Row Pre Meas],

[Particle Data].[Inner Row Post Meas],

[Particle Data].[Outer Row Pre Meas],

[Particle Data].[Outer Row Post Meas],

[Particle Data].[Control Pre Meas],

[Particle Data].[Control Post Meas],

[Inner Row Post Meas]-[Inner Row Pre Meas]-[Control Post Meas]+[Control Pre Meas] AS RowA_Adders,

[Outer Row Post Meas]-[Outer Row Pre Meas]-[Control Post Meas]+[Control Pre Meas] AS RowB_Adders

FROM [Particle Data]

WHERE ((([Particle Data].[Tool Number])='Temescal 2800-10' Or

([Particle Data].[Tool Number])='Temescal 2800-13' Or

([Particle Data].[Tool Number])='Temescal 2800-14' Or

([Particle Data].[Tool Number])='Temescal 2800-17'))

ORDER BY [Particle Data].[Tool Number], [Particle Data].Date;"

);

Thanks!

Re: How do I connect to MS Access database in JMP 10?

txnelson — Fri, 03 Jun 2016 15:49:25 GMT

My first guess would be that your MS Access is installed as a 32bit application, and you installed JMP as a 64bit application. You can not mix bit levels. You will need to uninstall JMP 10, and reinstall it as a 32 bit application.

Re: How do I connect to MS Access database in JMP 10?

anasrullah — Fri, 03 Jun 2016 16:14:00 GMT

Thanks Jim!

Re: How do I connect to MS Access database in JMP 10?

Jeff_Perkinson — Fri, 03 Jun 2016 16:19:36 GMT

Alternatively, you could install a 64-bit ODBC driver for MS Access.

topic Re: How do I connect to MS Access database in JMP 10? in Discussions

How do I connect to MS Access database in JMP 10?

Re: How do I connect to MS Access database in JMP 10?

Re: How do I connect to MS Access database in JMP 10?

Re: How do I connect to MS Access database in JMP 10?