General information
Category:
Automatización COM/DCOM y OLE
Miscellaneous
ID de la conversación:
00522595
>>
>>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,
SQL 7 does support the Refresh method. Do you have to use a command object? If not, use the connection's execute method like so:
oRS = oConn.Execute("sp_pkeys 'mytablename'")
I tested with this and it works as expected.
Previous
Next
Responder
Ver el mapa de esta conversación
View the map of this thread starting from this message only
Ver todos los mensajes de esta conversación
Ver todos los mensajes de esta conversaicón a partir del actual