C# Express and SQL 2000

[Nobody]

Is it possible to connect to a SQL 2000 database? I can only seem to get C#
Express
to want to connect to a SQL Express database. Am I missing something?

Thanks

[Nicholas Paldino [.NET/C# MVP]]

Nobody,

You should be able to connect to a SQL Server database. I don't have
SQL Express installed, but you should be able to default the instance name
(which is .\SQLExpress) to the name of a server on your network, and connect
normally.

Do you find you can't do this?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Nobody" <tr*****@nobody.com> wrote in message
news:Ov**************@TK2MSFTNGP14.phx.gbl...

Is it possible to connect to a SQL 2000 database? I can only seem to get
C# Express
to want to connect to a SQL Express database. Am I missing something?

Thanks

[Nobody]

I'm unable to change the .\SQLExpress to anything else. It does give me a
drop
down to try and select something, but nothing is there. I'm unable to type
in
anything over this default setting.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:%2****************@TK2MSFTNGP14.phx.gbl...

Nobody,

You should be able to connect to a SQL Server database. I don't have
SQL Express installed, but you should be able to default the instance name
(which is .\SQLExpress) to the name of a server on your network, and
connect normally.

[Nicholas Paldino [.NET/C# MVP]]

Hmm, then no, you won't be able to use the designer to help you.

That doesn't mean that you can't connect to SQL Server 2000 through the
classes in the System.Data.SqlClient namespace, just that you don't have
designer support.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Nobody" <tr*****@nobody.com> wrote in message
news:ui**************@tk2msftngp13.phx.gbl...

I'm unable to change the .\SQLExpress to anything else. It does give me a
drop
down to try and select something, but nothing is there. I'm unable to type
in
anything over this default setting.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote
in message news:%2****************@TK2MSFTNGP14.phx.gbl...

Nobody,

You should be able to connect to a SQL Server database. I don't have
SQL Express installed, but you should be able to default the instance
name (which is .\SQLExpress) to the name of a server on your network, and
connect normally.

[Willy Denoyette [MVP]]

"Nobody" <tr*****@nobody.com> wrote in message
news:Ov**************@TK2MSFTNGP14.phx.gbl...

Is it possible to connect to a SQL 2000 database? I can only seem to get
C# Express
to want to connect to a SQL Express database. Am I missing something?

Thanks

You can't access non local database instances from VS Express products, you
can access external instances from your code.

Willy.