hey Ben If you used stored procs can't you simply prefix/suffix your procs with the db directives like the (MSSQL) example below?
CREATE PROC gp_MyProc AS BEGIN set nocount on select key, name from Table -- set nocount off -- I don't usually include this last line... END hth ----- Original Message ----- From: "Ben Timby" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, July 26, 2002 3:42 AM Subject: ADO + DB Options : : -----BEGIN PGP SIGNED MESSAGE----- : Hash: SHA1 : : Does anyone know if it is possible to set User Options in a DB : connection string, or by using the ADO objects, or in the connection : string? I need to turn nocount on, but I don't necessarily want to : change the DB options, or the server options. I just want it turned : off for my application. : : Any suggestions would be appreciated. : : Ben Timby : Webexcellence : PH: 317.423.3548 x23 : TF: 800.808.6332 x23 : FX: 317.423.8735 : [EMAIL PROTECTED] : www.webexc.com : : -----BEGIN PGP SIGNATURE----- : Version: PGP 7.0.4 : : iQA/AwUBPUA4fPnby1cCm2Q8EQIXgwCdE5CucN6G1WFESWh43pGB02edPTQAnisM : tP6SsoSsQtuH8rzuz+ORjqXk : =dSb7 : -----END PGP SIGNATURE----- : : : : --- : You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] : To unsubscribe send a blank email to %%email.unsub%% : --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
