Error accessing CAR Database

Version 1
    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.