Can I use Autoplay Media as a front end to access a Network SQL Server

[[email protected]]

Hi All

I am looking to develop an application that will be a front end to access data stored on our SQL server and enable updates

Can I use the ODBC or SQLlite commands in AutoPlay media to do this ?

Thanks for any help

[Ulrich]

You certainly can. If you have a compatible driver installed enabling you to exchange commands with your SQL server, then you can display data and update records, if you code these commands in your application. You have the option of using LuaSQL for selected databases and ODBC, or certain third party plugins.

SQLite can be used only with SQLite-based (serverless) databases, but AutoPlay Media Studio has also built-in support for MySQL, Oracle and PostgreSQL; anything else should work with an ODBC driver.

Ulrich

[[email protected]]

Thanks for the feedback

Thanks for the feedback Ulrich

Is it possible to install a driver and say an odbc dns address through autoplay media install / open operation ?

[QUOTE=Ulrich;188364]You certainly can. If you have a compatible driver installed enabling you to exchange commands with your SQL server, then you can display data and update records, if you code these commands in your application. You have the option of using LuaSQL for selected databases and ODBC, or certain third party plugins.

[Ulrich]

Is it possible to install a driver and say an odbc dns address through autoplay media install / open operation ?

Installing an ODBC driver would usually be the task of the setup. In Setup Factory, you have actions for setting up ODBC DSNs on the target computer, like ODBC.InstallDriver(). This is not available in the range of functions of AutoPlay Media Studio.

The ODBC functions available in LuaSQL require that a DSN was previously set up. If you created the DSN during the setup or manually afterwards, you could use the name in ODBC:connect(sDSN, sUsername, sPassword) to open a connection to the SQL server, and start retrieving data.

As an alternative, I offer an ODBC plugin, which provides DSN-less connections. With it, you can open a connection to a SQL server by specifying the driver name, and connection parameters, as I show here.

Ulrich