Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO Command & stored procedures
Message
De
24/06/2001 20:51:16
 
 
À
22/06/2001 23:58:03
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00522595
Message ID:
00522914
Vues:
8
>
>Does it work with other stored procedures?
>

Yes, it works with stored procedures in the database I am connected to. I am not explicitely connecting to the master database, so I guess that is the problem. I am able to run sp_pkeys (from inside VFP on client) without connecting to master database, but I have to .append the parameters (which I don't have to do with the stored procedures in the database I am connected to).

>
>I did test the utility with sp_pkeys and sp_help before I posted my previous reply on a W2K server with 2.6 and SQL7 SP3 installed. Are you connecting to the master database? I don't remember if I check the support for the .Refresh() method in the code, but not all backends support it. What version of SQL Server are you using?
>

Using SQL Server 7.

>
>Also, make sure it is not a permissions problem. Open up query analyzer and test it with the same user id as in your code.

Will do...thanks,
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform