Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Feb 2007
    Thanked 0 Times in 0 Posts

    Error in executing asp+mssql


    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.

    Last edited by diana13; 02-09-2007 at 12:15 PM.

  • #2
    Regular Coder
    Join Date
    Jan 2005
    Thanked 0 Times in 0 Posts
    in access for datefields you use the hash mark (#), in sql server, they need to be single quotes (')


    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts