General information
Forum:
Microsoft SQL Server
Title:
OpenRowSet, VFPOleDB, and Stored procedures
Environment versions
SQL Server:
SQL Server 2005
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only