AccuSQL: How to Change the SQL Native Client Driver to the latest available version?

Step 1:      From right side of the System Administration screen, Click on Database

Step 2:      Click on Database Location

Step 3:      Select the SQL Server radio button and Click Next

Step 4:  Select the SQL Native Client driver from the drop-down menu next to label "SQL Native Client Driver 11.0" as shown below:

NOTE: Depending on what is installed on the client, you may be using the native client, native client 10, or native client 11.  If you get an OLE iDispatch error when you try to connect, you may need to install the native client.  The installer is located in the AccuSQL 2020 installation folder under a folder labelled "SQL Drivers".  There is a 32-bit (sqlncli.msi) and a 64-bit (sqlncli_x64.msi) available. Make sure you check your Computer Properties to determine your system type to ensure you install the proper driver for your system.

Step 5:  Click the Save button and then Close at the top.  Exit and reopen AccuSQL if you made a change to the database used so it can connect to the new database.

• Related Articles

• AccuTrack/AccuSQL: How to Change the Database Location

  Method 1: Sign-in to the AccuSQL client as a system administrator and change the database location Step 1:      Open AccuTrack/AccuSQL and log in with Admin credentials. Now, from the right-side menu of the System Administration screen, ...

• AccuSQL 2019 Platinum Installation Instructions

  1. Click on the HighTail link that was sent to you. Click the Download All button 2. Click Save 3. Click on the downloaded files 4. Extract all the files 5. Once extracted, double click on the Folder AccuSQL2019_DIST 6. Double click on setup.exe 7. ...

• Upgrading the AccuSQL 2019 Database from an older version of the software

  AccuSQL: How to Run the AccuSQL Database Updater Tool on an older AccuSQL Database 1.  Right-click on the AccuSQL 2019 icon and select Open file location. 2. Locate the application SQLDataUpdater.  Double click to run the SQLDataUpdater. 3.  Fill out ...

• AccuSQL 2019 Subscription Installation Instructions

  1. Click on the HighTail link that was sent to you. Click on the Download All button. 2. Click Save 3. Click on the downloaded files  4. Extract all the files 5. Once extracted, double click on the Folder AccuSQL 6.  Double click on the application ...

• AccuTrack/AccuSQL: How can I make sure all my Computer Lab Plug-in PC's are set to the proper database? And the correct Local Lab or Center?

  Introduction In this guide, we have 2 ways to ensure that the Computer Lab Plug-in Computers you have installed are set to the proper Databases and Local Labs/Centers. After reading this guide you'll know not only how to set them but how to replicate ...