ERROR [42000] [Microsoft] [ODBC SQL Server Driver] [SQL Server] Incorrect syntax near '.'

0
votes

ERROR [42000] [Microsoft] [ODBC SQL Server Driver] [SQL Server] Incorrect syntax near '.'.

1
sql-serverodbc

1 Answers

0
votes

Issue is caused by incompatibility issue of SQL Server. Run the query below to set it to at least 90(SQL Server 2005)

ALTER DATABASE eportalv2 SET COMPATIBILITY_LEVEL = 90;