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!
Thanks!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.