Problems accessing SQL Server

[Dafydd Giddins]

Hi

I set up a new instance of SQL Server using the developer
edition CD and set up a datbase called AMA, table called
user with two fields called userid (the primary key) and
username (a string). Wheni run the code i get the
following error message

Incorrect Syntax near the keyword 'user'.

What am i missing?
Regards

Dafydd

Code is below


SqlConnection conn = new
SqlConnection
("server=localhost;database=AMA;uid=sa;pwd=password");
try
{
conn.Open ();
SqlCommand cmd = new
SqlCommand ("select * from user", conn);
SqlDataReader reader =
cmd.ExecuteReader ();
while (reader.Read ())
Console.WriteLine
(reader["username"]);
}
catch (SqlException ex)
{
Console.WriteLine
("Error:" + ex.Message);
}
finally
{
conn.Close ();
}

 

[Kumar Gaurav Khanna [.NET MVP]]

Hi!

"User" is a keyword of the SQL Server T-SQL. Have a look at this link:

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ra-rz_9oj7.asp?frame=true

You will need to change the name of your table.

Regards,
Kumar Gaurav Khanna

--
----------------------------------------------------------------------------
----------
Microsoft MVP - .NET, MCSE Windows 2000/NT4, MCP+I
WinToolZone - Spelunking Microsoft Technologies
http://www.wintoolzone.com/
OpSupport - Spelunking Rotor
http://opsupport.sscli.net/

 

[Martin Dew]

Hi!

"User" is a keyword of the SQL Server T-SQL. Have a look at this link:

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ra-rz_9oj7.asp?frame=true

You will need to change the name of your table.

Regards,
Kumar Gaurav Khanna

--
-------------------------------------------------------------------------- --
----------
Microsoft MVP - .NET, MCSE Windows 2000/NT4, MCP+I
WinToolZone - Spelunking Microsoft Technologies
http://www.wintoolzone.com/
OpSupport - Spelunking Rotor
http://opsupport.sscli.net/
-------------------------------------------------------------------------- --
----------

Hi

I set up a new instance of SQL Server using the developer
edition CD and set up a datbase called AMA, table called
user with two fields called userid (the primary key) and
username (a string). Wheni run the code i get the
following error message

Incorrect Syntax near the keyword 'user'.

What am i missing?
Regards

Dafydd

Code is below


SqlConnection conn = new
SqlConnection
("server=localhost;database=AMA;uid=sa;pwd=password");
try
{
conn.Open ();
SqlCommand cmd = new
SqlCommand ("select * from user", conn);
SqlDataReader reader =
cmd.ExecuteReader ();
while (reader.Read ())
Console.WriteLine
(reader["username"]);
}
catch (SqlException ex)
{
Console.WriteLine
("Error:" + ex.Message);
}
finally
{
conn.Close ();
}

or use the [user] syntax when dealing with objects that are named using
reserved words.