Databases and SWFKit

[Moghra]

Your product seems perfect for an application I'm planning to write, but I've never interfaced a database into any of my previous apps.

From what I've read on your website, ADO is mentioned as being the method of interfacing with databases.

I was wondering, which databases will tie in with your program? My app will be standalone, and I will be distributing it on CD-ROM, so I also need to avoid licensing costs if possible. Which database do you recommend to use?

[SWFKit]

Thank you.

"Microsoft® ActiveX® Data Objects (ADO) enable your client applications to access and manipulate data in a database server through any OLE DB provider. "(MSDN)

We recommend Microsoft Access(*.mdb), it needs only a *.mdb file, very simple. The Microsoft Access is also very easy to use.

To redistribute the Microsoft Data Access Components, you can do like this(most of your clients have already installed it):

//try to create a connection object
var conn = new ActiveXObject("ADODB.Connection");

//check
if (conn == null)
{
 * *//install MDAC
 * *Shell.runAndWait(path_to_mdac);
}

You can get the MDAC from here:
http://www.microsoft.com/data/
http://support.microsoft.com/default...;en-us;q184265

You also need the Microsoft Jet components to access Microsoft Access databases with ADO. The MDAC 2.0 will install Jet OLE DB provider 3.51 for Access 97, MDAC 2.1 to 2.5 will install Jet OLE DB provider 4.0 for Access 2000. From MDAC 2.6 you should install Jet provider yourself.