ADOCommand

From: rahavard (Info_at_IRahavard.com)
Date: 01/18/04

Next message: JohnC: "Help: EMS QuickExport 3.0 - TADO_QExport3Dialog"
Previous message: Guillem: "Re: E_FAIL with TADOTable"
Next in thread: Mike Collier: "Re: ADOCommand"
Reply: Mike Collier: "Re: ADOCommand"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Sun, 18 Jan 2004 08:46:13 +0330

I use TADOCommand object to execute a expression such below but error
occurred.
Exec [My-Server].MyDB.dbo.MyProc :@Parm Output
My-Server is a sql server 2000 server.
MyDB is my active database.
MyProc is a storedprocedure that have an output parameter.

Next message: JohnC: "Help: EMS QuickExport 3.0 - TADO_QExport3Dialog"
Previous message: Guillem: "Re: E_FAIL with TADOTable"
Next in thread: Mike Collier: "Re: ADOCommand"
Reply: Mike Collier: "Re: ADOCommand"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

Re: Which is best performace wise in a stored proc - dynamic sql or big case statement ?
... > CREATE MyProc @iVar INT AS ... I expect there might be because I can't see how SQL Server can do ... > anything other than re-compile @sSQL everytime it runs. ...
(microsoft.public.sqlserver.server)
Re: transfer user login name and pswd to a new server?
... You need to understand what logins and users are in SQL Server and the difference. ... backup MASTER db and MyDB on the old server, ... Restore MyDB db from the backup too. ...
(microsoft.public.sqlserver.server)
Re: Grant Win Acct Permission
... I want this type of effect but can't get the syntax correct: ... USE MyDB ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Which is best performace wise in a stored proc - dynamic sql or big case statement ?
... Wayne Snyder, MCDBA, SQL Server MVP ... > CREATE MyProc @iVar INT AS ... > DECLARE @sSQL NVARCHAR ...
(microsoft.public.sqlserver.server)
Re: transfer user login name and pswd to a new server?
... > How to troubleshoot orphan users in SQL Server databases ... backup MASTER db and MyDB on the old server, ... Restore MyDB db from the backup too. ... I can see all the logins are in MASTER db, and MyDB now, ...
(microsoft.public.sqlserver.server)