View Single Post
  #2 (permalink)  
Old 10-10-2008, 12:53 PM
ss7thirty ss7thirty is offline
VB.NET Forum Master
.NET Framework: .NET 2.0 (VS 2005)
 
Join Date: Jun 2005
Age: 24
Posts: 255
Reputation: 107
ss7thirty done a little coding in his/her timess7thirty done a little coding in his/her timess7thirty done a little coding in his/her time
Wink

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.
Reply With Quote