ASP Connection

Hello,

I developed a ASP web application. I created connection to SQL Server 7 by
DSN at the begin, however, some experts said that DSN connection was not a
good choice. so I changed some of ASP pages to DSNless connection. But the
problem happens, I create DSNless connection on every page, now I have to
move to different computer with diffferent server name. All pages with
DSNless connection stop working unless I change data source to new server
name. This is huge job. Is there a way that I can put the code of connection
to somewhere and the connection will be created when people login, so I
don't have to change it page by page? I know VB and ASP.NET can do that.

Thanks in advance,

Wilton

Re: ASP Connection

Take the code for it out of each page, stick it in a new page called =
(for example) myconnection.asp and use the