The original have a plenty of SQL server 2008 migrated to new SQL server 2012, IP address changes,
The web connection characters as follows:
Dim dbname="DRIVER=SQL Server; SERVER=192.168.1.10; The DATABASE=test; Address=192.168.1.10, 1433; User Id=test; PASSWORD=123456;"
DIM sim=server. Createobject (" adodb. You ")
DIM the rs=server. Createobject (" adodb. Connection ")
Rs. The open (dbname)
Results change IP address 192.168.1.10 to the new server IP 192.168.1.11, web page was submitted to the following error message
The resource you are & The for has had been removed, had its name changed, or is temporarily unavailable
Moved to the new SQL server database test has been completed and tested username test have also been able to connect, don't know where the problem is,
CodePudding user response:
Please check the web. Config file exists.CodePudding user response:
There may be other parts of the IP is not correct