Gerard,
It's not as good as SQLserver OLEDB but in general it turns out to be wrong usage of .NET code (there are few areas that doesn't work right but most of them have simple workarounds).
What's that not working right?
Cetin
>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