Windows ODBC Support

paul3252

Currently I have to support a relatively large application that uses a Microsoft Access backend database. I have no control over this, despite me asking to replace the database with a proper client/server solution. Using XOJO the ODBC driver works fine but general ODBC support for Windows platforms on OBJO would also open up ODBC support for other databases. I prefer the non DSN solution as I have no admin rights on the machines these are installed upon to set up DSN. Thanks for the work on MSSQL server previously.

Proposed Solution

Addition of ODBC driver for MSACCESS, or generic solution that supports DSNless connections

Example Workflow

Alternatives Considered

Who Would This Help?

Us poor members of the Windows community that have had to put up with MS Access for over 40 years :-).

Garry

This sounds mainly like a need for DSN-less Microsoft Access connectivity on Windows. I’m reluctant to bundle or install ODBC/Access drivers because those are native machine-level dependencies with 32/64-bit and Office Runtime complications. I’m open to investigating either a Windows-only AccessDatabase class, or a lower-level ODBCDatabase class that uses drivers already installed on the target machine. It would be explicitly “bring your own driver” support.

dghoskins

I too have to support a legacy Microsoft Access system (for the near term at least). I think an ODBCDatabase class would be the way to go. That way any database with an ODBC driver would be supported.

Garry

It's in the next release. See this post for the details:

https://forum.objo.dev/d/570-odbc-support-added-for-the-next-release