Connect to AVAYA CMS database (Informix) using ODBC

Question

I'm trying to use .net to connect to an AVAYA CMS Informix database. I'm using Microsoft Visual Studio 2005 and connecting via a DNS I've created. I can see the tables no problem, but when I try to show the data on an .aspx page, I get the following error: "Parser Error Message: Unrecognized configuration section 'connectionStrings'" and it highlights line 12 which is:

<connectionStrings>

Does anyone have any idea why? Or better yet, does anyone have an example of how they connected to an AVAYA CMS Informix database using .net? Also, if I try to show the table data in Visual Studio, I get a different error: "Error Message: Failed to call the ODBC driver connection utility."

• Informix version 2000
• CMS version 14.0
• .net version 2.0

Answer 1

Hi David,

Whose ODBC Driver are you using when attempting your connection? Note that the Avaya CMS product used to ship with an OEM'ed version of the OpenLink Multi-Tier ODBC Drivers for Informix, but was only licensed for use with the Avaya CMS applications only and not 3rd party applications like VS 2005.

OpenLink have an equivalent Multi-Tier Managed ADO.Net Provider, with support for Visual Studio Integration that can be downloaded on evaluation from the following location:

http://download.openlinksw.com/download/product%5Fmatrix.vsp?p=l%5Fos&c=1&df=5

You need to select the Informix version (probably 9) and OS (probably Solaris 8 Sparc) and follow the links enabling you to select the .Net 2.0 ADO.Net Provider client.

Details on installation and configuration can be obtained from:

http://wikis.openlinksw.com/dataspace/owiki/wiki/UdaWikiWeb/InstallConfigADONETProviders

Best Regards

Hugh Williams

Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink

Answer 2

Hi Hugh,

I'm using the ODBC drivers that we got from AVAYA. It is the Openlink generic ODBC driver. I'll try your suggestions.

Thanks!

Dave

Answer 3

Hi David, i have one question for you, how can i make the connection to CMS database?, who are the users?, what do u need to do this?.