Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ODBC Error connecting to DSN that points to resource on another machine on the network: [ODBC Visual Foxpro Driver]Cannot open file

Posted on 2006-11-20
4
Medium Priority
?
564 Views
Last Modified: 2008-02-20
I'm using IIS 6 on windows 2003 web edition (that is not in a domain), connecting to a foxpro database that is on a Windows 2003 std server (that is in a domain, but not a DC).   The php code that connects via odbc works fine as long as the database in question is local ( I copied to a local folder and tested on another DSN). As a test I moved the web edition server into the domain, and changed the anonymous user that the website is run as to a newly created user within the domain... this works, however the web server is intended to be internet facing and I would like to have it as separate from the network as possible and not have the machine in the local domain.

Anyone know of another way of fixing this or accomplishing the same goal?

Thanks.
0
Comment
Question by:techeez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 10

Expert Comment

by:AndresM
ID: 17986750
ASP or ASP.NET? The foxpro database is in a network share, right?
0
 
LVL 1

Author Comment

by:techeez
ID: 17988127
Php... The foxpro database is in a folder in an existing network share.
0
 
LVL 10

Accepted Solution

by:
AndresM earned 750 total points
ID: 17988289
Well, I'am not sure, but I think php impersonates by default. In that case, if your site is anonymous, by default it will run under IUSR_MACHINENAME account.

I think one option would be create a local user on the server that has the share, with same name (IUSR_MACHINENAME) and same password than the webserver's IUSR, and see what happens.

If php doesn't impersonate, the site will run under the context of the account configured in the IIS application pool, in this case, you should create this same account in the server that has the share.

This solution is not optimal. An optimal solution would be a database residing in for instance SQL Server, in this case SQL will listen on a TCP port, so you have several options to establish a connection.

Hope this helps.
0
 
LVL 1

Author Comment

by:techeez
ID: 17988776
Hi AndresM,

Thanks... The site is anonymous...I did add the IUSR_MACHINENAME account to the server that the database is coming from and it allowed me to connect... The problem with that is that I had to add the IIS server to the Domain in order to get that account to match. Now that I've said that... I didn't actually try it without moving the server into the domain first.  I'm going to try that now, I'll let you know how it works.

You are correct though, this isn't the optimal solution either way.  Unfortunately the main application that uses the databases that I'm trying to connect to in the first place is written in Visual Foxpro and would require a lot of work to use SQL in the backend :(
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I came across an interesting issue that had me pulling my hair out.  I was troubleshooting a new internal web site which uses integrated security instead of anonymous.  When browsing the site from my laptop, I was able to access it with no iss…
Logparser is the smartest tool I have ever used in parsing IIS log files and there are many interesting things I wanted to share with everyone one of the  real-world  scenario from my current project. Let's get started with  scenario - How do w…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question