Dear All

1.
Is it OK if I post my questionaire this way? If not please send me the page 
URL from where I should post it.

2.
I realised yesterday that I got affected by nimda virus after a certain time 
in my asp codes a javascript staement is getting added. How do I correct it? 
And what steps should i take to prevent any such worms.

3.
Is it advisable to keep my connection String i.e

Dim objConn, objRS
  Set objConn = Server.CreateObject("ADODB.Connection")

  objConn.Open  "DSN=strutdata;User ID=sa"

in my application on start of global.asa file.

Needed help please...

Thanks
Sohini

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "sohini sengupta" <rumni_sg@h...>
Subject: Got affected by NImda virus - what to do?


: Dear All
:
: 1.Is it OK if I post my questionaire this way? If not please send me the
page
: URL from where I should post it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Please do not post questions directly to me.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: 2. I realised yesterday that I got affected by nimda virus after a certain
time
: in my asp codes a javascript staement is getting added. How do I correct
it?
: And what steps should i take to prevent any such worms.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Patch your server. Run up-to-date antivirus software:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/
current.asp


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: 3. : Is it advisable to keep my connection String i.e
:
: Dim objConn, objRS
:   Set objConn = Server.CreateObject("ADODB.Connection")
:
:   objConn.Open  "DSN=strutdata;User ID=sa"
:
: in my application on start of global.asa file.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

No, this means that *all* users will be using the same connection for all
database access. If you get many visitors each person will have to wait for
everyone else to finish before they can access the database.

Instead, you should instantiate a connection object, and destory it on every
page that requires database access. Connection pooling will take care of
everything else under the scenes:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html
/pooling2.asp

Cheers
Ken

Thanks Ken



>From: "Ken Schaefer" <ken@a...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Re: Got affected by NImda virus - what to do?
>Date: Fri, 10 May 2002 11:49:57 +1000
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "sohini sengupta" <rumni_sg@h...>
>Subject: Got affected by NImda virus - what to do?
>
>
>: Dear All
>:
>: 1.Is it OK if I post my questionaire this way? If not please send me the
>page
>: URL from where I should post it.
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>Please do not post questions directly to me.
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>: 2. I realised yesterday that I got affected by nimda virus after a 
>certain
>time
>: in my asp codes a javascript staement is getting added. How do I correct
>it?
>: And what steps should i take to prevent any such worms.
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>Patch your server. Run up-to-date antivirus software:
>http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/
>current.asp
>
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>: 3. : Is it advisable to keep my connection String i.e
>:
>: Dim objConn, objRS
>:   Set objConn = Server.CreateObject("ADODB.Connection")
>:
>:   objConn.Open  "DSN=strutdata;User ID=sa"
>:
>: in my application on start of global.asa file.
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>No, this means that *all* users will be using the same connection for all
>database access. If you get many visitors each person will have to wait for
>everyone else to finish before they can access the database.
>
>Instead, you should instantiate a connection object, and destory it on 
>every
>page that requires database access. Connection pooling will take care of
>everything else under the scenes:
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html
>/pooling2.asp
>
>Cheers
>Ken
>
>




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx