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

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