Problems retrieving call data, agent data etc.

denniskrogstrup — Fri, 01 Mar 2019 10:50:10 GMT

I hope that some of you guys can help me.

I'm making a system much like the historical report program for UCCX, but I'm having trouble getting access to the data that is available for the historical report program.

I don't have much information about where to look, but what I've found out is that the data is stored in the db_cra database on our UCCX server.

It uses an Informix DB and I have already installed drivers found else where on Cisco DevNet, but I still can't seem to get through to the database.

I'm implementing the script in an old application using Classic ASP, but I can also use .NET C# if that is easier, so help for either would be much appreciated.

Following drivers are installed:

IBM INFORMIX ODBC DRIVER

IBM DB2 ODBC DRIVER - IBMDBCL1

IBM DB2 ODBC DRIVER

I've tried the following connectionstrings for classic asp:

DSN = "Database=db_cra; Host=#UCCX_IP#; Server=uccx; Service=1504; Protocol=onsoctcp; UID=#User#; Password=#Password#; Persist Security Info=true; Authentication=Server"

DSN = "Provider=Ifxoledbc; Data Source=db_cra@#UCCX_IP#; User ID=#User#; Password=#Password#;"

DSN = "Driver={INFORMIX 3.30 32 BIT}; Host=#UCCX_IP#; Server=uccx; Service=1504; Protocol=onsoctcp; Database=db_cra; Uid=#User#; Pwd=#Password#;"

DSN = "Driver={Informix-CLI 2.5 (32 Bit)}; Server=#UCCX_IP#; Database=db_cra; Uid=#User#; Pwd=#Password#;"

DSN = "Database=db_cra; Host=#UCCX_IP#; Server=uccx; Service=1504; Protocol=onsoctcp; UID=#User#; Password=#Password#; DB_LOCALE=EN_US.UTF8; CLIENT_LOCALE=EN_US.UTF8;"

DSN = "Dsn=ICacheDB;Driver={INFORMIX 3.82 32 BIT}; Host=#UCCX_IP#; Server=uccx; Service=1525; Protocol=sesoctcp;Database=db_cra;UID=#User#;PWD=#Password#"

DSN = "Driver=informixdsn; Host=#UCCX_IP#; Server=uccx; Service=1504; Protocol=onsoctcp; Database=db_cra; Uid=#User#; Pwd=#Password#;"

DSN = "Provider=ciscodsn; Host=#UCCX_IP#; Server=uccx; Service=1504; Database=db_cra; Uid=#User#; Pwd=#Password#;"

DSN = "DSN=ciscodsn;Uid=#User#;Pwd=#Password#;"

DSN = "Driver={IBM INFORMIX ODBC DRIVER};Client_Locale=en_US.UTF8;DB_LOCALE=en_US.UTF8;Server=dwuccx_uccx;Host=DWUCCX;Service=1504;Protocol=onsoctcp;DatabaseName=db_cra;Uid=#User#;Pwd=#Password#;"

I always seem to get 1 of 2 responses:

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

As you can see the latter refers to Microsoft OLE DB Provider for SQL Server, so I think that this is my problem, that the server can't seem to get that it should use the IBM/Informix driver.

I hope that some of you can help me.

Re: Problems retrieving call data, agent data etc.

ewindgat — Tue, 18 Aug 2015 14:55:30 GMT

You could try to install the SQL Server ODBC driver. ODBC drivers are usually used when you are not using ADO.NET for data access.

Re: Problems retrieving call data, agent data etc.

denniskrogstrup — Tue, 25 Aug 2015 10:09:17 GMT

SQL Server ODBC driver is already installed. I think the problem is that I can't get the system to change from using SQL Server ODBC to one of the following 3 ODBC drivers instead:

IBM INFORMIX ODBC DRIVER

IBM DB2 ODBC DRIVER - IBMDBCL1

IBM DB2 ODBC DRIVER

topic Problems retrieving call data, agent data etc. in DevNet General Discussions

Problems retrieving call data, agent data etc.

Re: Problems retrieving call data, agent data etc.

Re: Problems retrieving call data, agent data etc.