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 ...

    • Excel Querying Data Warehouse (Microsoft Query)

      It appears recent Office 365 Updates (2024) have impacted the menu choices for those of you who use the Microsoft Query to access State Data Warehouse. If you no longer see the Microsoft Query in the 'Other' query option, please see below for ...

    • 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 ...

    • Data Warehouse - Data Dictionary

      Information Data Warehouse has published a Data Dictionary, sharing all of the State Datawarehouse Tables and Fields. Some tables have details and joins to use, where other less commonly used tables simply share the field names. This should be ...

    • Labor Plus Query

      Labor Plus is a link within the Online Accounting Journal query. If you have accesss to the online accounting journal, then you have access to see Labor Plus. For privacy reasons, State Data Warehouse hides many vendor names. If you were to add the ...