my ASP data connection script is as folows:
Expand|Select|Wrap|Line Numbers
- if strServerName = "blackorchidinteriors.kdomain.local" or strServerName = "blackorchidinteriors-shop.kdomain.local" then
- global_strServer = "kpdc-1.kdomain.local"
- else
- global_strServer = "90538-APP1"
- end if
global_strServer is then used to build the connection:
Expand|Select|Wrap|Line Numbers
- global_strConnectionString = "Provider=SQLOLEDB;Server=" & global_strServer & ";database=**********;uid=*********;pwd=**********"
why does this connection script have two server locations and how do i expand these addresses for remote (desktop SQL manager) access ?
am i going about this in the best way ?
should i be uploading a ASP file to do this job ?