I realise this question is asked several times previously but having looked at the guidance on the previous questions I still have no solution
A working classic ASP application was transferred to another server and is indeed in the IIS Manager (version 8.5.9600). The index.asp page works okay but when we select one of the two options they both provide a "500 - Internal server error". The sub pages are in the same folder. I set up the browser to give me more details which states the following
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
The two options on the main page interrogate Access databases and I have ensured Access is installed on the server and the Access files in the correct location
I found this may be related to System DSN to provide an ODBC to the Access database and in the asp file I found the following
<%
accessdb="files\retirals"
DSN = "DRIVER={Microsoft Access Driver (*.mdb)};"
DSN = DSN & "DBQ=" & Server.Mappath(accessdb)
Set DBConnection = Server.CreateObject("adodb.connection")
Set rs=Server.CreateObject("ADODB.RecordSet")
DBConnection.Open DSN
However, I am assured that NO System DSN was setup on the previous server (I am not able to access the previous server). What is slightly confusing is that the subcomponents uses different Access databases but each states the same DSN value of
DBConnection.Open DSN
I tried setting up one System DSN named "DSN" using the "Mcirosft Access Driver" but it still states "Data source name not found and no default driver specified". I also restarted the website in IIS afterwards. But this still does not help. How do I resolve this please?