Voicemail Pro Database Connection Error

[stivtaber]

Trying to connect voicemail pro to a sql database to log data from a telephone survey; been troubleshooting it for a while but am unable to get the vmpro to connect and write to the database.

Call flow goes: Start point --> 'db open' token --> 'generic' where a prompt is played and $KEY is stored in $CP1 --> 'db execute' with the following sql statement:

INSERT INTO SRVRESULTS
(SRVNAME, SRVQUES, SERVRESULTS)
VALUES ("1", "1", "$CP1")

The call flow is failing at the database open, as i have the failure set to play a wav file to indicates as such. No details in monitor but dbgviewer logs the code below. I am able to connect an Access db to the same sql table and write to it, as well as query and write to the database from SQL Management Studio, all using the same Machine Data Source.

6 vmprov5s (17,8)  d90,370c8: > DatabaseApp::Main()
30/01 12:16:18.477 vmprov5s (17,9)  d90,370c8:   > TmodDatabaseAccess::Open(Connection: <Provider=MSDASQL.1;Password=P@ssword;Persist Security Info=True;User ID=IVRSQL;Mode=ReadWrite;Extended Properties="DSN=IVRSURVEY;Description=IVR SURVEY;Trusted_Connection=Yes;APP=IP Office;WSID=AVAYACALLCENTER;DATABASE=VMPROSURVEY;Network=DBMSSOCN";Initial Catalog=VMPROSURVEY>)
30/01 12:16:18.478 vmprov5s (25,2)  d90,370c8:     Exception "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" has occurred in TmodClrObjects::Open (.\TmodDatabaseAccess.cpp[210])
30/01 12:16:18.478 vmprov5s (09,2)  d90,370c8:     Exception "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" has occurred in TmodClrObjects::Open (.\TmodDatabaseAccess.cpp[210])
30/01 12:16:18.479 vmprov5s (17,9)  d90,370c8:   < TmodDatabaseAccess::Open()
30/01 12:16:18.479 vmprov5s (09,2)  d90,370c8:   Session: 00029f62 - Database open failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
30/01 12:16:18.479 vmprov5s (06,9)  d90,370c8:   > InfoPacket(module=VMAIL F:278622,"Database Operation", "Open", "Open Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified", event=(null), data=(null), data2=(null))

Details:
Avaya IP500v2 7.0.31 - Advanced Edition
VMPRO 7.0.32
Windows Server 08 Standard R2 x64
SQLServer 2008 x64
Server Roles: Contact Store, Cash+


Any help or guidance appreciated.



Stiv Taber
Certified in Convergent Network Technologies
APSS - SME Communications
PA - Implement IPO Professional Edition

 

[sizbut]

Voicemail Pro talks ODBC, not SQL. Microsoft does have an ODBC driver for SQL but I don't think its installed by default with any of the OS's or the MS-SQL offerings. Access does support ODBC by default.

So I suspect your options are, download and install the MS-SQL ODBC driver (

http://www.microsoft.com/en-US/download/details.aspx?id=36434),

else write to an Access DB as middleware from which your SQL can copy data.

Stuck in a never ending cycle of file copying.

 

[stivtaber]

Using the sql driver when creating my machine data source already. Will check to see if its up to date though.


Stiv Taber
Certified in Convergent Network Technologies
APSS - SME Communications
PA - Implement IPO Professional Edition