cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
94
Views
0
Helpful
0
Comments
cdnadmin
Community Member
This document was generated from CDN thread

Created by: Chandar vr on 15-09-2009 11:21:09 AM
 
Hi I tried to access the tbl_billing_data from car database using soap api,
1
2$querymyva=$client->executeSQLQuery(array('sql'=>"select * from car:tbl_billing_data where duration > 100"));
3print_r ($querymyva);

But i am getting the following error  
 1
 2 faultstring] => No connect permission.    
 3 [faultcode] => SOAP-ENV:Client    
 4 [detail] => stdClass Object         (            
 5 [Error] => stdClass Object          
 6       (                   
 7  [code] => -387                   
 8  [message] => No connect permission.               
 9      [request] => executeSQLQuery              
10   )      
11   )

Please help me on this ...

Subject: RE: Error accessing CAR Database
Replied by: Jason P Holland on 02-11-2010 09:58:55 PM
Did you ever get a response on this?  I am having the same issue and would like to query that table.  Thanks
 
Jay

Subject: RE: Error accessing CAR Database
Replied by: Jason P Holland on 03-11-2010 02:12:52 AM
David thanks for the response.  How would one go about getting information from those tables?  For instance, I am trying to write a simple webpage that can query the CAR tables for calls placed to 911.  Is this even possible?  Thanks
 
Jay

Subject: RE: Error accessing CAR Database
Replied by: David Staudt on 02-11-2010 11:01:31 PM
The CAR database/tables are not accessible for direct application use via AXL.

Subject: RE: Error accessing CAR Database
Replied by: David Staudt on 05-11-2010 02:27:53 AM
As far as I know there isn't a way to get direct access to the CAR database at all.  
 
The official way to do something like you describe would be to configure an application to receive the UCM Call Detail Record files via FTP, then import the CDR files (csv format) into a database for querying.
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Quick Links