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
549 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
  • 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 250 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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…
If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

790 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