Connecting to SQL database

[MSP]

Hello,
Is there any way to use Autoplay to use the information gathered to connect to a database and make a record. The SQLLite plugin says Note: The SQLite database engine is not a client used to connect to a big database server. It is the server. The SQLite database engine reads and writes directly to and from database files on disk.

Is there a way to do this? Possibly HTTP.Submit()?

[Ulrich]

The SQLite plugin communicates only with SQLite databases, which are locally stored and file-based. Another kind of file-based databases are *.mdb files, created by MS Access, which can be accessed with the xMDB (http://www.xdialog.com/free_stuff.htm) plugin.

Other databases, like SQL Server, Oracle, Sybase, Firebird, MySQL etc. can be accessed locally and remotely with the ODBC (http://www.indigorose.com/forums/showthread.php?t=24159) plugin (http://www.mindquake.com.br/ams-odbc.php), but you might need to install the appropriate ODBC driver for the database first, as not all drivers come preinstalled with Windows.

Ulrich

[MSP]

Thank you! I will try that.

[Jonas DK]

You could all so try to have a look at the sample we made some time ago in the examples forum. We created an AMS app. that connects and send and recieves data from a MySQL database using the same structure as SQLite uses.

This means that you could copy the functions in the sample and then use the documentation for the SQLite plugin to work out the rest.

cheers,
Jonas