Simplicty and flexibility!


Started by diego fernando Ocampo
You will need to Sign In to be able to add or comment on the forum!


Hello good afternoon can someone help me configure ODBC to fetch acces data to DataEase 7.2.3 Thanks for the collaboration

Written by diego fernando Ocampo 05/08/20 at 19:08:29 DataEase for Windows 7.x


There is a lot of hoops you have to jump through to get this working now.

if it is in 32 bit windows it is more straight forward but as 7.2 is a 32 bit software it will only work with 32 bit ODBC.

If you are running 64 bit windows you need to start the 32 bit ODBCadmin as the link need to be 32 bit!

When you have set up the link in ODBCAdmin

You simply add it in the database links in DE.

The Link name is not important, that is just the name it will be stored under in the Catalog and can be anything.

You then choose Engine type (Other Engines via ODBC)

Then you add the Server Name which is the name it has in ODBC Admin in this case AgeEange and simply hit Add.

YOu will then see the available Tables List.


As this interface has not been updated for a long time the match between ODBC and DataEase is poor and as the statements from DataEase is converted to SQL and back more often than not you will get problems with updates and reading as there is a mismatch.

So if you are to use this you should build views etc. in the donor database that match with DataEase or you will not get it working.

We did quite a bit of work on the ODBC/OLEDB stuff in 8.x but in the end we had to chuck it in as the model is outdated and slow.

in DE9 onwards we use HTTP based REST API model for exchange of data.

Written by DataEase 07/08/20 at 13:35:47 DataEase for Windows 7.x