Getting error when refreshing excel sheet conencted to epicor

Kinetic ERP
1

Getting this error when trying to refresh the data on our custom workbooks/excel.
image. I believe these worksheets pull data via(Get Data>Other Sources>OLEDB) function. Connection string
Provider=SQLOLEDB.1;Persist Security Info=True;User ID=;Initial Catalog=SaaS5229_;Data Source=erpus-r**.epicorsaas.com,*****;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=**********;Use Encryption for Data=False;Tag with column collation when possible=False

Command Type=SQL

If I create a new connection(sql) in excel with just the erpus-read**.epicorsaas.com,***** address and username/password I can connect fine.

Any ideas?

2

The session token for the original connection is expired, most likely.

3

ended up being a driver issue! :upside_down_face:

3 Likes