Article ID: 166211 - View products that this article applies to.
This article was previously published under Q166211
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how to call system-stored procedures on SQL Server from RDO.
SQL Server has a number of prewritten, stored procedures that are used to configure and administer the SQL server. They are all located in the Master database and have the prefix [ASCII 147]sp_,[ASCII 148] which distinguishes them from user- or application-written stored procedures.
In order to call these stored procedures from RDO, you must specify the correct database in which they reside, the master database. There are several ways to do this, but the most effective way is to explicitly reference the stored procedure in your call syntax. For example:
Another method to accomplish this behavior is to set the default database before creating and executing your stored procedure. The following example uses a prepared statement and assumes that "Pubs" is your default database, cn is an active rdoConnection object, and qr is an rdoQuery object:
In Visual Basic Books Online, please see:
Guide to Building Client Server Applications in Visual Basic (Enterprise) Part 3: Data Access Options Using Remote Data Objects and the Remote Data Control Using RDO to Execute Stored Procedures
(c) Microsoft Corporation 1997, All Rights Reserved. Contributions by Jon Fowler, Microsoft Corporation