Jet Service Tier with ODBC

Discussion & Feedback for Jet Enterprise
Posts: 1
Joined: Mon Nov 14, 2016 3:25 am

Jet Service Tier with ODBC

Postby jboutaud » Mon Feb 06, 2017 4:38 am


We use Jet Essentials 2015 Update 1 and the Jet Service Tier to centralize the management of the DataSource.
We have NAV DataSources and some other DataSources using ODBC connection (MySQL, SQL Server, Postgres).

With the DataSources on ODBC connections, user must have locally the ODBC driver installed AND the ODBC DataSource configured. Otherwise it does not work.
So i don't know if i did something wrong or if this is the normal behavior.


User avatar
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: Jet Service Tier with ODBC

Postby HPDeskJet » Tue Feb 07, 2017 12:53 pm

Hello -

While the settings for your data source are stored in the Jet Service Tier, the connection to the database is done from the user's computer.

Thus, it is necessary for each user's computer to have the needed ODBC or OLE driver installed.
Jet 2015 Certified Trainer

Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 2 guests