Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VistaDB 2.0 released
Message
From
16/10/2004 13:30:27
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00950328
Message ID:
00951958
Views:
13
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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform