connecting to a database in exclusive mode

[dendog]

hey all;
I have a two part question:

Part1:
When accessing a FoxPro database from a JSP that i wrote how do I express that I want the foxpro table files to be opened exlusively??? I am using the ODBC:JDBC bridge driver.

Part2:
The reason I am asking is because when i try to use the pack statement to physically remove deleted items in a table it throws an SQLException saying that the file must be opened exclusively. My second question is what would be the syntax to physically remove deleted records from a table named dowload_inv and a Statement named stmt using the pack command in a JSP.

Thank you very much for taking the time to answer my questions.

DENNIS

 

[Guest_imported]

hey MR Dennis,
I am also facing the same problem, I have learnt that pack command dosnt work on oDBC vfp driver does not support this.

If you get any more solution please let me know.

Srinivas Nayak

 

[jhall156]

I've never been able to get exclusive use of vfp tables using ODBC. I have been able to issue flock() and do other things but nothing that will give you the exclusive use of the file.
Have you considered using COM?
Depending on the version of vfp you're running, you can either wrap a vfp dll in vb or you could use script to pass parameters to an exe. JHall