Create a Portable Application That Connects to an Oracle Database?

General
1

Is it possible to create a portable application that accesses an Oracle database?

With the deprecation and removal of the OracleDB plugin, it looks like the only option left is ODBC, but that requires setup on the end user’s machine as far as I can tell.

Is there any way, via native Xojo or plugins, to create an application that is bundled with everything required to connect to an Oracle database already included in the .app package?

Thanks

2

I don’t have experience with Oracle in the context of Xojo, but it looks like the MBS Sql Plugin should work for you. See the table on the linked page.

3

I think you’re right about that being the solution.

I originally looked at the example project and saw that it needed to have a dylib loaded and mistakenly thought that the required Oracle Instant Client would need to be set up like an ODBC connection.

I’m running into “ORA-12699: Native service internal error occurred.” now, but that’s not really relevant to this thread.

Thanks Scott

1 Like