Last post Aug 31, 2012 08:59 AM by Careed
Aug 27, 2012 08:48 PM|hshah27|LINK
New to forums. I have made a small asp.net app that uses vfp as a database with oledb connection UNC path, works fine on local computer. But at workplace we not have computers on a domain those are on workgroup. Shared data folder via UNC path. Is
there a way to impersonate workgroup instead of domain name? (Example: identity impersonate="true" userName="domain\user" password="xxx"). (Server: Win Server 2008, Client: WinXP)
Aug 27, 2012 09:53 PM|Careed|LINK
Do you have the VFPOLEDB provider installed on the individual machines?
Aug 27, 2012 09:57 PM|hshah27|LINK
Aug 27, 2012 10:15 PM|Careed|LINK
So the issue is that the user must log in to access the VFP database as it is located on the network.
This is, however, a web application, so you should be able to associate the ASP.NET user (Network Service for most current machines) to the database. so your login would come from that.
Also, I should have asked that the provider is installed on the web server.
Aug 27, 2012 10:38 PM|hshah27|LINK
VFPOLEDB is also installed on web server. Client machine has a windows login and uses UNC path of server's shared folder login info to access vfp db. i tried with server's shared folder login ("identity impersonate="true" userName="admin" password="admin123")
but didnt work. I also tried windows login but no luck. Do i have to created asp.net user on server or something? Which login info should i try?
Aug 28, 2012 01:28 AM|Ajay2707|LINK
Aug 28, 2012 09:39 AM|Careed|LINK
In general, if the VFP database is on the same server as your website, then there should be no issues. I'm guessing that you have the VFP database on another server. In this case, the two servers need to have trusted relationship between them. With this
trust, there should be no issues with a login.
Access to the database is from the web application, not the client. This is a web app, yes?
Aug 28, 2012 11:16 PM|hshah27|LINK
When i try on IIS on web server it works well I also tried running on local intranet no problem. But i still get error of "VFPOLEDB provider is not register on the local machine" when i try to access it from web host. And yes it is a web app. Thanks for
Aug 28, 2012 11:44 PM|Careed|LINK
Is the web server a 64-bit machine? If so, you need to make sure that the web application compiles to the x86 platform.
Aug 28, 2012 11:46 PM|hshah27|LINK
Its a 32-bit Windows server 2008.
Aug 31, 2012 08:59 AM|Careed|LINK
Try uninstalling the VFP OLE DB provider and reinstalling from scratch on the web server. You might try using a test app on the server to test it first directly from the web server (if you have direct access, that is).