从 VB6 开始使用的最佳 RDBMS
我们正在着手一个宏伟/巨大的项目，这将需要我们大约一整年的编码（由 4 名开发人员）才能启动。
它是一个完整的业务管理系统。
我们可以使用任何商用 RDBMS，如 Oracle、MS SQL Server 等。但我们正在寻求使用免费软件和开源 RDBMS 系统，如 FireBirdSQL、PostgreSQL 等。
我想知道哪一个是最好的 RDBMS并为稳定的 OLEDB 提供商提供了最好的支持。 我们尝试了 OLEDB 提供程序，它们是 FireBird 和 pgSQL 的免费软件，但对其性能和功能不满意。
请提出任何建议......
如果除了上面列出的高性能 OLEDB 提供程序之外还有任何其他免费软件和/或开源 RDBMS，请赐教。
Yogi Yang
注意：我们将仅使用 VB 6，不使用其他开发工具或编译器！ 目标软件必须在基于 Windows9x 的 PC（大约 60 个用户）上运行，RDBMS 服务器将在合适的 Linux/Windows 上运行。
We are embarking on a grand/huge project which will take us around 1 full year of coding (by 4 developers) to get off 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 are looking out to use freeware and open source RDBMS system like FireBirdSQL, PostgreSQL, etc.
I would like to know as to which is the best RDBMS to use and which has got best support for stable OLEDB Providers. We have experimented with OLEDB Providers which are freeware for FireBird and pgSQL but are not satisfied with their performance and features.
Any suggestions please....
If there are any other Freeware and/or Open Source RDBMS other than listed above with high performing OLEDB Providers please enlighten me.
Yogi Yang
Note: We will be using VB 6 only and none other development tools or compilers! The target software will have to run on Windows9x based PCs (about 60 users) and the RDBMS server will run on Linux/Windows which ever is suitable.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我会尽可能保守，因为您的客户端硬件和软件需要精心呵护。 由于SQL Server和VB6（和Windows）都来自微软，我不明白你还有什么其他选择。
您甚至可以考虑使用旧版本的 SQL Server，因为标准 OLEDB 服务器和客户端部分可能会更好地排列，并且重量更轻。 否则，我认为 Windows XP 上的 SQL Server Express 可以提供这么多连接。 它肯定会有马力。
I'd be as conservative as possible, since your client hardware and software will need tender loving care. Since SQL Server and VB6 (and Windows) all come from Microsoft, I don't see how you have any other choice.
You might even consider using an older version of SQL Server, since the standard OLEDB server and client parts might line up better, and be lighter-weight. Otherwise SQL Server Express on Windows XP I think can serve that many connections. It certainly would have the horsepower.
正如您对 Microsoft 的期望一样，SQL Server 和 SQL Native Client 的 OLE DB 提供程序可以与 SQL Server Express 很好地配合，因此是 VB6 的绝佳选择。
The OLE DB providers for SQL Server and SQL Native Client work well with SQL Server Express, as you'd expect from Microsoft, and therefore are an excellent choice for VB6.
免费版本的 SQL Server、Oracle 或 DB2 有什么问题？ 它们都比您提到的替代方案更强大，并且如果您需要的话，它们会为您提供升级路径。
What's wrong with the free versions 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 it.
我对 MSSQL2005 数据库后端有很好的经验，VB6 客户端最多有 60-100 个并发客户端实例...这是一个数据密集型应用程序，具有大量繁琐的数据库流量、行锁定等。
效果很好。 与数据库交互是最少的问题。
关于这一点...
请使用参数化查询，除非您讨厌自己并且想要遭受不必要的痛苦。
I've had good experience with a MSSQL2005 database backend, with VB6 clients upward of 60-100 concurrent client instances... And this was a data-heavy application with A LOT of chatty database traffic, row locking, and what not.
Worked great. Interacting with the database was the least of the problems.
On that note...
Please use parameterized queries, unless you hate yourself and want to suffer needlessly.