Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
575
Views
0
Helpful
3
Replies

Cisco Access Registrar ODBC to MS-SQL

pavlosd
Level 2
Level 2

‎03-05-2009 07:11 AM

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

Labels:
0 Helpful
3 Replies 3

mchin345
Level 6
Level 6

‎03-11-2009 06:16 AM

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.

0 Helpful

pavlosd
Level 2
Level 2
In response to mchin345

‎03-16-2009 07:03 AM

Has anyone managed to make it work with Microsoft SQl?

0 Helpful

pavlosd
Level 2
Level 2
In response to pavlosd

‎03-23-2009 03:13 AM

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?

0 Helpful
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:

Customers Also Viewed These Support Documents