Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OpenRowSet, VFPOleDB, and Stored procedures
Message
De
02/10/2008 14:12:18
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
OpenRowSet, VFPOleDB, and Stored procedures
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01352350
Message ID:
01352350
Vues:
134
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
Fil
Voir

Click here to load this message in the networking platform