SQL Connection

Re: SQL Connection

From:

Date:

Time:

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

Sales:
888/4-DPOINT

Support:
858/452-3696