Kalyan,



It is very unwise to make database connections for an internet web site (or

any other  come to that) in the global.asa. IIS provides a facility called

connection pooling which will not be used by global database connections.

Pooling allows database connections to be reused. To take advantage of

pooling, database connections need to be opened and closed on a page basis.

After a connection is closed within a page, the connection is actually

returned to the pool and hangs around waiting to be used again next time

someone uses the page. This is a very simplistic explanation of connection

pooling and I'd suggest further reading on the subject from

www.microsoft.com . It is of course ok to put your connection string in a

global variable and use that. Don't forget, connection pooling will need to

be enabled on your IIS. As for the NTFS file permissions, this needs to be

set/configured in IIS/NT and is not a setting of the asp connection object

or any other asp object.



Hope this helps



Simon Ryan

Xpert Web Solutions



 ----- Original Message -----



> Subject: Data Source Name not found.

> From: kalyan_ramji@h...

> Date: Mon, 30 Jul 2001 15:47:49

> X-Message-Number: 1

>

> Hi Folks,

>

> I installed the MDAC 2.6 and the Jet Service Pack and now I am able to use

> OLEDB to connect to the database. Thanks to all those who guided me in

> this process. The problem I face now is with global referencing. I try to

> create the connection in the global.asa file and call it in my other asp

> pages. But I get an error saying that the data source name not found or no

> default driver specified.

>

> I searched the microsoft site and found out that I need to change the file

> permissions for global.asa. This is the resolution microsoft gives..

>

> "To fix this behavior, change the NTFS permissions on the Global.asa file

> to give the Anonymous Logon account -- as defined in the "Internet Service

> Manager" -- Read (RX) permissions. For instructions on setting file

> permissions, see Windows NT Help. "

>

> I tried to do this but am not sure as to what they mean when they say

> change NTFS permissions to give Anonymous Logon account. I know what the

> ID is and all that stuff, but where do I give this info.?

>

> Thanks for all your help..