Well you are executing a SQL command. Post the syntax of the command that is being and run and then I or someone else can tell you what is wrong with your SQL. That object is executing code on a database and there is an error in that syntax.
i.e. SELECT *a FROM syscolumns
produces the error message
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'a'.
The following is the correct syntax
SELECT * FROM syscolumns
It seems that the OleDb command parser is a bit more accurate and know that it is in your from clause. Make sure that the table exists, that your order by/ group by is valid, or that any joins that you may be performing use valid syntax.
|
10-10-2008, 12:53 PM
what does mean this Error: Syntax error in FROM clause
Linear Mode
