Search Again: Re: SQL Connection From: Terrell Patrick Date: Saturday, March 8, 2003 Time: 2:47:41 pm 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 ---------------------------------------------------

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