n fact, quite everything in the sites was coded with the use of the recordset object with the addnew/update methods. These methods are not supported with ChiliASP and ADO link to PostgreSQL or MySQL databases. So, what I want to know is: which free (or cheap) database could I use on the RaQ with ADO support for these fonctions ?
I'm not an ASP guru so bear with me. But I've had some sites that use Access databases that I've had to move from NT to my Raq. I've taken the Access db and exported it to a dBASE format and changed the ASP to make calls to the new dBASE file. That seemed to work pretty well. There are a few issues though. Such as dBASE doesn't support fieldnames longer than 10 characters so some of the fieldnames got truncated, so I had to fix that in the code. Other than that it was pretty easy to get it to run.
Hope this helps. Brian