我有一个开发项目，要求我们能够通过ODBC支持informix数据源。我已经从 IBM 网站下载了预构建的 Informix Virtual Appliance，并且能够使用内置工具查看服务器，但无法从客户端上的 ODBC 连接获取它！
我还安装了 ODBC 支持包，并且知道驱动程序已安装。
我从未真正使用过 Informix，所以我不知道我是否缺少一些技巧，但如果有人有任何建议，我会采纳。
I have a development project that requires us to be able to support informix data sources via ODBC. I've downloaded the prebuilt Informix Virtual Appliance from the IBM website and am able see the server with the built in tools, but haven't been able to get at it from an ODBC connection on the client!
I have the ODBC support package installed also, and know that the driver is installed.
I've never really worked with Informix, so I don't know if there's some trick to it that I am missing, but if anyone has any suggestions, I'll take 'em.
发布评论
评论（2）
以下是我最喜欢的网站上的 Informix ConnectionStrings，可供此类参考：
http://www.connectionstrings.com/informix
OleDb：
连接字符串中包含安全信息的 OleDb：
Here are the Informix ConnectionStrings on my favorite site for such references:
http://www.connectionstrings.com/informix
OleDb:
OleDb with security info in the connection string:
很多问题；可能没有实际的答案，但有些事情可能会促使你思考寻找答案。
您是否以“开发者”身份登录？或者作为其他用户 - 如果是，是哪一个？
如果您说“.NET”，则可能您有一个基于 Windows 的 VM（即，它是在 Windows 环境中运行的 IDS，无论 VMware 映像本身在何处运行）。
您是否有“.odbc.ini”文件，或者您是否像 David Stratton 的回答一样使用无 DSN 的连接？
你看过SETNET32吗？ （再想一想，也许您不想这样做；但有时它是解决 Windows 问题的一部分 - 它为 Windows 连接到 Informix DBMS 设置环境。）
您可以向我们展示最少的代码吗以及您用来连接的字符串？不要显示实际密码！
您是否尝试过编译并运行 $INFORMIXDIR/demo 中的任何演示？
Lots of questions; probably no actual answer, but something may jog your thoughts into finding an answer.
Are you logged in as 'developer'? Or as some other user - and if so, which one?
If you say '.NET', presumably you have a Windows-based VM (that is, it is IDS running in a Windows environment, regardless of where the VMware image is itself running).
Do you have a '.odbc.ini' file, or are you using DSN-less connections as in David Stratton's answer?
Have you looked at SETNET32? (On second thoughts, maybe you don't want to; but it is sometimes a part of the solution to problems on Windows - it sets the environment for the Windows connections to Informix DBMS.)
Can you show us the minimal code and strings that you are using to connect? Don't show an actual password!
Have you tried compiling and running any of the demos from $INFORMIXDIR/demo?