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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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