We help IT Professionals succeed at work.

Using a FoxPro DBF file from Novell Netware volume

s_arb
s_arb asked
on
Hi

  I want to connect to a DBF file whitch is located
in Netware 3.12 volume, through my ASP program.

Here:
StrConn= "Driver={Microsoft Visual FoxPro Driver};" & _
  "SourceType=DBF;" & _
  "SourceDB=" & "\\PAMCO-1\VOL1\DATA" & "\;" & _
  "Exclusive=No;"

but When i run ASP Programm this Error happens:
Microsoft OLE DB Provider for ODBC Driver(0x80040E21)
ODBC Driver does not support the requested properties.

Please Help me.
Comment
Watch Question

BRONZE EXPERT
Top Expert 2005

Commented:
I think that you may be running into a permissions issue. To troubleshoot, why don't you make a copy of the DBF file to a local drive and try the same connection string with a different path? The issue is that the IUSR and IWAM accounts need to have read/write permissions to the directory that houses the data. I have gotten around this issue in the past by mapping the folder as a drive on the hosting computer and then applying the necessary permissions that way.

Fritz the Blank

Commented:
go into the control panel and check if the foxpro driver exists in the ODBC tool.
If I remember right... there is tab called drivers when u expand the odbc data icon.
When you run your web pages, by default it runs as the user called IUSR_{yourservername}. Most probably
this user does not permission to use the VB dll you created. What you need to do is :

GO to windows explorer
R-Click on the DLL to go to properties
Click on Security tab
If you can see IUSR_{yourservrname} then click on him and give him full control
If you do not see that user click on ADD and find out the user called IUSR_{yourservername} and add
him and give him full control

and now try runnign your asp pages
Correction
this user does not permission to use the VB dll you created. What you need to do is :

should be
this user does not have permission to use dbf files. What you need to do is :


Also

R-Click on the DLL to go to properties

Should be
R-Click on the dbf file to go to properties
BRONZE EXPERT
Top Expert 2005

Commented:
jitganguly ,

I already pointed out the permissions issue. I would be reluctant to follow your advice giving full control to the IUSR account; it constitutes something of a security risk (do you really want to allow a hacker to delete the dbf file?). Read and write access should be fine.

Fritz the Blank
Sorry I did  not go through your suggestion properly. I just gave him a detailed description on how to do that.

Yes I do agree with you for the full permission issue. Though the users won't be able to do anything (unless they use fso to delete the file etc.), but r/w/x shoudl be fine

Author

Commented:
1- I don't have Foxpro ODBC Driver problem because
   when i copy DBF file in local drive it works.

2-About permission,When i use that file even in my home
directory on netware server i have the same problem.

Maybe the problem has been happened because of this:
My UID and Password for win2000 is "administrator","1"
(i 'm administrator there)
but for netware i have another uid and pass.(i'm a user there).
3-when i R-click on DBF File,Permission Tab doesn't appear,
Because the file is on Netware volume.

4-Maybe  i should define a IUSER_Win2kServer user for Netware with right permissions.
BRONZE EXPERT
Top Expert 2005
Commented:
I don't think it much matters what directory you store your file on the Novell server; you are still going to run into a persmissions issue. Try mapping the directory with the data to the server that hosts the web application. Then give IUSR Read/Write permissions to that mapped drive. I have done that before, and it works fine.

Fritz the Blank

Commented:
There is your problem.
IIS does not like mapped drives. you can not use mapped drives to access values. As MapPath will bomb or wont work with mapped drives.

So you will require to have the foxpro database on the local drives. unless us a DSN maybe

My 2 cents...
BRONZE EXPERT
Top Expert 2005

Commented:
Anuravi,

While it is a pain in the butt, I didn't use MapPath; I hard coded the path into the connection string. At least I put the creation of the connection object into a function and called as an include file for the rest of the pages to minimize maintainance headaches.

Fritz the Blank

Commented:
give a shot with DSN on the server?
BRONZE EXPERT
Top Expert 2005

Commented:
s arb,

Were any of these comments helpful? If so, please select one as an answer.

Fritz the Blank

Author

Commented:
Excuse me,i'm prety busy this days,I'm going to try
your answers.

Author

Commented:
Thank's for your help.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.