Referencing a web.config SQL connection in classic asp...Can it be done?
Posted on 2008-10-16
I want to get rid of all the Connection.asp files on the server, and was wondering if I can use the setting in the web.config file on my server used by the aspx pages for this purpose....
<add name="Connect" connectionString="Provider=SQLNCLI; Server=servername ; Database=dbname;Uid=auser;Pwd=pass;"/>
to replace this in the asp files...
'This is the link to the client's database, change accordingly
'replace ??? with the client's subdomain below
'replace ??? with the client's folder , the register folder should be placed in the client's folder