View Full Version : Error in executing asp+mssql

02-09-2007, 10:38 AM

I hope this forum is suitable for posting my question.

I have a site in asp and vb with an access database. It's work just fine. I want to convert my database from access to mssql express. So I convert it with Microsoft SQL Server Migration Assistant for Access. I also install mssql server on my computer, so I can test my site at home.
But now, I have trouble, I've received many errors like:

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#'.
(this appear when I try to insert date and time in database, witch in access database I have no problem)

ODBC driver does not support the requested properties
(this appears when I make a selection in database, where I use inner join).

And many more ...

Do I have to rewrite the code to all my files? It's so different working with MSSQL comparing with Access database?

From what I read, I understand that after converting the database from Access to MSSQL, I must change only the connection string and the site have no problem. But it seems it's not so easy. I'm pretty disappointed.

Can you give me an advice? Or some links where I can read something that can help me.


02-09-2007, 03:57 PM
in access for datefields you use the hash mark (#), in sql server, they need to be single quotes (')