I'm trying to set up an old website on my local windows 10 machine!
I've setup IIS and added the classic ASP module and If I use non database ASP pages
it works fine. I've installed MySQL and setup ODBC with the proper driver and can access and test
the database fine!
Its when I try access the database via ASP that it fails! The code I'm using worked fine on the web server.
This is the code that gives the error!
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = "DSN=netcode;UID=peter;PSW=1234;" *** This is the line that fails ***
I've also modified the read/write permissions on the INETPUB folder and all subfolders to full control!
And have modifier the users to full control as well!