Informix连接通过Windows工作，但不是通过Cygwin工作 [英] Informix connection works through Windows, but not through Cygwin

问题描述

不是真的确定去哪里去这一个。我有一个PHP脚本，它调用一个连接到Informix数据库的PERL脚本。这个设置工作正常，当我运行脚本到Windows cmd提示符，但当我尝试通过cron在cygwin中运行它失败

Not really sure where to go with this one. I have a PHP script that invokes a PERL script that connects to an Informix database. This setup works just fine when I run the script to the Windows cmd prompt, but when I attempt to run it through cron in cygwin it fails on

[Informix] [Informix ODBC驱动程序]无法加载翻译共享库（DLL）。 （SQL-IM009）

[Informix][Informix ODBC Driver]Unable to load translation shared library (DLL). (SQL-IM009)

我试过添加Informix bin目录（/ cygdrive / c / Program\ Files \ ）/ IBM / Informix / Client-SDK / bin）到crontab文件中的PATH变量，但没有更改。我也试过将同一目录添加到crontab文件中的INFORMIXDIR变量，但是后来我得到了以下错误信息：

I have tried adding the Informix bin directory (/cygdrive/c/Program\ Files\ (x86)/IBM/Informix/Client-SDK/bin) to the PATH variable in the crontab file but there were no changes. I also tried adding that same directory to the INFORMIXDIR variable in the crontab file, but then I got the following error message

[Informix] Informix ODBC驱动程序] [Informix]未指定的系统错误= -23101。 （SQL-HY000）

[Informix][Informix ODBC Driver][Informix]Unspecified System Error = -23101. (SQL-HY000)

如果我在finderr.exe（由驱动程序提供）中看到这个错误，是无法加载语言环境类别或我的INFORMIXDIR不正确，但我不知道如何设置CLIENT_LOCALE或DB_LOCALE。

If I look that error in finderr.exe (supplied by the driver) I see that it means that it is Unable to load locale categories or my INFORMIXDIR is incorrect, but I am not sure how to set the CLIENT_LOCALE or DB_LOCALE.

然后我认为我通过使用正确的目录分隔符和我删除了crontab中的INFORMIXDIR变量的bin子目录，因为我得到了SQL-IM009错误。

Then I think I fixed this by using the correct directory separators and I dropped the bin subdirectory for the INFORMIXDIR variable in crontab, because I got the SQL-IM009 error again.

我使用cygwin中的Windows PHP和PERL可执行文件，所以我不知道为什么它不工作，如果我通过cmd提示运行它。会有人知道为什么是这样吗？

I am using the Windows PHP and PERL executables in cygwin, so I am not really sure why it wouldn't work as it does if I run it through the cmd prompt. Would anybody know why this is?

我在Windows Server 2008 R2云实例上运行这个，我试图复制一个工作设置，以便我们可以移动它到一个异地位置。

I am running this on a Windows Server 2008 R2 cloud instance, and I am attempting to copy a working setup that so that we can move it to an offsite location.

推荐答案

事实证明cygwin不喜欢Client-SDK所在的目录。一旦我重新安装它到C：/ IBM / Informix / Client-SDK一切开始工作。我不知道问题是圆括号还是空格，但是让他们走出路径似乎做了。

It turns out that cygwin didn't like the directory that the Client-SDK was in. Once I reinstalled it to C:/IBM/Informix/Client-SDK everything started working. I am not sure if the problem was the parentheses or the spaces, but getting them out of the path seemed to do the trick.

这篇关于Informix连接通过Windows工作，但不是通过Cygwin工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！