IBM DB2 ODBC驱动程序:: SQL1390C环境变量db2instance尚未定义或无效
我已经在线关注了几个指南,并且无法在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
Note: this is my C:\Program Files\IBM
folder and as you can see there is no bin
folder
Not sure if db2oreg1.exe -setup
is still mandatory, things might have changed.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
多亏了@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:
So I uninstalled the universal_fixpack and installed the client and the installation was successful.
在安装64位版本的数据服务器客户端时,我有这个问题。
我尝试过该产品的旧版本,但它们都失败了。它曾经有效,所以我确定问题不是软件,而是工作站环境中的某些问题。
这似乎是32位驱动程序或软件的问题。
我可以运行“
db2cli registerdsn ...
”,但不是“db2cli32 registerdsn ...
”我已经对IBM开了一个问题,但是他们无法在其他们的错误上重现其错误边。运行“
db2cli32寄存器” ...
“错误是它在db2dsdriver.cfg
,db2cli.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 indb2dsdriver.cfg
,db2cli.ini
or the catalog. If I create adb2cli.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.