Need offline universal database for asp

[txbakers]

I have a web based application written in ASP. It connects to a mySQL database on my server. All is well.

I need to create an offline version of the application. I have successfully encrypted the scripts on the ASP pages and run the pages offline in the browser. However, there still needs to be a database installed to handle the data on the local machine.

Is it possible to put the database files (lets say MDB) on the local machine and write to those without having Access installed? Or, am I looking at installing mySql on every machine that wants to run my app offline?

Thanks.

[WebJoe]

I assume that you have IIS running locally. I can only tell from my experience: My ISP does not have Access installed, but my databases are all in access, without a problem. But you'd have to change your ADo connection string/provider.

[txbakers]

No, I don't have IIS running locally, but I found a really cool IIS Emulator that I can bundle with the site and install wherever.

I'll try the Access file route without access and see if it works. I hate to uninstall Access from my machine to test it though!

Yes, I know I have to change the ADO strings, etc. There's a lot more I need to change to get it to work offline, but I need a place to store the data first.

[richardb]

We encountered this problem in a multimedia presentation done in 2002. The only way (that we found) was to transfer the whole site (asp) to html pages and dump them onto a CD rom. Thus guaranteeing that no matter what, anyone could read the files.

HTH

Rich

[TheNige]

you do not need Access installed to use MDB as your database. You just need the ADO drivers contained in the MDAC which is usually installed with any of the MS products like office.

[IanTurner]

Agree with TheNige, you don't need access itself but do need the ADO drivers, you can then use a DSNless connection to the database.

The thing you need to be careful about is that different versions of windows may have different versions of the drivers.

[WebJoe]

TheNige said what I meant. If your asp-pages are processed then all you need is MDAC or some other way to have the necessary ADO libraries for Jet installed