Cannot load data from database - error in simple small script

[#1]

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near '`'.

SQL

select `FirstName`, `LastName`

from `Person.Person`

where `FirstName` = 'Ken'

How do i make it work ?

SQL is -

select FirstName, LastName

from Person.Person

where FirstName = 'Ken'

[its_anandrjs]

Write and try like

select `FirstName`, `LastName` where `FirstName` = 'Ken';

from `Person.Person`

[#3 · Accepted solution]

Correct way is -

LOAD FirstName, LastName;

SQL SELECT FirstName, LastName

FROM AdventureWorks2008R2.Person.Person

WHERE FirstName = 'Ken';