Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Command & stored procedures
Message
From
24/06/2001 20:51:16
 
 
To
22/06/2001 23:58:03
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00522595
Message ID:
00522914
Views:
7
>
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform