Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
rbakins
New Member

Sage 100 On-Premises Gateway

Having trouble with a server-mounted, On-Premises Gateway communicating with my silent ODBC for Sage 100 access.  

 

On-Premises Gateway successfully installed on my server (also the Sage server), and my published Power BI semantic model recognizes it.  The persistent error is that my DSN is incorrect.  I've poured over community posts for the last couple weeks and believe I have my connection string and credentials correct, and ensured my ODBC is on the same machine as the Gateway.

 

Error log:

Matt_BCS: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

 

The Gateway was originally installed on my machine and functioned well, refreshing on schedule.  I'm attempting to migrate the Gateway off my PC so I don't accidentally close the nuisance Gateway window.

 

Any ideas?

1 ACCEPTED SOLUTION
rbakins
New Member

Solved!  The ODBC was mistakenly setup as a User DSN.  Moved to System DSN and all is good.

View solution in original post

3 REPLIES 3
rbakins
New Member

Solved!  The ODBC was mistakenly setup as a User DSN.  Moved to System DSN and all is good.

lbendlin
Super User
Super User

On the gateway VM go to the ODBC 64 System DSN settings and validate that your dsn is actually listed and working.

 

Note:  Do not run gateway service and any other service on the same machine. They will starve each other of memory.

Thank you for the advice!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.