Date problem in SQL server 1

[royyan]

I just migrate my database from Access to SQL server. My previous ASP code has problem in communicating with SQL database. Here is my SQL statement:
strSQL = ""
strSQL = strSQL & "select count(Page) as Count, max(Page) as Page1 from PAGEVIEW where "
strSQL = strSQL & "[Date] between #" & fromDate & "# and #" & toDate & "# "
strSQL = strSQL & &quot;and BookID = '&quot; & strBookID & &quot;' and TypeID <> 3 and TypeID <> 5 group by Page order by count(Page) desc, Page&quot;
The error message is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '#'.

Can anybody tell me what's wrong with my code.

Thanks!

 

[JuanitaC]

SQL Server uses a single quote for dates instead of the #. So just replace all the # with ' and it should work.