ODBC Connection Error When Connecting to Data Warehouse via Microsoft Access or EXCEL

ODBC Connection Error When Connecting to Data Warehouse via Microsoft Access or EXCEL

Problem


An error is received when trying to access. ODBC call failed  Specified driver could not be loaded due to system error 126: The specified module could not be found. (Adaptive Server Enterprise, C:\Sybase\DataAccess\ODBC\dll\sybdrvo.dll)(#160)


Solution if you do not have administrator rights


Create a service now request through DTS. Most likely, it is related to ODBC not being configured correctly and it will be required to reinstall the Sybase client.



Steps to Follow if you have Administrator Rights to your computer


  1. Access the Data Warehouse web page at https://finance.utah.gov/data-warehouse/
  2. Hover the mouse over the "More" link in the upper right of the page
  3. Select ODBC Setup and Downloads
  4. Login with your Utah ID
  5. Select: "Install SAP ASE 16 Client .docx" to download the setup instructions
  6. Select: 51047970 to download the installation files
  7. Follow the instructions to install ODBC

    • Related Articles

    • QRG - Using Excel to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1CzcUic3qykVURnFS1yrkN-roU5YvQzJv/view ) Introduction To access State Data Warehouse using excel or other tools, create a DTS helpdesk ticket, they need to install ...

    • QRG - Using Access to query data warehouse

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1jcxI35q1Rpz_gLCbOonQaWSgO51duFq7/view ) Introduction Open Database Connectivity (ODBC) database. Similar to the state data warehouse, you’ll need to install an ...

    • Error Using Warrant Queries "Check/EFT"

      error "Alert - There is a problem retrieving query data. Please contact System Administrator" RESOLUTION - just type the number in without the "F" No alpha character in front of the check number,  just numbers. You do not need to include the leading ...

    • Linking a Commodity Code to a Warehouse

      This is the process to add a commodity to a warehouse. Step by Step Instructions: 1.)  Go to INVN (Inventory Maintenance) Table 2.)  Select the appropriate warehouse 3.)  Select Insert 4.)  Select the commodity code you are looking to tie in

    • QRG - Inventory Freeze and Inventory History

      Description and Purpose To assure accuracy, Inventories are periodically frozen in FINET to allow physical counts of the items in the warehouses. Currently, those with Inventory have selected to freeze entire warehouses to perform the count. However, ...