Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Cisco Access Registrar ODBC to MS-SQL

has anyone managed to use Microsoft SQL Server as ODBC for CNS CAR 4.X?

Currently we are using mysql for accounting, but we want to migrate. unfortunately cisco help only describes oracle and mysql.

http://www.cisco.com/en/US/docs/net_mgmt/access_registrar/4.2/user/guide/accountg.html

3 REPLIES
Silver

Re: Cisco Access Registrar ODBC to MS-SQL

Cisco AR 4.0 provides support for MySQL to query user records from a MySQL database and enables you to write accounting records into MySQL when using Oracle accounting. Cisco Access Registrar 4.0 has been tested with MySQL 4.0.18 and MyODBC 3.51.06 (reentrant). For the Cisco AR server to use MySQL, you must create and configure an ODBCDataSource object of type myodbc and a RemoteServer object set to protocol odbc.

New Member

Re: Cisco Access Registrar ODBC to MS-SQL

Has anyone managed to make it work with Microsoft SQl?

New Member

Re: Cisco Access Registrar ODBC to MS-SQL

I found that in order to connect from solaris or Linux to a Microsoft SQL Server you should use freetds (http://www.freetds.org/).

Anyone tried it?

162
Views
0
Helpful
3
Replies