s_arb
asked on
Using a FoxPro DBF file from Novell Netware volume
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.
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.
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.
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
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
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
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
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
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
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...
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...
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
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
give a shot with DSN on the server?
s arb,
Were any of these comments helpful? If so, please select one as an answer.
Fritz the Blank
Were any of these comments helpful? If so, please select one as an answer.
Fritz the Blank
ASKER
Excuse me,i'm prety busy this days,I'm going to try
your answers.
your answers.
ASKER
Thank's for your help.
Fritz the Blank