How do I connect to MS Access database in JMP 10

Reply
New Contributor
Posts: 2

How do I connect to MS Access database in JMP 10

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!

Super User
Posts: 17,819

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

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

 

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

New Contributor
Posts: 2

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

Thanks!

Ask a Question
Discussion stats
  • 2 replies
  • 283 views
  • 0 likes
  • 2 in conversation