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

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.
LVL 1
techeezAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AndresMCommented:
ASP or ASP.NET? The foxpro database is in a network share, right?
techeezAuthor Commented:
Php... The foxpro database is in a folder in an existing network share.
AndresMCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
techeezAuthor Commented:
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 :(
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.