VMPro Database connection problem 2

[Draeus]

Hi there,

I'm having some trouble connecting VMPro to a database. It's just a simple, temporary survey we are trying to take. We want to capture caller ID and then there is a prompt asking to pick from a small list. The database is a mysqld jumpbox. I connected to it with ODBC and the connection tests fine. Connected to the ODBC with VMPro and tests fine. In the database execute, I can see the two entry points I set up in the database, so it sees it. It goes database open - capture caller id - menu for survey number input - capture survey number input - database execute putting both numbers in their spot - database close. There will be another point added for voice response somewhere in there after I get the rest working. I put in voice prompts at database open and the menu for survey input. The problem is, it isn't getting past database open. The prompt happens and then nothing. I put temp spots for both if it succeeds and if it fails, and it doesn't give me either. A few seconds after the database open prompt, the phone goes dead. I was directed to the debugger on the knowledge base which seems to tell me that access is denied or the database doesn't exist. My capture from it looks like that:

25/05 11:25:41.296 vmprov5s (09,5) 5f4, 6b8: new VMAIL Client [01DCE730] [Connections 0 - 1] [INBAND DTMF=YES]
25/05 11:25:41.312 vmprov5s (06,5) 5f4, 6b8: VMClient::RxOpen - Created dialog 01DF9F90
25/05 11:25:41.312 vmprov5s (06,5) 5f4, 6b8: VMClient::RxOpen 01DCE6C8 Survey (4), session=000000e7, dialog=01DF9F90, Fallback number is ""
25/05 11:25:41.312 DbgOut (01,5) 1524,1680: DllMain(hinstDLL=0x10000000, fdwReason=DLL_THREAD_ATTACH)
25/05 11:25:41.328 vmprov5s (23,5) 5f4, 690: SoundsManager::ConvertWAV(01DF4E68, "C:\Program Files\Avaya\IP Office\Voicemail Pro\VM\Wavs\Custom\NumericPrompts\en\16000.WAV" [uLaw], 01DF9F90) - Took 0 ms to process, return is 18000
25/05 11:25:41.328 vmprov5s (23,5) 5f4, 690: Succeeded in loading sound bite "C:\Program Files\Avaya\IP Office\Voicemail Pro\VM\Wavs\Custom\NumericPrompts\en\16000.WAV" [uLaw]
25/05 11:25:43.812 DbgOut (01,5) 1524, 704: DllMain(hinstDLL=0x10000000, fdwReason=DLL_THREAD_ATTACH)
25/05 11:25:44.484 DbgOut (01,5) 396,2036: DllMain(hinstDLL=0x016A0000, fdwReason=DLL_THREAD_DETACH)
25/05 11:25:57.234 vmprov5s (19,5) 5f4, 7bc: CMAPIImpl::CheckMAPIConnection() - return is 0
25/05 11:25:57.234 DbgOut (01,5) 1524,1576: DllMain(hinstDLL=0x10000000, fdwReason=DLL_THREAD_ATTACH)
25/05 11:25:57.250 vmprov5s (66,2) 5f4, 628: CMAPIImpl::Connect[2893]: Error 0x80004005 [MAPI_E_CALL_FAILED] from MAPIInitialize trying to initialize MAPI support
25/05 11:25:57.250 vmprov5s (19,2) 5f4, 628: Error (hr=0x80004005 [MAPI_E_CALL_FAILED]) from MAPIConnect
25/05 11:25:57.250 DbgOut (01,5) 1524,1576: DllMain(hinstDLL=0x10000000, fdwReason=DLL_THREAD_DETACH)
25/05 11:25:58.234 vmprov5s (09,5) 5f4, 7bc: IP Office Voicemail Pro [Hardware mode 00] - Version 8.0 (1011) [CPU Usage 0.6] [CPU Min:0.0, Avg:0.3, Max:75.0] has been running for 9 days, 19 hours and 43 minutes and received 225 calls (0 missed voice packets) (224 completed, 1 calls/hour) (Call duration(secs) - Min:0, Max:117, Avg:12).
25/05 11:25:58.234 vmprov5s (09,5) 5f4, 7bc: System Configuration:-
Voicemail Pro mode, locale: enu, IPO hardware mode: 00 []
25/05 11:25:58.234 vmprov5s (09,5) 5f4, 7bc: EVML:-
25/05 11:25:58.234 vmprov5s (09,5) 5f4, 7bc: Maximum recording capacity: Unlimited, Maximum Recording Time: 120 seconds
25/05 11:25:58.234 vmprov5s (09,5) 5f4, 7bc: Maximum Sessions: 4, Minimum PIN length: 0 digits
25/05 11:25:58.234 vmprov5s (09,5) 5f4, 7bc: SMTP:-
Host address 0.0.0.0, port 25, Login method "none", email from "", login user ""
25/05 11:25:58.234 vmprov5s (09,5) 5f4, 7bc: Voicemail Sessions (Connections 1 - 1) (Links:11927 from 12000) (CMMsg:1 left from 1) (VM:1 NODES:70 SN:1 SBL:0 FILES:2)
25/05 11:26:01.515 vmprov5s (17,2) 5f4, 2c0: Database Error: TmodClrObjects:vtOpen[499]: Failed to "open the database using "Provider=MSDASQL;Persist Security Info=False;User ID=admin;Data Source=Survey;Initial Catalog=Survey"", error -2147467259 [0x80004005] - [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. [source=Microsoft OLE DB Provider for ODBC Drivers] [[0]: Error number -2147467259 [80004005] - [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied., native number 17 - 08001, [1]: Error number -2147467259 [80004005] - [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())., native number 53 - 01000].
25/05 11:26:01.515 vmprov5s (09,2) 5f4, 2c0: Session: 000000e7 - Database open failed: TmodClrObjects:vtOpen[499]: Failed to "open the database using "Provider=MSDASQL;Persist Security Info=False;User ID=admin;Data Source=Survey;Initial Catalog=Survey"", error -2147467259 [0x80004005] - [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. [source=Microsoft OLE DB Provider for ODBC Drivers] [[0]: Error number -2147467259 [80004005] - [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied., native number 17 - 08001, [1]: Error number -2147467259 [80004005] - [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())., native number 53 - 01000].
25/05 11:26:01.515 vmprov5s (09,5) 5f4, 2c0: Session: 000000e7 - DATABASE OPEN TOOK 17704ms [Parameter was Provider=MSDASQL;Persist Security Info=False;User ID=admin;Data Source=Survey;Initial Catalog=Survey]
25/05 11:26:01.531 DbgOut (01,5) 1524, 704: DllMain(hinstDLL=0x10000000, fdwReason=DLL_THREAD_DETACH)
25/05 11:26:03.062 vmprov5s (09,5) 5f4, 690: Session: 000000e7 - ~IClient [Call duration: 21 secs, 0 missed packets] [Connections 0 - 0] [Buffer pool(0:1000 1:250 2:2500 3:1495) allocated:5, seq:0] [Links:11927 from 12000] [CMMsg:1 left from 1] [VM:0 NODES:13 SN:0 SBL:0 TASKS:8 FILES:0 Msgs:7]
25/05 11:26:03.062 DbgOut (01,5) 1524,1680: DllMain(hinstDLL=0x10000000, fdwReason=DLL_THREAD_DETACH)

SOOOO.... thoughts? Stumped on this for awhile now and really need to get it running.

Thanks for any help!

Josh

 

[intrigrant]

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Clear enough for me, no ODBC link to SQL or wrong credentials.

A simple mind delivers great solutions

 

[Draeus]

I understand that much... But if the connection from ODBC is good and the connection from VMPro when I test it is good, how would it not connect when in use?

 

[mattKnight]

Are you sure that you mean to use the MSSQL OLEDB driver, rather than the MySQL one as that is the way I read your connection string

Take Care

Matt
I have always wished that my computer would be as easy to use as my telephone.
My wish has come true. I no longer know how to use my telephone.

 

[Draeus]

I believe so. Using MS OLEDB for ODBC drivers to get from VMPro to ODBC. ODBC to the the MySQL database with the MySQL connector. There is no MySQL connector in VMPro. There is a connection for MS SQL Server, but as I'm not using the MS SQL database, it doesn't see it. Sorry if it gets a little vague around here. I don't do much with databases and never have connected to one with VMPro. Again, the tests come back fine from the VMPro to ODBC and from ODBC to MySQL, though, and I can see the database entry points that are set up on the MySQL server when I make the database execution prompt...

Thanks again for the thoughts

 

[sizbut]

Slightly sideways but isn't what you're trying to do exactly what Campaigns intended for? Much easier to setup and run.

Stuck in a never ending cycle of file copying.

 

[mattKnight]

>There is no MySQL connector in VMPro

Then TBH, I'd suggest that you download a copy of SQL express (free) and install that! Once you have catured your data in that database, it will be easier to move to your mySQL db

Might be long winded, but it will work!

Take Care

Matt
I have always wished that my computer would be as easy to use as my telephone.
My wish has come true. I no longer know how to use my telephone.

 

[Draeus]

Thank you for the replies!

Sizbut, we were trying to get the data straight into a database where it seemed like campaigns just put it in your voicemail. At least that is what I got from what I read. Again, something I haven't had the opportunity to play with so far. But it looks like that is the way we are going with it since it is time sensitive and needed to be up and going last week.

Matt, I think now that I don't have the pressure to have this done yesterday, I'll get a copy of that and play around with it so I'm ready for next time.

Thanks again for the help!

Josh

 

[AACon]

Campaigns put it into a 'campaign database' that you can access via a web browser, or via a park slot. It's completely ridiculous and I loathe it. A real database would be the *best* option. Have you tried anything else, perhaps an accessdb just to verify it works?

We've had this working years ago with a mysql db running on redhat sitting on a P2 laptop. It was slow as beans, but it does work. I'm thinkin there is just something goofy with it.

-Austin
ACE: Implement IP Office

 

[Draeus]

AACon, we went with the campaign for now since it had to be up and running ASAP days ago. I agree, the database option would have been nicer. Now that I'm not under pressure to get it done, however, I can play around with connecting to other things until I get it figured out so I'm not fumbling around next time.