Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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
?
570 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 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Running classic asp applications under Windows Server 2008 R2 (x64) and IIS 7 is not as easy as one may think. It took me a while to figure it out while getting error 8002801d a few times. After you install the OS you will need to install the fol…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

580 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