>
>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.
I don't need to use the command object for this stored procedure, so I will do that. I do want to use command object for the stored procedures in the database, and I was not having a problem with those, until....
Changing to the OLEDB provider broke my code.
when I:
ors = oCmd.execute
if !ors.eof()
I am getting an error saying that the recordSet must be open to perform this command. Switching back to my old connect string allows the code to function again. I need to trace through errors, etc., to track this down...
Thanks again for the help...
Steve Gibson