Information générale
Forum:
Microsoft SQL Server
Titre:
OpenRowSet, VFPOleDB, and Stored procedures
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement