IPCC IVR with SQL Server 2005

Answered Question
Mar 28th, 2007

Has anyone tried this? Does it work? I know that SQL 2000 is officially supported, but customer has 2005. Will be using IPCC 4.0(5).

I have this problem too.
0 votes
Correct Answer by lpezj about 9 years 9 months ago

Yes, I have retrieved data from the SQL Server 2005 database without any problem.

Hope this helps,

Juan Luis

(Please, rate helpful posts ;-))

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
Loading.
lpezj Wed, 03/28/2007 - 23:42

Hi,

if you are talking about SQL Server 2005 as SQL Engine that repalce the SQL Server 2000 installation for IPCC Express, is not supported and the IPCC Express engine wouldn't work.

If you would like to access a SQL Server 2005 from the Database steps, try to set up a connection in the same way as for SQL Server 2000. It is likely that works, but I haver never try it.

Hope this helps,

Juan Luis

bgrunewald Thu, 03/29/2007 - 20:11

I'm talking about accessing an external database from the script, not the internal database for IPCC. Does anyone from Cisco know if this works or not? I don't have the Premium version, so I can't test it myself.

lpezj Fri, 03/30/2007 - 00:38

Hi,

I have set up a database connection to an SQL Server 2005 engine and it works with my IP/IVR 4.0(2). I have set up an ODBC connection to SQL Server 2005 and I can get registries from different databases using the DBXXXX steps in the script editor.

But, in the Cisco documentation, there is no explicit reference to support 2005, only SQL 7 and 2000.

Hope this helps,

Juan Luis

bgrunewald Tue, 04/03/2007 - 09:48

Have you retrieved any data from the database? If that works, I will take it as "not officially supported", but works.

Correct Answer
lpezj Tue, 04/03/2007 - 23:16

Yes, I have retrieved data from the SQL Server 2005 database without any problem.

Hope this helps,

Juan Luis

(Please, rate helpful posts ;-))

Actions

This Discussion