Error in from clause

[Roel Van den Brande]

Hello

I try to fill a dataset. This is my code

string myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
source= C:\\Inetpub\\wwwroot\\Notenhof\\data\\notenhof.mdb;";
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
myConnection.Open();

DataSet ds = new DataSet();
OleDbDataAdapter dtad = new OleDbDataAdapter("SELECT * FROM
user",myConnection);
dtad.Fill(ds);

When I execute: dtad.Fill(ds); I get the following error:

System.Data.OleDb.OleDbException: Syntax error in FROM clause.

This is very strange because user is a valid table...

Thx for helping me
Roel

 

[Martin Dechev]

Hi, Roel Van den Brande,

You should escape the tablename because it is a reserved word:

"SELECT * FROM [user]"

Greetings
Martin

 

[Roel Van den Brande]

You solved my problem !
Thank you very much...

Regards
Roel

Hi, Roel Van den Brande,

You should escape the tablename because it is a reserved word:

"SELECT * FROM [user]"

Greetings
Martin

Hello

I try to fill a dataset. This is my code

string myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
source= C:\\Inetpub\\wwwroot\\Notenhof\\data\\notenhof.mdb;";
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
myConnection.Open();

DataSet ds = new DataSet();
OleDbDataAdapter dtad = new OleDbDataAdapter("SELECT * FROM
user",myConnection);
dtad.Fill(ds);

When I execute: dtad.Fill(ds); I get the following error:

System.Data.OleDb.OleDbException: Syntax error in FROM clause.

This is very strange because user is a valid table...

Thx for helping me
Roel