|
Home > Archive > IIS Server Security > January 2004 > Accessing Foxpro Table on server other than IIS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Accessing Foxpro Table on server other than IIS
|
|
| GeorgeO 2004-01-24, 1:57 am |
| Hi
I have two W2K member servers in an Active Directory domain. One runs IIS,
the other holds dbf files that are to be accessed by ASP scripts running on
iis. I am getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
I have read up on KB 175801 and done what it has said to no avail. Also the
KB article mentions an error 80040e14 and not 80040e37, so if anyone has any
information regarding this error please let me know. Also I don't want to
make the IIS machine a domain controller for other reasons. Has anyone been
able to get this working with exact configuration as I have mentioned?
Thanks in advance
George
| |
| Jeff Cochran 2004-01-24, 1:57 am |
| On Thu, 18 Dec 2003 17:24:31 +1100, "GeorgeO" <sorry@no.email.com>
wrote:
quote:
>I have two W2K member servers in an Active Directory domain. One runs IIS,
>the other holds dbf files that are to be accessed by ASP scripts running on
>iis. I am getting the following error:
>Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
It'd be nice to know the rest of the message, but basically it comes
down to ASP not being able to access what you told it to. See:
http://www.aspfaq.com/show.asp?id=2164
quote:
>I have read up on KB 175801 and done what it has said to no avail. Also the
>KB article mentions an error 80040e14 and not 80040e37, so if anyone has any
>information regarding this error please let me know. Also I don't want to
>make the IIS machine a domain controller for other reasons. Has anyone been
>able to get this working with exact configuration as I have mentioned?
Most likely it's permissions. The IUSR account on your web server
needs access to the Foxpro database. Remember the IUSR account is
local, so you'll need to deal with granting access for a non-domain
account on a server.
Jeff
| |
| GeorgeO 2004-01-24, 1:57 am |
| Server1 = IIS Server
Server2 = Foxpro Server
I had setup an equivalent account on Server2 (ie. IUSR_XWEB and IUSR_IWAM)
as the IIS web server local accounts. I had also assigned permissions
however to no avail. I think what is happening is that Server2 is only
allowing SERVER2\IUSR_XWEB to log on. WHen I try connect as just IUSR_XWEB
is fails. I also try Server1\IUSR_XWEB and that also fails. Any more ideas?
"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:3febd009.697187402@msnews.microsoft.com...quote:
> On Thu, 18 Dec 2003 17:24:31 +1100, "GeorgeO" <sorry@no.email.com>
> wrote:
>
IIS,[QUOTE][color=darkred]
on[QUOTE][color=darkred]
>
> It'd be nice to know the rest of the message, but basically it comes
> down to ASP not being able to access what you told it to. See:
>
> http://www.aspfaq.com/show.asp?id=2164
>
the[QUOTE][color=darkred]
any[QUOTE][color=darkred]
been[QUOTE][color=darkred]
>
> Most likely it's permissions. The IUSR account on your web server
> needs access to the Foxpro database. Remember the IUSR account is
> local, so you'll need to deal with granting access for a non-domain
> account on a server.
>
> Jeff
| |
| Jeff Cochran 2004-01-24, 1:57 am |
| On Fri, 19 Dec 2003 12:07:42 +1100, "GeorgeO" <sorry@no.email.com>
wrote:
quote:
>Server1 = IIS Server
>Server2 = Foxpro Server
>
>I had setup an equivalent account on Server2 (ie. IUSR_XWEB and IUSR_IWAM)
>as the IIS web server local accounts. I had also assigned permissions
>however to no avail. I think what is happening is that Server2 is only
>allowing SERVER2\IUSR_XWEB to log on. WHen I try connect as just IUSR_XWEB
>is fails. I also try Server1\IUSR_XWEB and that also fails. Any more ideas?
You mean like making your connection using the account that has access
on the server instead of the one you're running IIS on? 
I don't know if there is a remote provider for Foxpro the way there is
for Access and SQL, but that might be an option. You could also map a
drive to the remote machine, using a "connect as" account on that
remote machine, and use the drive letter in your Data Source.
Your likely problem with your existing method is you're allowing IIS
to control the password to the account. You need the same account and
the same password on each machine.
Jeff
quote:
>"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
>news:3febd009.697187402@msnews.microsoft.com...
>IIS,
>on
>the
>any
>been
>
| |
| GeorgeO 2004-01-24, 1:57 am |
| Thanks Jeff
I have setup identical accounts with pwds as well. I think the issue here is
that when creating a user account on a Standalone W2k Server, the account
logon name is SERVER\IUSR_XWEB instead of just IUSR_XWEB. Therefore, when
trying to connect using SERVER1\IUSR_XWEB to Server2, server2 rejects it as
it is only allowing SERVER2\IUSR_XWEB to connect. I have decided to promote
SERVER1 (Web server) to a domain controller which then holds an account that
both servers can see.
Thanks for you help
George
"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:3fea0d30.778378398@msnews.microsoft.com...quote:
> On Fri, 19 Dec 2003 12:07:42 +1100, "GeorgeO" <sorry@no.email.com>
> wrote:
>
IUSR_IWAM)[QUOTE][color=darkred]
IUSR_XWEB[QUOTE][color=darkred]
ideas?[QUOTE][color=darkred]
>
> You mean like making your connection using the account that has access
> on the server instead of the one you're running IIS on?
>
> I don't know if there is a remote provider for Foxpro the way there is
> for Access and SQL, but that might be an option. You could also map a
> drive to the remote machine, using a "connect as" account on that
> remote machine, and use the drive letter in your Data Source.
>
> Your likely problem with your existing method is you're allowing IIS
> to control the password to the account. You need the same account and
> the same password on each machine.
>
> Jeff
>
running[QUOTE][color=darkred]
Also[QUOTE][color=darkred]
has[QUOTE][color=darkred]
to[QUOTE][color=darkred]
>
|
|
|
|
|