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:
9
>
>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