Problems accessing SQL Server

  • Thread starter Thread starter Dafydd Giddins
  • Start date Start date
D

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 ();
}
 
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/
 
Kumar Gaurav Khanna said:
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/
-------------------------------------------------------------------------- --
----------

Dafydd Giddins said:
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 ();
}
Click to expand...
Click to expand...

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