-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Forgot to mention, that is what I currently do, but I forgot to in a Sproc I wrote yesterday = production problems. I skipped testing to get a fix in place, and ended up causing another problem. Anyway, I just wondered if I could set this at the connection level without having to remember to do so, since we ALWAYS want it off (except when we connect thru QA of course) for our application.
Ben Timby Webexcellence PH: 317.423.3548 x23 TF: 800.808.6332 x23 FX: 317.423.8735 [EMAIL PROTECTED] www.webexc.com - -----Original Message----- From: Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 9:04 AM To: ActiveServerPages Subject: Re: ADO + DB Options 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.unsub%% -----BEGIN PGP SIGNATURE----- Version: PGP 7.0.4 iQA/AwUBPUBC//nby1cCm2Q8EQKHJwCeLwBERld4Wct+fyihGR+RlIahkLUAoN2E qdM1clEc3b4dn1+aHTXqjla9 =XbyZ -----END PGP SIGNATURE----- --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
