Search Again: Re: SQL Connection From: Terrell Patrick Date: Saturday, March 8, 2003 Time: 4:28:54 pm The error is below: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the nvarchar value '2003-02-14' to a column of data type int. I ran this Query: SELECT UserName,count(UserName),sum(AcctSessionTime),sum(AcctOutputOctets) FROM Accounting WHERE LogDate >= 2003/03/01 AND LogDate <= 2003/03/31 GROUP BY UserName 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:18 PM To: Optigold ISP List Subject: Re: [Optigold ISP] SQL Connection That's the same format as what's coming in here too. What happens if you run your query in the Enterprise Manager for SQL? Lewis ----- Original Message ----- From: "Terrell Patrick" <discussion@etully.com> To: "'Optigold ISP List'" <isp-list@optigold.com> Sent: Saturday, March 08, 2003 6:14 PM Subject: RE: [Optigold ISP] SQL Connection > The format is 2003-03-08. > > 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 7:07 PM > To: 'Optigold ISP List' > Subject: RE: [Optigold ISP] SQL Connection > > > 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 > --------------------------------------------------- > > > --------------------------------------------------- > 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 ---------------------------------------------------

Messages In This Thread: SQL Connection by Terrell Patrick on Mar 8, 2003 at 10:37:35 am Re: SQL Connection by Mike Bacher on Mar 8, 2003 at 2:05:30 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 2:11:50 pm Re: SQL Connection by Lewis Watson on Mar 8, 2003 at 2:23:52 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 2:47:41 pm Re: SQL Connection by Lewis Watson on Mar 8, 2003 at 2:57:30 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 3:09:39 pm Re: SQL Connection by Lewis Watson on Mar 8, 2003 at 3:16:01 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 3:46:54 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 3:55:12 pm Re: SQL Connection by Lewis Watson on Mar 8, 2003 at 4:00:36 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 4:07:52 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 4:14:49 pm Re: SQL Connection by Lewis Watson on Mar 8, 2003 at 4:19:21 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 4:28:54 pm Re: SQL Connection by Lewis Watson on Mar 8, 2003 at 4:49:08 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 4:57:57 pm Re: SQL Connection by Lewis Watson on Mar 8, 2003 at 5:08:23 pm Re: SQL Connection by Terrell Patrick on Mar 8, 2003 at 5:19:58 pm Re: SQL Connection by Lewis Watson on Mar 8, 2003 at 5:22:22 pm