Running MS Access Queries with Jenzabar
Posted by Yang, Jeffrey on 08 April 2021 03:16 PM
|
||||
Institutional Research run queries in Microsoft Access that require a connection with Jenzabar's server. After Jenzabar was moved to the cloud, the setup for this in ODBC has changed slightly. Following the attached image (Access_Jenz_Queries_Config.png) should resolve the connection issue. ** NOTE ** > If the "Jenzabar EX" entry under the "User DSN" tab does not exist, you will need to "Add" it. Otherwise, highlight the entry and click on "Configure" > For the 3rd image, if there is another field under the radio button "With SQL Server authentication using a login ID and password entered by the user." - leave the extra fields blank > For the 4th image, the "Application Intent" and "Multi-subnet failover" options may not be present. Just go next. > If the test at the last step is successful, have the end-user test a query "NSC Courses" found in the "Utility" DB. See attached image (Access_Jenz_Queries_Test.png) | ||||
|