How do I connect to MS Access database in JMP 10

azeemers — Sat, 28 May 2016 17:04:24 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

Reeza — Sat, 28 May 2016 18:11:49 GMT

JMP has it's own forum, please post the question there.

https://www.jmp.com/forum/

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

azeemers — Fri, 03 Jun 2016 15:26:09 GMT

Thanks!

topic Re: How do I connect to MS Access database in JMP 10 in SAS Programming

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