SQL Connection

Re: SQL Connection

From:

Date:

Time:

Lewis:

The LogDate and LogTime is a data type of nvarchar.

Thanks,
Terrell S Patrick
(561) 802-3171
www.etully.com

-----Original Message-----
From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf Of
Lewis Watson
Sent: Saturday, March 08, 2003 7:00 PM
To: Optigold ISP List
Subject: Re: [Optigold ISP] SQL Connection

Hi Terrell,
Yeah that looks pretty much like it should work. Now that its talking to
radius DB lets take a look at the accounting table. What is the format
and column types for LogDate and LogTime in SQL? Lewis

----- Original Message -----
From: "Terrell Patrick" <discussion@etully.com>
To: "'Optigold ISP List'" <isp-list@optigold.com>
Sent: Saturday, March 08, 2003 5:54 PM
Subject: RE: [Optigold ISP] SQL Connection

> Lewis:
>
> Here is my Get Monthly Usage SQL:
>
> SELECT
> UserName,count(UserName),sum(AcctSessionTime),sum(AcctOutputOctets)
> FROM Accounting WHERE LogDate >= <Y1>/<M1>/<D1> AND LogDate <=
> <Y2>/<M2>/<D2> GROUP BY UserName
>
> Here is my View Usage History SQL:
>
> SELECT Accounting.LogDate, Accounting.LogTime,
> Sum(Accounting.AcctSessionTime), Sum(Accounting.AcctOutputOctets),
> Accounting.FramedAddress, Accounting.CallingStationID,
> Accounting.AcctStatusType, Accounting.AcctTerminateCause FROM
> Accounting GROUP BY Accounting.LogDate, Accounting.LogTime,
> Accounting.FramedAddress, Accounting.CallingStationID,
> Accounting.AcctStatusType, Accounting.AcctTerminateCause,
> Accounting.UserName
> HAVING (((Accounting.UserName)='<Login>@etully.com'))
> ORDER BY Accounting.LogDate DESC , Accounting.LogTime DESC;
>
>
> Both of these SQL's worked with MS Access as the backend.
>
> Thanks,
> Terrell S Patrick
> (561) 802-3171
> www.etully.com
>
>
> -----Original Message-----
> From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf
> Of Terrell Patrick
> Sent: Saturday, March 08, 2003 6:46 PM
> To: 'Optigold ISP List'
> Subject: RE: [Optigold ISP] SQL Connection
>
>
> Lewis:
>
> I stand corrected. The SQL connection to the radius is working for
> addition of new users, modifying and deletion. I am sure during all
> the changes I was making trying things out, it started working. The
> usage information is still not working. At least I have narrowed down

> to that. Any ideas.
>
> Thanks,
> Terrell S Patrick
> (561) 802-3171
> www.etully.com
>
>
> -----Original Message-----
> From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf
> Of Lewis Watson
> Sent: Saturday, March 08, 2003 6:15 PM
> To: Optigold ISP List
> Subject: Re: [Optigold ISP] SQL Connection
>
>
> Whats the error when you try the DSN test?
> Lewis
>
>
> ----- Original Message -----
> From: "Terrell Patrick" <discussion@etully.com>
> To: "'Optigold ISP List'" <isp-list@optigold.com>
> Sent: Saturday, March 08, 2003 5:09 PM
> Subject: RE: [Optigold ISP] SQL Connection
>
>
> > Software to block a connection? Do you mean a firewall? The only
> > thing that is different between the IIS server and the workstation
> > is that the workstation is on a different subnet through a VPN
> > connection
>
> > to the FileMaker/Radius Server. The DSN is exactly the same.
> >
> > Thanks,
> > Terrell S Patrick
> > (561) 802-3171
> > www.etully.com
> >
> >
> > -----Original Message-----
> > From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf

> > Of Lewis Watson
> > Sent: Saturday, March 08, 2003 5:56 PM
> > To: Optigold ISP List
> > Subject: Re: [Optigold ISP] SQL Connection
> >
> >
> > Ok, I am just moving a few ideas out of the way here. Is there any
> > software running on the workstation that would block a connection to

> > the FM Database server? Is there any software on the DB server that
> > would block a connection from the workstation? Also, when you say
> > the same DSN do you mean that you have created an identical System
> > DSN on the workstation? if you have then double check the settings
> > for it as compared with the system DSN on the Web Server, especially

> > the Client Configuration button. Lewis
> >
> >
> > ----- Original Message -----
> > From: "Terrell Patrick" <discussion@etully.com>
> > To: "'Optigold ISP List'" <isp-list@optigold.com>
> > Sent: Saturday, March 08, 2003 4:46 PM
> > Subject: RE: [Optigold ISP] SQL Connection
> >
> >
> > > Lewis:
> > >
> > > We have two servers and one workstation in this equation,
> > >
> > > One Win2K server with Radius w/ SQL 2000 as the backend and
> > > FileMaker server. One Win2k server with IIS and FileMaker
> > > Unlimited.
> > >
> > > One Win2k workstation.
> > >
> > > The Workstation has a system DSN that connects and test just fine.

> > > The
> >
> > > IIS server has a system DSN that connects and test just fine that
> > > we
>
> > > also used for .asp pages to pull info from the Radius server. The
> > > Radius server of course has a system DSN that works.
> > >
> > > I use the same DSN from the workstation to try and connect to SQL
> > > server with no luck.
> > >
> > > Thanks,
> > > Terrell S Patrick
> > > (561) 802-3171
> > > www.etully.com
> > >
> > >
> > > -----Original Message-----
> > > From: isp-list@optigold.com [mailto:isp-list@optigold.com] On
> > > Behalf
>
> > > Of Lewis Watson
> > > Sent: Saturday, March 08, 2003 5:23 PM
> > > To: Optigold ISP List
> > > Subject: Re: [Optigold ISP] SQL Connection
> > >
> > >
> > > Hi Terrell,
> > > So if I understand correctly Radius, SQL and Optigold are all on
> > > this machine?
> > >
> > > I am guessing that you have an odbc connection that tests
> > > successfully
> >
> > > that you use to connect from Radius to SQL. Is it a system DSN?
> > > Double
> >
> > > check this and let me know... Lewis
> > >
> > >
> > > ----- Original Message -----
> > > From: "Terrell Patrick" <discussion@etully.com>
> > > To: "'Optigold ISP List'" <isp-list@optigold.com>
> > > Sent: Saturday, March 08, 2003 12:36 PM
> > > Subject: [Optigold ISP] SQL Connection
> > >
> > >
> > > > OK, Here we go again. Here is my scenario, can some please
tell
> > how
> > > > stupid I am and point out the simple fix.
> > > >
> > > > Radius Server with SQL 2000 Backend. This server also has the
> > > > FileMaker Server on it too.
> > > >
> > > > I can connect to the SQL server with the radius, of course. I
> > > > can
>
> > > > connect to the SQL server database with .asp pages from The
> > > > Windows 2000 IIS server.
> > > >
> > > > BUT, I can no connect to the Radius server with OptiGold with
> > > > the same
> > >
> > > > SQL server login as I have used with everything else. This
> > > > problem is
> > >
> > > > keeping me from running SQL server events for adding, deleting
> > > > and
>
> > > > changing users info in the database for Radius and also pulling
> > > > usage information.
> > > >
> > > > Please help me. Lewis are you out there?
> > > >
> > > > Thanks,
> > > > Terrell S Patrick
> > > > (561) 802-3171
> > > > www.etully.com
> > > >
> > > >
> > > > ---------------------------------------------------
> > > > To subscribe, unsubscribe or to search list archive please visit

> > > > http://www.optigold.com/lists/isp.html
> > > > ---------------------------------------------------
> > > >
> > >
> > >
> > > ---------------------------------------------------
> > > To subscribe, unsubscribe or to search list archive please visit
> > > http://www.optigold.com/lists/isp.html
> > > ---------------------------------------------------
> > >
> > >
> > > ---------------------------------------------------
> > > To subscribe, unsubscribe or to search list archive please visit
> > > http://www.optigold.com/lists/isp.html
> > > ---------------------------------------------------
> >
> >
> > ---------------------------------------------------
> > To subscribe, unsubscribe or to search list archive
> > please visit http://www.optigold.com/lists/isp.html
> > ---------------------------------------------------
> >
> >
> > ---------------------------------------------------
> > To subscribe, unsubscribe or to search list archive
> > please visit http://www.optigold.com/lists/isp.html
> > ---------------------------------------------------
> >
>
>
> ---------------------------------------------------
> To subscribe, unsubscribe or to search list archive
> please visit http://www.optigold.com/lists/isp.html
> ---------------------------------------------------
>
>
> ---------------------------------------------------
> To subscribe, unsubscribe or to search list archive
> please visit http://www.optigold.com/lists/isp.html
> ---------------------------------------------------
>
>
> ---------------------------------------------------
> To subscribe, unsubscribe or to search list archive
> please visit http://www.optigold.com/lists/isp.html
> ---------------------------------------------------
>

---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------

---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------

Sales:
888/4-DPOINT

Support:
858/452-3696