从Informix数据库读取数据.具有* .IDX，*.Dat文件的文件夹app.dbs [英] Read data from Informix Database. Having folder app.dbs with *.IDX, *.Dat files

问题描述

我有一个拥有管理应用程序的朋友，他想在Excel中导入一些数据.

I have a friend who has a management application, and he would like to import some of his data in Excel.

问题是我不知道如何读取此类文件，

The thing is I have no idea about how to read this type of files,

在他的应用程序目录中，他有一个名为app.dbs的文件夹.里面有* .idx和* .dat文件.

In his application directory he has a folder named app.dbs. Inside there are *.idx and *.dat files.

读取此文件的最简单方法是什么?也许是ODBC连接器，还是安装了某些版本的Informix DB?

What would be the easiest way to read this files? Maybe ODBC connector, or installing some version of Informix DB??

推荐答案

这听起来像C-ISAM文件或Informix-SE(标准引擎)安装.您最肯定无法直接阅读它们.谷歌搜索 Informix C-ISAM文件ODBC 产生了很多结果.另外，此页面解释了两者之间的关系.

That sounds like C-ISAM files, or an Informix-SE (Standard Engine) install. You most certainly can't read them directly. Googling Informix C-ISAM files ODBC generates plenty of results. Also this page explains the relationship between the two.

我从没使用过SE，但是假设其安装与它的哥哥Informix Dynamic Server(并且我相信是)相当相似，请在您朋友的计算机上查找"Informix"目录.您可能会找到一个%INFORMIXDIR%环境变量，以指示您正确的方向.在其中，在其名为dbaccess.exe的子目录bin中查找可执行文件.从DOS提示符下运行该命令，您应该希望获得一个SQL解释器，以允许您读取和提取数据.

I've never used SE, but assuming its installation is reasonably similar to its big brother Informix Dynamic Server (and I believe it is), have a look on your friend's computer for an 'Informix' directory. You may find an %INFORMIXDIR% environment variable to point you in the right direction. Within that, look for an executable in its subdirectory bin called dbaccess.exe. Run that from a DOS prompt and you should hopefully get an SQL interpreter that allows you to read and extract the data.

如果没有运气找到这样的目录，那么管理应用程序"很可能直接编写C-ISAM，并且据推测，您将需要用于C-ISAM的ODBC驱动程序.

If you have no luck finding such a directory, then it's more than likely the "management application" is writing C-ISAM directly, and you'll need an ODBC driver for C-ISAM, as you surmised.

这篇关于从Informix数据库读取数据.具有* .IDX，*.Dat文件的文件夹app.dbs的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！