Nebulae servers can open a connection to standard database engines like Microsoft Access, Microsoft SQL Server, Oracle, MySQL and PostgreSQL, using the JDBC technology. This connection is established when the Nebulae server starts, following directives configured in the Nebulae.cfg. Users connected to a movie can use special commands to send SQL queries to the database. Commands are automatically translated by Nebulae and the results are returned as Lingo values, ready to be used in your Shockwave movies.

SQL commands available to Nebulae clients are:

System.SQL.executeQuery

System.SQL.executeUpdate

System.SQL.connect

System.SQL.disconnect

Please consult the Nebulae Command list section of the documentation for more information about the exact syntax for each command.

The technotes area at http://xtras.tabuleiro.com contains more information about connection to SQL databases, including updated configuration options for the most common database engines and instructions for setting up an external SQL database to be used for user authentication in the server.