ODBC - who is using it? | Uniface Deployment | Forum


Please consider registering

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

—  Results per page  —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters
For a group of consecutive words like 'end of support' use Match phrase

sp_Feed Topic RSS sp_TopicIcon
ODBC - who is using it?
05 Sep 2017
3:52 pm
Adrian Gosbell
Amsterdam, seat 77a of a Boeing 747
Forum Posts: 299
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

We are going through some reviews of the PAM (and the source document) to try and make it simpler and easier to understand, and the fact that ODBC is *only* listed for Windows 7 came to my attention. 

It’s not been verified for other (newer) Windows versions because we’ve not had requests for it. 

Is anybody using it? If so, I’d like to know what data sources you are connecting to, and what version of Windows you’re using. Replies welcome below. 

If we need to create a user story to verify this on other platforms, we can do so.  

I also need to think about Uniface 10. 

(if you ask questions, don’t expect answers from me for the coming couple of weeks). 

05 Sep 2017
4:03 pm
Iain Sharp
Forum Posts: 639
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

We use it to connect to the sage line 50 accounts package for over 70% of our customer base. . 

We run this connection on just about every supported flavour of windows operating system (2008, 2012, 2016), and some client systems as well (Windows 10, generally). 

06 Sep 2017
5:01 pm
Forum Posts: 291
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi Adrian,

as far as I know most Uniface users are using ODBC to connect to unusual data sources, like:
– collecting dipartimental data on an already existing Access database (built outside control of the Uniface application)
– getting data from unusual/custom data source on unusual platform

ODBC it is today like a swiss knife: it is NOT perfect but it is really useful in many cases !!!


07 Sep 2017
7:33 am
Forum Posts: 244
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline


Although we use the MSS-driver
$MSS MSS:myserver…..

all connections to the database go through the ODBC-source. I suppose that this doesn’t mean that we need the Uniface ODBC-driver.
However I just want to point it out, not sure if there could be some kind of dependency between Uniface MSS-driver and ODBC-driver. Probably not.

Does everyone using Sql Server go through an  ODBC-source or can this be handled in some other way (should perhaps open a new thread for this one)?

Regards RogerW.

07 Sep 2017
12:14 pm
Theo Neeskens
Forum Posts: 352
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi Roger,

The MSS driver always uses ODBC data sources, but it has no relationship with the generic ODBC driver.

It is best practice to only use the generic ODBC driver when you need to access data that none of our specific drivers can access. Performance and functionality can be somewhat limited in the generic ODBC.


12 Sep 2017
1:44 pm
Forum Posts: 27
Member Since:
06 Dec 2012
sp_UserOfflineSmall Offline

Hello Adrian,

we are using ODBC and plan switching to Windows 10 step by step as soon as we have the new licences for Windows 10.



Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online:
22 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1745

Iain Sharp: 639

Theo Neeskens: 352

gianni: 291

rogerw: 244

istiller: 225

lalitpct: 197

Knut: 189

Arjen van Vliet: 174

sochaz: 173

Member Stats:

Guest Posters: 3

Members: 7840

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2121

Posts: 9194

Newest Members:

Darkhunterquife, Jimmyrag, ian.farrugia, gregorbooi, RolterQ, JamesapowN, Sookssax, LouisMap, Margaritoquife, fernpb11

Administrators: admin: 23, Adrian Gosbell: 299, diseli: 900, Bob Maier: 3, Nico Peereboom: 72, Michael Rabone: 4, richiet: 406, JanCees: 28