Hi,

This may sound like a weird question, but has anyone tried using VistaDB with DNN since VistaDB is SqlServer Compatible?

If so, then what experience?

Thanks,

Sam

Jeff,

Thanks for your reply...

The main reason was to create a lean mean CMS with an embedded DB. Hosting ISPs do not like SqlServer Express so one's only option is to use MS SqlServer .Apparently DNN does not use the full ado.net provider model, it writes to the SQLClient class directly hence the difficulty. Apparently this is not necessarily a bad thing I guess for performance, but makes life hard if you want to link to another DB.

Do you have comments on the above? Is my understanding correct?

Thanks,

Sam...

Sebastien,

Thanks for the reply. However why does DNN not use the standard ADO.NET and hence access multiple DBs via the standard ADO.NET functionality. Perhaps I am misunderstanding about the DB connectivity works in DNN.

Thanks,

Sam