|
|
You're in the
iis security
group:Accessing Foxpro Table on server other than IIS
iis security:
[quoted text, click to view] wrote: >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 [quoted text, click to view] >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.
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
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? [quoted text, click to view] "Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message news:3febd009.697187402@msnews.microsoft.com... > On Thu, 18 Dec 2003 17:24:31 +1100, "GeorgeO" <sorry@no.email.com> > wrote: > > >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 > > >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
On Fri, 19 Dec 2003 12:07:42 +1100, "GeorgeO" <sorry@no.email.com>
[quoted text, click to view] wrote: >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 [quoted text, click to view] >"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
>news:3febd009.697187402@msnews.microsoft.com... >> On Thu, 18 Dec 2003 17:24:31 +1100, "GeorgeO" <sorry@no.email.com> >> wrote: >> >> >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 >> >> >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 >
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 [quoted text, click to view] "Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message news:3fea0d30.778378398@msnews.microsoft.com... > On Fri, 19 Dec 2003 12:07:42 +1100, "GeorgeO" <sorry@no.email.com> > wrote: > > >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 > > >"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message > >news:3febd009.697187402@msnews.microsoft.com... > >> On Thu, 18 Dec 2003 17:24:31 +1100, "GeorgeO" <sorry@no.email.com> > >> wrote: > >> > >> >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 > >> > >> >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 > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |