Hi, i am writing a program that uses a db.
My db will have 3 tables and maximum of 5,000 records.
I want that the customers will download my application...
The proplem is that i don't know whether they hav a db engine or not.
I heard about MDAC for mdb files...
1) How can i check in my installation wizard whether the client has MDAC installed on his local mashine
2) Can u suggest me somthing better
Which DB to use?
Hot Topic
- inner join usage
- windows forms
- runtime error
- XML deserialization problems with invalid hex characters
- XHTML Validation Fails due to <asp:ImageButton> renders a BORDER="0" output
- Adding child nodes to my xmldocument
- Binding XML file to DataGridView in Windows Applications with C#
- can not add COM component (evalcom2.dll) to a visual studio 2005 project
- Dyanmic activation and enumerations
- Microsoft .NET Framework 1.1 & 2.0 (beta) Compatibility
.NET Development
- How do i generate an HTML email and send it using the SMTP mail class
- OleDbConnection Access 2003 Query Default Parameters?
- How do you avoid that events are thrown when updating a datatable?
- Size of object at runtime
- How do I access PCM waveform data with .NET?
- java.nio.Charset counterpart in .NET
- application configuration file
- Hashtable.Item thread safety
- errors connecting to sqlexpress
- How to insert Null value to foxpro tables?
Which DB to use?
JohnDale
But i XML is very slow and it isn't a database...
What about Sql server 2005 express
What the client has to install to use a sql server 2005 database
Oleg Tkachenko
firebird, definitely has better performance (firebird rox!!!). . . but its a full featured rdbms and I believe the OLEDb provider will cost you.
For the trivial database you describe, a jet db is your probable best bet.
Just be sure your users have the latest Jet package and mdacs.
Don't use odbc, use oledb.
remember to build a methodology for your users to compact their database.
Now the question is, are multiple users going to be accessing the same database
If so, I recommend SQL express.
JohanNil
and they are in process so easy to debug and no mismatch!
rp_parikh
I'd go with the XML approach as well.. 5k records ain't a whole lot.. read it in memory and you're golden. Other options would be to use MySql embedded database or Firebird embedded database. They'd be good options since they have .net providers available
RyanManning
Sure, why not try some XML as the datastore You should still be able to access all your "tables" via ADO I believe just as if they were part of a db, but no extra setup or license issues. Might be a bit more work to setup, but you're in FULL control the data contents.
Just a suggestion.
jmorgan
Since I haven't tried this personally I can't speak about this with authority. However, I believe once you read the xml into memory, it will be lightning fast!
re what client needs for SQL Server 2k5 db
I wonder if you just need to have the mde file (is that the file extension) and then just the ADO libs/dlls
Ok, now I'm getting out of my domain/comfort zone. I'm sorry. I hope someone else with more experience can reply (and help us both learn :>). Good luck.
digitalsuperman
heres one: http://www.zstyle.dp.ua/eng/iboledb_prod.htm
I have only seen an alpha stage Native provider for .Net 2.0.
firebird/interbase can have a steep learning curve but, in some cases, it is worth it as it is, by far, more robust than MySql.
again, is this a multi user app or one that is just embedded in a single user application
firebird is going to require a separate installation.
jet is part of the the MS platform.
BradleyT
Is FireBird .NET provider free license
Can I use it with my apps
yair_hak
Is FireBird easy to use