Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
Okay this is getting old.
If I use the method listed before to try and query from Excel 2007 I get an error that the "Database or Object is read-only" if I run from inside our app. If I run from command window or stand alone prg it works.
So I took the code at the link and created an ADODB.Connection and ADODB.Recordset object. When I run them from the command window or a stand alone prg with just this code it works fine. If I run it from inside our application as a function call I get "Could not find instalIable ISAM" or an OLEDispatch error.
So it is our app environment. I was reading that in Sql Server you can have problems if you do not SET NOCOUNT in the Sql Server code before trying this. Is there a similar SET command in VFP I need to set? We set dozens of "SET" commands through out our app so I thought I'd ask before tracing each and every one.
Précédent
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