Hello guys, i got a problem, in my old Windows 2003 Server, my asp file works fine, but now on my new Windows 2008 64 bits don´t work, i migrate 40 domains, all without problem, but i got problem on two, the problem appearts to be on the ADODB.Connection, the error is this.
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'paideia'.
/sistemas/seth/classes.asp, line 125
the line 125 is:
SET connTEMP = Server.CreateObject("ADODB.connection")
connTEMP.Open session("DSNCliente")
sqlTEMP = "select STcodMenuRel from STMenus where STCodMenu="& codigo
if STCodMenuTemp <> "" then
sqlTEMP = sqlTEMP & " and STCodMenu <> "& STCodMenuTemp
end if
sqlTEMP = sqlTEMP & " order by STMenuOrd"
in the windows 2003 works, but on 2008 don´t, what could be, what i need to do or change on my asp code?
Thanks
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'paideia'.
/sistemas/seth/classes.asp, line 125
the line 125 is:
SET connTEMP = Server.CreateObject("ADODB.connection")
connTEMP.Open session("DSNCliente")
sqlTEMP = "select STcodMenuRel from STMenus where STCodMenu="& codigo
if STCodMenuTemp <> "" then
sqlTEMP = sqlTEMP & " and STCodMenu <> "& STCodMenuTemp
end if
sqlTEMP = sqlTEMP & " order by STMenuOrd"
in the windows 2003 works, but on 2008 don´t, what could be, what i need to do or change on my asp code?
Thanks