Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OpenRowSet, VFPOleDB, and Stored procedures
Message
From
02/10/2008 14:12:18
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
OpenRowSet, VFPOleDB, and Stored procedures
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01352350
Message ID:
01352350
Views:
135
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
Map
View

Click here to load this message in the networking platform