IBM DB2 ODBC驱动程序:: SQL1390C环境变量db2instance尚未定义或无效

发布于 2025-02-11 04:10:57 字数 1097 浏览 2 评论 0原文

我已经在线关注了几个指南,并且无法在Windows上安装IBM DB2 ODBC驱动程序。

我已经下载了来自IBM 并安装的驾驶员(这是一个相当的滚筒式车道)。

如果我关注 guide1 href =“ https://knowledge.informatica.com/s/article/370019?language= en_us” rel =“ nofollow noreferrer”> guide2 结果是相同的:

SQL1390C The environment variable DB2INSTANCE is not defined or is invalid

i.sstatic.net/fyuoh.png“ rel =“ nofollow noreferrer ” 强>注意:这是我的c:\ program Files \ ibm文件夹,如您所见,没有bin文件夹

不确定db2oreg1.exe -setup仍然是强制性的,事情可能已经改变了。

I've followed several guides online and I cannot install IBM DB2 ODBC DRIVER on Windows.

I have downloaded the driver from IBM and installed (which was quite a roller-coaster).

If I follow guide1 or guide2 the result is the same:

SQL1390C The environment variable DB2INSTANCE is not defined or is invalid

enter image description here

Note: this is my C:\Program Files\IBM folder and as you can see there is no bin folder

enter image description here

Not sure if db2oreg1.exe -setup is still mandatory, things might have changed.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

乖乖公主 2025-02-18 04:10:57

多亏了@markbarinstein,我发现了问题所在。

我遵循了本指南如何在Windows 7-64位中安装IBM DB2 ODBC驱动程序?我下载了错误的软件包:我下载了 Universal_fixpack ,而不是 client

我意识到,当我在下载目录中看到两个文件夹时:

​。

Thanks to @MarkBarinstein I found where the problem was.

I've followed this guide How to install IBM db2 ODBC driver in Windows 7 - 64 bit? and I downloaded the wrong package: I downloaded the universal_fixpack instead of the client.

I realized that when I saw the two folders in the Download directory:

enter image description here

So I uninstalled the universal_fixpack and installed the client and the installation was successful.

断念 2025-02-18 04:10:57

在安装64位版本的数据服务器客户端时,我有这个问题。
我尝试过该产品的旧版本,但它们都失败了。它曾经有效,所以我确定问题不是软件,而是工作站环境中的某些问题。

这似乎是32位驱动程序或软件的问题。
我可以运行“ db2cli registerdsn ...”,但不是“ db2cli32 registerdsn ...

我已经对IBM开了一个问题,但是他们无法在其他们的错误上重现其错误边。运行“ db2cli32寄存器” ...“错误是它在db2dsdriver.cfgdb2cli.ini或目录中找不到数据库。如果创建db2cli.ini文件,我可以注册ODBC数据源,但是当我尝试从32位应用程序中使用它们时,它会失败,再次使用-1390 < /代码>错误。

您是否有机会使用Sentryone对终点保护?我知道我们可以在进入Sentryone之前运行安装,并且在进入Sentryone后不能。当我们切换到Sentryone时,安装的安装差距有3到4个月,因此可能会影响其他事情。现在,我有一个相关性,但无法证明因果关系。我不知道它是否可以在我们的Windows政策中进行更改。

I have that issue when installing the 64-bit version of Data Server Client.
I have tried old versions of the product but they all fail. It used to work, so I am sure it is not the software that is the issue, but something in the workstation environment.

It appears to be an issue with the 32-bit drivers or software.
I can run "db2cli registerdsn ..." but not "db2cli32 registerdsn ..."

I have had an issue opened with IBM, but they cannot reproduce the error on their side. When running "db2cli32 registerdsn ..." the error is that it cannot find the database in db2dsdriver.cfg, db2cli.ini or the catalog. If I create a db2cli.ini file, I can register the ODBC data sources, but when I try to use them from a 32-bit application, it fails, again with the -1390 error.

Do you by any chance use SentryOne for end-point protection? I know we could run the install prior to going to SentryOne and we can't after going to SentryOne. There is a 3 to 4-month gap in installations around when we switched to SentryOne, so there could be other things impacting it. Right now, I have a correlation but cannot prove causation. I don't know if it could be changed in our Windows policies.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文