none
Error# -2147217900, incorrect syntax near '*',

    Question

  • Moved database from SQL 2008R2 Standard edition to SQL 2012 Enterprise edition development Server before migration

    Started testing on databases moved to SQL 2012

    The databases are using front end application for both client and admin panel

    The application is connected using ODBC SQL Native client

    I get an error message during data process using front end application

    Error# -2147217900, incorrect syntax near '*',

    If I click “OK” I can still get to the right window and perform the functions.

    The database compatibility view on SQL 2008 R2 is “SQL Server 2000 (80)”

    The compatibility view “SQL Server 2000 (80)” on SQL Server 2012 Enterprise edition is not available.

    I found some forum links and they seems to be only for SQL 2005 and 2008

    http://blogs.technet.com/b/cliveeastwood/archive/2006/05/03/427140.aspx

    http://support.microsoft.com/kb/966146

    How I can troubleshoot and fix this problem


    Muhammad Mehdi

    Wednesday, October 16, 2013 11:28 PM

Answers

All replies