java.sql.SQLException...Syntax error in FROM clause.

[Eytch]

I get the following message when I run my program, any suggestions why?

java.sql.SQLException[Microsoft][ODBC Microsoft Access Driver]Syntax error in FROM clause.

Thanks,

Eytch

 

[wangdong]

Where is yr SQL clause?

Chinese Java Faq Forum

http://www.4ugo.com/bbs/index.htm

 

[sedj]

How on earth do you expect us to point out the error in your SQL if you don't believe it ?!

The message pretty much says what it is - there is an error in your SQL near the FROM clause!

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[Diancecht]

I think there's an error in the FROM clause

Cheers,
Dian

 

[stefanwagner]

I agree.
It could be the FROM-clause of the sql.

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[tom62]

I also think that your SQL Statement has a syntax error in the FROM clause (lol). Sorry, but without posting the SQL statement there is nothing that we can do for you. After all we are not psygic.

Suggestions: SQLExceptions return an error code and a state code, that could help you to trace the problem. You could also try to execute the SQL statement in MS-Access yourself and hope that MS-Access provides you with a better problem report.

Good luck,

Tom