Проблема с подключением SQL на ASP Classic
После обновления cms на хостинге сайт стал выдавать ошибку:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/include/openDB.asp, line 9
Код файла opendb.asp:
<%
DIM DBSEC
Set DBSEC = Server.CreateObject("ADODB.Connection")
' DBSEC.ConnectionString = "Provider=SQLOLEDB.3;Persist Security Info=False;User ID=mkcltdr_sql2000;Initial Catalog=mkcltdr_mkc;Data Source=sql01.nthost.ru;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=GPSS2;Use Encryption for Data=False;Tag with column collation when possible=False;pwd=vfhbyf"
DBSEC.ConnectionString = "Provider=SQLOLEDB;User ID=mkcltdr_sql2000;Initial Catalog=mkcltdr_mkc;Data Source=192.162.101.169;Password=vfhbyf"
'DBSEC.ConnectionTimeout = 15
'DBSEC.CommandTimeout = 30
'DBSEC.CursorLocation = 3
DBSEC.Open
DIM DBRS
Set DBRS = Server.CreateObject("ADODB.Recordset")
function getCurrentConnection()
Set getCurrentConnection = DBSEC
end function
%>
Как решить данную проблему?