Daniel,
Sorry to point the obvious, but, do they have the file stored on their 'C:\SPCTesterSrc\SFH\ALS_Tension_Data' folder.
Anyway, the following statement always worked for me.
SELECT * FROM
Openrowset(
'MSDASQL',
'DSN=Visual FoxPro Database;SourceDB=c:\MyFolder ;SourceType=DBF',
'select * from MyDbfTable'
)
Cheers,
Zoran
>Hey all,
>
>I have a dbf that I'm trying to open using OpenRowSet in a stored procedure,
>with the following code.
>
>select * from openrowset ('VFPOLEDB.1', 'C:\SPCTesterSrc\SFH\ALS_Tension_Data\ALS_UNDER_TENSION_SENTINES_2008_09_26.DBF'; ' '; ' ','select * from [ALS_UNDER_TENSION_SENTINES_2008_09_26]')
>
>This works on my machine but cannot work on other machines, even though I've installed the vfpoledb.1
>on the other machines. Does anyone else have any other comments on the problem that I may have overlooked???
>One more note, I have VFP 9 on my machine, but the other machines do not have foxpro on them. Do I need to have the
>runtimes with the vfpoledb???
>
>Thanks mucho,
>Danno