SQL Connection

Re: SQL Connection

From:

Date:

Time:

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
---------------------------------------------------

Sales:
888/4-DPOINT

Support:
858/452-3696