dbuse
Uses a particular database.
Syntax
RETCODE dbuse (
PDBPROCESS dbproc,
LPCSTR dbname );
Arguments
dbproc
Is the DBPROCESS structure that is the handle for a particular workstation or Microsoft® SQL Server™ 2000 process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.
dbname
Is a character pointer to a null-terminated string specifying the database name.
Returns
SUCCEED or FAIL.
Remarks
This function executes a Transact-SQL USE statement for the specified database for a particular DBPROCESS structure. It sets up the statement and calls dbsqlexec and dbresults.
If the USE statement fails because the requested database has not yet completed a recovery process, dbuse continues to send USE statements at 1-second intervals until it either succeeds or encounters some other error.
The function uses the dbproc provided by the caller and its command buffer. Any existing statements in the buffer are lost, and the command buffer is cleared by dbuse when it is finished.