Newbie needing help with joining 2 fields

I have a sql 2005 dev ed running an application developed in vs.net 2005 C# I have several gridviews which have a field call first name and a field called lastname I need to put both the firstname and lastname in the same cell or colum row. I do not now how to join these. Can some one help me with a SQL query string that will do this for me.You could do SELECT FirstName + ' ' + LastName FROM YourTable|||SELECT FirstName + ' ' + LastName AS FullName
FROM Employees

Newbie help: SQL Server does not exist or access denied

I have created a simple ASP page, but when I call it up, I receive the following error:
SQL Server does not exist or access denied
I am using SQL Server 2000 and Win2K. Any idea what may be causing this error?What are you supplying for your connection string?

1) SQL Server name
2) Username
3) Password
4) Database

If you use a trusted connection remember that the ASP page will connect to SQL Server as the user account that IIS is running under.|||Hi,

I am getting the same error message:

"SQL Server does not exist or access denied"

when I attempt to register a SQL Server in SQL Server 2000.

Any ideas?

Thanks,

Chris|||'csf' can you ping the server from your workstation

c:\> ping MyServer

I have a feeling that you can not see the server by its user friendly name. Can you ping it by it's IP address.

c:\ ping xxx.xxx.xxx.xxx

If so, then use the Client Network Utility for SQL Server and define an Alias to this server. Set the network library to TCP/IP, set the server alias name to the server name and enter the IP address for the server name.|||Thanks for the reply.

I will try this when I get home this evening :)