Using MSSQL with MiaRec

Do you have any better documentation for the use of MS SQL 2000 with Mia? I do not compleye under stand if I am to be using a OBDC connection or a driect to SQL connection?

Pat

At the moment MiaRec Business supports following databases:

  • PostgreSQL
  • MySQL

MS SQL is not supported at the moment.

 

PostgreSQL database engine is built into MiaRec Business installer package.

No additional installation or configuration is necessary for it, while MySQL requires changes in configuration of MiaRec. Contact us by e-mail to request more information about MySQL DB support, if you are interested in this.

 

It is possible to access Call Detail Records (CDRs) from your own application.

Download ODBC driver from official PostgreSQL web-site (http://pgfoundry.org/projects/psqlodbc/) or use direct connector, if it is available for your programing language (http://pgfoundry.org/softwaremap/trove_list.php).

 

For security reasons, access to MiaRec database is protected with login and password. Contact us by e-mail to receive that password.

 

Also, access to database is permitted only from localhost. This means that your application should be installed on the same machine as MiaRec.

But this limitation is easy to remove just with editing of configuration files.