Problem using openrowset to query foxpro VFP 9 tables

Hi,

I have been trying to query VFP Foxpro table using following command.

Select * from OpenRowSet('VFPOLEDB','C:\ShareBridge\Dbf\WLK\Dbf\';'';'','SELECT * FROM SOM.DBF' ) as A

I have upgraded latest oledb driver for visual FoxPro 9 but, all the time it gives me following error message.

/**************************************************************

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "VFPOLEDB" for linked server "(null)" reported an error. Access denied.

Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider "VFPOLEDB" for linked server "(null)".

************************************************/

and after receiving above message i could not even open dbf file in FoxPro. it says File access denied

Can anyone help me solve this.

Thanks,

Kashyap

The account that the SQL Server service is running under probably doesn't any permissions to access the folder where the FoxPro file is located. Check what account your SQL Server service is running under and give it read/write access to the folder where the database is located.