Hi Anthony.

Is there an OLEDB driver that works for VIstaDB .
I've jsut started to use .Net with the OLE DB driver for VFP . ans it seems that there are certain areas that this OLEDB driver just does not work correctly .

Regards,

Gerard



>Hi Kevin,
>
>> -Does VistaDB support stored procedures?
>
>Not in 2.0. We plan to host the CLR in 3.0, due out in early 2005.
>This will work much like Yukon.
>
>> -Does it support temp tables?
>
>Yes. You can create in-memory tables and physical temporary tables.
>Just so you know, VistaDB is much closer to Jet than to the MSDE
>
>> -Does it support UDFs?
>
>No.
>
>> -How closely does it support the SQL-92 standard?
>> In particular, I have instances where I return a scalar result from a subquery
>
>Quite closely. And yes, you can use scalers.
>
>> It does seem like a good alternative for instances where one wants a
>> small footprint - and if it supports those things, I might be able to use it.
>
>That's exactly the goal: VistaDB is designed to be an alternative to Jet.
>Just so you know, we've been working on VistaDB for 3+ years (4 guys at
>our company) and its based on many years of experience working on commercial
>data engines. The VistaDB eval we have for download is full featured so you
>can see first hand if VistaDB would be a good solution for some of your projects.
>
>
>Anthony Carrabino
>www.vistadb.net