Query doesn't work after uploaded to Web Server

Query doesn't work after uploaded to Web Server

I'm having some problem with this query, it works on my localhost (IIS 6)
but when i uploaded the same code to web server (IIS/7.5) it returns no
data from the Database.
Here is the query:
Set RsTdL = Con.Execute("Select * From COURSE1 Where DUE_DATE Like
'"&Date&"%' and CLASS = '"&CCode&"' ORDER BY SUBJECT, LECT_NO, SUBTOPIC")
'" & Date & "%' matches the system date in the database so it'll show
current date record.
And in the DUE_DATE column the date is in this format 9/3/2013 3:42:03 PM
i don't know how to debug this query because its working on my local
machine and the WEB SERVER doesn't return any errors so im stuck ...
Please help,
thanks