I have a web page that is guarded with a simple login script. the username and login are stored in an access database of the server, and the script calls this through a DSN mapping. This worked great in Windows Server 2003 but I can't get it to work on 2008 64-bit even though I finally figured out how to run ODBC manager in 32-bit mode to add the access databse as a system DSN.
the script has a few different files to it. i have attached the file below that access the DSN and errors out.
Does anyone have a simple script that can do this on server 2008 64-bit?
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=tmlogindb"
' to prevent SQL and XSS Injection against your database and your site
' updated: January, 7th 2010
SQLString = Replace(SQLString, "'", "''") ' replace single Quotes with Double Quotes
SQLString = Replace(SQLString, ">", ">") ' replace > with >
SQLString = Replace(SQLString, "<", "<") ' replace < with <
SQLString = Replace(SQLString, "(","(") ' replace ( with (
SQLString = Replace(SQLString, ")",")") ' replace ) with )
SQLString = Trim(SQLString)
ProtectSQL = SQLString