Receiving ODBC Error Getting Banner or Colleague Data in Microsoft Access or Microsoft Excel

Issue/Question

Attempting to use Microsoft Access database or Microsoft Excel spreadsheet and receive ODBC error

Error: Run-time error '3151': ODBC--connection to 'xxxxxx' failed

Error: Run-time error '3146' ODBC call failed

Environment

  • Microsoft Access database OR Microsoft Excel spreadsheet
  • FUPLOAD database is one of these where this error is common

Cause

Usually password expiration

Resolution

  1. Contact the USD Service Desk and refer to article Microsoft Access ODBC Error Retrieving Data From Banner or Colleague (1713)
 

Details

Article ID: 2338
Created
Mon 2/25/19 9:36 AM
Modified
Fri 6/23/23 12:09 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated