RE: [cobalt-users] [ChiliASP] which database ?

[Francois Thomas <FrancoisT@xxxxxxxxxxxx>]

> -----Message d'origine-----
> De : Brian M. Rahill [mailto:brian@xxxxxxxxxxxxxxxxxxxxxxx]
> Envoyé : jeu. 12 avril 2001 02:48
> 
> >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.

Thanks Brian
In fact, I found a solution. I have been told by Chilisoft support that
the relevant documentation is out of date. I now use MySQL, and the
recordset.addnew and update methods work just fine. It looks like being
the same for recordcount, but I did not test it really much.
I think this info maybe useful for other people here.
Best regards
François THOMAS