best database platform for simple application
best database platform for simple application
best database platform for simple application
best database platform for simple application
best database platform for simple application
best database platform for simple application best database platform for simple application best database platform for simple application best database platform for simple application best database platform for simple application best database platform for simple application best database platform for simple application best database platform for simple application
best database platform for simple application best database platform for simple application
best database platform for simple application
Go Back  Xtreme Visual Basic Talk > > > best database platform for simple application


Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2017, 05:01 PM
AlanS AlanS is offline
Newcomer
 
Join Date: May 2003
Location: Philadelphia, PA, US
Posts: 18
Default best database platform for simple application


I'm designing a new application that requires basic database functionality (about a dozen tables, fairly simply queries, CRUD operations, etc.). The end users will be non-technical folks, and remotely located, so everything has to be as idiot-proofed as possible. I have extensive experience designing, coding and supporting an application with similar requirements using VB 6 (and an Access database created by the application during its initial run), and could easily use those old technologies, but for obvious reasons I would like to move up to VB.Net under VS 2017.

Some additional requierments for the application:
1. The application must NOT rely on any component or library (reporting tools, database access objects, MS office libraries, any particular version of the Dot Net Framework, etc.) being already present on the end user's machine, and the installation package must include and automatically install whatever's needed.
2. The application must run on Windows XP and all later versions of Windows (which I assume means it must target Dot Net Framework version 4.0).
3. The database used must require zero administration by the end user, and be royalty-free.
4. The application must include some basic reporting functionality, and be royalty-free.

I've got lots of experience using VB.Net with SQL Server in an enterprise environment, but that's not appropriate for this application. I've played around a bit with SQL Server Express 2014 (I'm developing on a Windows 7 machine, so the 2016 version is not an option), an Access database created via OLEDB, an Access database created via DAO, etc., but have run into problems with all of them.

So, my questions are:
1. What database platform would be the most appropriate?
2. Which reporting tool would be best?

Thanks in advance.
Reply With Quote
Reply

Tags
application, database, access, reporting, windows, created, run, version, server, experience, sql, vb.net, basic, functionality, framework, machine, designing, include, platform, net, royalty-free, dot, users, target, versions


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
best database platform for simple application
best database platform for simple application
best database platform for simple application best database platform for simple application
best database platform for simple application
best database platform for simple application
best database platform for simple application best database platform for simple application best database platform for simple application best database platform for simple application best database platform for simple application best database platform for simple application best database platform for simple application
best database platform for simple application
best database platform for simple application
 
best database platform for simple application
best database platform for simple application
 
-->