I have Wep Application , I have Connection Foxpro Database in ASP.NET(Visual Studio.NET) by OleDbDataAdapter Configuration Wizard , in Provider Wizard I Choose Microsotf OLE DB Provider For Visual Foxpro ,It Connect Success
But ,When I run Application I get Error Message "Invalid Path Or FileName"
I am copy file in drive I : to My Computer (drive C:\Inetpub\wwwroot\MyApplication), Web Application can run but,My Web Application want connect to FoxPro Database live in another computer because data must update every time ,When I copy file from mapping
drive (Drive I:) into Drive C: \Inetpub\wwwroot\MyApplication ,data can not update
He certainly must use UNC file path, however, that leaves the security issue. ASPNET user is a local user on the Web server. In order to access a remote file, you need to have ASP.NET running under the user account of a domain user with rights to both, or
alternately, create and maintain ASPNET users on both machines with the same password (and you will then need to manage the passwords manually). Moving the FoxPro data file to the Web server, and having all users point to that file, would be
much easier.
Make sure that the id you are using has rights to the location of the data. I ran into this problem with another post and although the code was correct the rights were not.
Nisarat
Member
150 Points
30 Posts
Connection Foxpro Database in ASP.NET
Apr 21, 2005 02:32 AM|LINK
Hi All
I have Wep Application , I have Connection Foxpro Database in ASP.NET(Visual Studio.NET) by OleDbDataAdapter Configuration Wizard , in Provider Wizard I Choose Microsotf OLE DB Provider For Visual Foxpro ,It Connect Success
But ,When I run Application I get Error Message "Invalid Path Or FileName"
Please Help me
Best Regard
Nisarat
nisarat-k@yusen.co.th
jshindl
Member
740 Points
146 Posts
Re: Connection Foxpro Database in ASP.NET
Apr 21, 2005 05:15 PM|LINK
Jason
Nisarat
Member
150 Points
30 Posts
Re: Connection Foxpro Database in ASP.NET
Apr 22, 2005 03:10 AM|LINK
Hi ! Jason
Nice to recieve your message
Connection String in wizard "Provider=VFPOLEDB.1;Data Source=I:\EDI\IMPORT;Mode=Share Deny None;Extended Properties="";User ID="";Password="";Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=THAI;DSN="""
FoxPro Database Live in Another Computer But,I have MapDrive Already It's Drive I:
How to use Web Server (IIS) can see Drive I:
Thanks
Nisarat
douglas.reil...
All-Star
23315 Points
4647 Posts
Re: Connection Foxpro Database in ASP.NET
Apr 22, 2005 03:22 AM|LINK
Your mapping a drive does not help IIS find the file, since the user context is not your user context, but the context of, generally, the ASPNET user.
Any chance you can have the data file on your Web server?
Programming Microsoft Web Forms
My Blog
Nisarat
Member
150 Points
30 Posts
Re: Connection Foxpro Database in ASP.NET
Apr 22, 2005 03:40 AM|LINK
Hi Douglas
Many Thanks for your answer
I am copy file in drive I : to My Computer (drive C:\Inetpub\wwwroot\MyApplication), Web Application can run but,My Web Application want connect to FoxPro Database live in another computer because data must update every time ,When I copy file from mapping drive (Drive I:) into Drive C: \Inetpub\wwwroot\MyApplication ,data can not update
How to context?
Thanks
Nisarat
jshindl
Member
740 Points
146 Posts
Re: Connection Foxpro Database in ASP.NET
Apr 22, 2005 12:33 PM|LINK
\\serverName\shareName\EDI\IMPORT
Jason
douglas.reil...
All-Star
23315 Points
4647 Posts
Re: Connection Foxpro Database in ASP.NET
Apr 22, 2005 12:54 PM|LINK
Programming Microsoft Web Forms
My Blog
Nisarat
Member
150 Points
30 Posts
Re: Connection Foxpro Database in ASP.NET
Apr 23, 2005 10:00 AM|LINK
Hi, Jason
Thank for your answer
I am using a UNC instead of the I:\ drive
New path
\\edi-export\edi-import\edi\import
but,I get same error message "invalid path or filename"
Thanks
Nisarat
blueguy
Member
5 Points
1 Post
Re: Connection Foxpro Database in ASP.NET
May 02, 2005 10:22 AM|LINK
Please give an idea how to get rid off this message
Is it possible?
dfranklyn
Member
160 Points
32 Posts
Re: Connection Foxpro Database in ASP.NET
May 04, 2005 07:42 PM|LINK
Hey,
Make sure that the id you are using has rights to the location of the data. I ran into this problem with another post and although the code was correct the rights were not.
Just a suggestion.
dfw