Gift Peddie Posted 9 years ago You can’t post new polls. The server name should be given in the format of database servername. Microsoft Visual Studio ——————————. Use the SetNet32 application provided with the drivers and set up the Server Information tab appropriately. If she would have chosen the Informix driver the catalog would have been grayed out.

Uploader: Daishura
Date Added: 27 February 2016
File Size: 26.68 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 45681
Price: Free* [*Free Regsitration Required]

Reply to this comment. You can’t edit HTML code.

Server is not found or not accessible. These two should be the same. Can anyone help me to fix this issue?

Notify me of new comments via email. Blogroll Contact Me WordPress. By continuing to use this website, you agree to their use. You can’t edit your own posts. Keep up to date – daily newsletter:. For Issue 1, what bit-level of the drivers did you install and what bit-level of SQL Server are you running? You can’t post IFCode. We had a nightmare setting something similar up, specifically with the issue of connecting to multiple Informix environments. You can’t post new topics. Sign up using Email and Password.


The trick with the Linked Server setup is to use the following items in codeblocks are literal: You can’t edit other posts. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

I hope this is not your issue, as the workaround looks plain awful. You can’t post or upload images. We did just upgrade our ssis packages to SQL in the process we upgraded our Informix drivers to the latest 64 bit version but followed the same process outlined in my post. You can’t send private messages.

How to Connect to Informix from an SSIS Package

Then configurations window will pop up. You can’t delete other topics. When I tried to see the tables by selecting table or view data access mode, I got below error message. Coould not open a connection to SQL Server. About ldgaller Accomplished Data Warehouse Olevb, DBA and Software Architect with over 15 years of professional experience and demonstrated success designing and implementing solutions that improve business functionality and productivity.


JohnEisbrener I do see the infromix when connected as myself an admin and connected as another local admin account. Fill Server information and Host information with correct details to your Informix server.

Stack Overflow works best with JavaScript enabled. Sign up or log in Imformix up using Google. Sign up using Facebook. Email Required, but never shown.

Monitor IBM Informix databases with ipMonitor – SolarWinds Worldwide, LLC. Help and Support

Meta Register Log in. You can’t post new polls. Give any data source name and fill appropriate connection details. Then install the product including IBM data server driver package.