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

Avatar

Please consider registering
guest

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
Avatar
Adrian Gosbell
Amsterdam, seat 77a of a Boeing 747
Admin
Forum Posts: 276
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
Avatar
Iain Sharp
Member
Forum Posts: 605
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
Avatar
gianni
Member
Forum Posts: 250
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 !!!

Regards,
Gianni

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

Hi,

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
Avatar
Theo Neeskens
Member
Forum Posts: 339
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.

Theo

12 Sep 2017
1:44 pm
Avatar
Lauterbach
Member
Forum Posts: 26
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.

 

Norbert

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online:
11 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1683

Iain Sharp: 605

Theo Neeskens: 339

gianni: 250

rogerw: 232

lalitpct: 197

istiller: 195

Knut: 173

-GHAN-: 171

sochaz: 165

Member Stats:

Guest Posters: 3

Members: 5469

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2014

Posts: 8675

Newest Members:

Frankchets, jimchr, HerbertElaby, PhilipHar, Frankskync, FrankVag, LloydChelp, Vladcubre, BobbyFUT, Rickypaity

Administrators: admin: 23, Adrian Gosbell: 276, diseli: 810, Bob Maier: 3, Nico Peereboom: 60, Michael Rabone: 4, richiet: 406, JanCees: 28