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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.