Unix Technical Forum

RADUIS LOGGING IN TO SQL WITH ACS ODBC

This is a discussion on RADUIS LOGGING IN TO SQL WITH ACS ODBC within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi there, I have a problem, I have a gateway that dose voip, I collect the radius accounting logs ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 07:14 PM
AnoushG
 
Posts: n/a
Default RADUIS LOGGING IN TO SQL WITH ACS ODBC

Hi there,
I have a problem,
I have a gateway that dose voip,
I collect the radius accounting logs with cisco secure in csv file.
I am even geting them by configuring an odbc drive to collecte them in
to a sql server.
everything work fine.
the only problem is that in eah colum I get the name of the colum. for
example. in the colum
"h323-disconnect-time"
I get this
"h323-disconnect-time=01:05:13.983 PARIS Sat Jul 5 2003 "

my question is that , in the colum
"h323-disconnect-time"
can we juste get
"01:05:13.983 PARIS Sat Jul 5 2003"
and not get
"h323-disconnect-time=01:05:13.983 PARIS Sat Jul 5 2003"

to resolve a bit this, I am doing extraction via sql argumet, and it
is working.
now I will have more traffic, and if i make sql work like this, he
will get crazy! and me too !

so dose any one have a solution for this ?


thx in advance


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:21 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com