Best RDBMSs to use with VB6
We are embarking on a grand / grand project that will take about 1 year of full coding (4 developers) to get out of the launch pad.
It is a complete business management system.
We can use any commercially available RDBMS like Oracle, MS SQL Server, etc., but we try to use a free and open source RDBMS like FireBirdSQL, PostgreSQL, etc.
I would like to know which one is the best RDBMS and which got the best support for stable OLEDB vendors. We have experimented with OLEDB providers that are free for FireBird and pgSQL but are not satisfied with their performance and features.
Any suggestions please ....
If there are other Freeware and / or Open Source RDBMSs other than those listed above with high performance OLEDB vendors, please enlighten me.
Yogi Yang
Note. We will only use VB 6 and other development tools or compilers! The target software will have to run on Windows9x computers (about 60 users), and the RDBMS server will run on Linux / Windows, which ever fits.
source to share
I would be as conservative as possible, since your client hardware and software will need tender love. Since SQL Server and VB6 (and Windows) are all from Microsoft, I can't see how you have any other choice.
You might even want to use an older version of SQL Server, as the standard OLEDB server and client sides can fit better and be lighter. Otherwise SQL Server Express on Windows XP, I think, can handle many connections. It will definitely have power.
source to share
We can use any commercially available RDBMS like Oracle, MS SQL Server, etc., but we try to use a free and open source RDBMS like FireBirdSQL, PostgreSQL, etc.
What's wrong with the free editions of SQL Server, Oracle, or DB2? They are all significantly more powerful than the alternatives you mentioned, and they give you an upgrade path if you need to.
source to share
I had good experience with the MSSQL2005 database backend and VB6 clients grew to 60-100 concurrent client instances ... And it was a data heavy application with a lot of chat traffic, row blocking and what not.
Worked great. Database interaction was the least of the problems.
In this note ...
Please use parameterized queries if you don't hate yourself and don't want to suffer unnecessarily.
source to share