将 Business Basic 连接到 Windows 环境的选项
我正在寻找从 Windows 系统连接到(主要是读取数据)UNIX/AIX/Business Basic 的选项。 我主要使用 C# 进行编程,因此需要 .NET 解决方案。
欢迎提出解决方案或提出意见。
I'm looking for options for connecting to (primarily reading data) UNIX/AIX/Business Basic from Windows systems.
I program in C# mostly so would need a .NET solution.
Solutions or comments are welcome.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
这取决于您使用的 Business Basic 编译器。最常见的是 BBx,所以我将根据这个特定的编译器回答你的问题。 BBx 将在 Windows 或 Unix 平台上无缝运行。您可以在它们之间交换程序而无需重新编译它们。但是,您必须有一个编译器才能使其运行。请记住,BBx、ProvideX、Thorobred basic 等都是 M 代码编译器,而不是 P 代码编译器。大多数人使用 BBx 附带的实用程序在 BBx 环境和网站之间交换数据。去找编译器附带的BBx手册。您还可以使用可选的 ODBC 驱动程序。请致电新墨西哥州 Basis International 寻找司机。 BBx 的更高版本还可以读取/写入 SQL 数据库和其他类型的文件系统。但是,大多数 BBx 程序员将使用它附带的密钥文件系统。您还可以读取/写入 BBx 中的 ascii 文件。
请注意:BBx 和所有其他 Business Basic 编译器不使用平面 ascii 文件。他们可以编写平面 ascii 文件,但是,在我的 30 年里,我从未见过有人将它们用作文件结构。它们仅用于向 BBx 导入/导出数据。键控文件具有 SIT 区域、键控区域和数据区域。您需要在 BBx 中读取这些文件。如果您使用 C 或其他语言来更改文件中的数据,则会损坏校验和,并且该文件将变得无用。而且,您将会遇到一位非常生气的客户。
您还可以考虑为您的 Windows 环境获取一个 BBx 编译器来帮助您。如果您没有 BBx 端的源代码,这是相当便宜的选择。请记住,这不是基础知识……而是业务基础知识。
您还应该找到 BBx 端文件系统的数据结构。没有它,很难使用该系统。有些程序会内置 DBMS,您只需将记录布局打印到系统上的数百个文件中即可。
It depends upon which Business Basic compiler you are using. the most common is BBx, so I will answer your question based upon this particular compiler. BBx will run seamless on Windows or Unix platforms. You can interchange programs between them without recompiling them. BUT, you must have a compiler to make it run. Remember that BBx, ProvideX, Thorobred basic, etc are all M-code compilers, and not P-code compilers. Most people use the utility program that comes with BBx to interchange data between the BBx environment and a web site. Go find the BBx manuals that come with the compiler. You can also use an OPTIONAL ODBC driver. Call Basis International In New Mexico for the driver. Later versions of BBx can also read/write to SQL databases and other types of file systems. But, most BBx programmers will use the keyed file system that comes with it. You can also read/write to ascii files in BBx.
Please note: BBx and all other Business Basic compilers do NOT use flat ascii files. They can write flat ascii files, but, in my 30 years I have never seen anyone use them as a file structure. They are only used to import/export data to/from BBx. The keyed files have a SIT area, Keyed Area, and a Data area. You NEED to read these files in BBx. If you use C or some other language to alter the data in the file, you corrupt the Checksum and the file will become useless. And, you will have one very pissed off customer.
You might also consider getting a BBx compiler for your Windows environment to help you. Pretty cheap option if you don't have source code on BBx side. Remember this ISN'T Basic...it's Business Basic.
You should also find the data structures of the file system on the BBx side. It is very hard to work with the system without it. Some programs will have DBMS on-board, and you can just print out the record layouts to the hundreds of files on the system.
这在很大程度上取决于用于存储数据的格式。如果数据只是平面文件,您可以使用 rcp 或 ftp 之类的东西。许多 .NET 组件(包括商业组件和开源组件)都可用于此类访问。
如果没有,您可以查找 ODBC 驱动程序。有一些供应商出售 BBX、C-ISAM、D-ISAM 等驱动程序。
It all depends a lot on the format that is used to store your data. If the data is just flat files, you could use something like rcp or ftp. A number of .NET componentens, both commercial and open-source are available for this kind of access.
If not, you can look for ODBC drivers. There are some vendors that sell drivers for BBX, C-ISAM, D-ISAM, etc..
我同意 Mike 的观点,最简单的方法是使用 ODBC。您可以在基础网站 www.basis.com 上找到一个(他们是 bbx 创建者)。
如果您想快速快速访问数据,您最好在 bbx 中编写自己的后端,并让它使用套接字与您的 C# 程序对话。
我已经编写了一个网上银行应用程序(ASP.NET)以这种方式与 bbx 主机对话。
如果您需要进一步的帮助,请随时询问。
I agree with Mike, the easiest way would be to use an ODBC. you can find one on the basis web site www.basis.com (they are bbx creators).
If you want fast on the fly access to the data you would be better of writing your own back-end in bbx and have it talk to you C# program using sockets.
I have written an Internet banking app (ASP.NET) talking to a bbx host in this way.
If you need further help feel free to ask.
BBX 有 MS-Dos 版本。这样您就可以完全访问 MS-Dos 中的所有数据库。使用 DOSbox 工具,您可以模拟 Windows 7、8 和 10 的 ms-dos。
在 Windows 中,您必须为 Unix 数据库的网络和位置分配一个 Windows 驱动器号。
在 BBX 内可以安装此驱动器。
BBX does has a MS-Dos version. With this you can fully approach all the databases in MS-Dos. With a tool DOSbox you can emulate ms-dos for windows 7 8 and 10.
Within windows you have to assign a windows driveletter to the network and location of your Unix database.
Within BBX it's possible to mount this drive.