c# express edition and sql server2005 workgroup

[Roelof van Kooten]

Is it possible to connect to SQL Server 2005 Workgroup using C# Express
edition ?

Thanks for your help,

Roelof

 

[Guest]

You should be able to connect to any edition of Sql Server using the
SqlClient class.
This includes handy things like SqlConnection, SqlCommand, SqlParameter, etc.
Peter

 

[ForrestPhoto]

Is it possible to connect to SQL Server 2005 Workgroup using C# Express

edition ?

I'm not sure what SQL Workgroup is, but if you can get a connection to
the box it runs on, say in Windows Explorer, than you can get to it
through .net code. Just make a note of the server name ( or IP address
) and if there are more than one instance of SQL Server running on the
server, which one, then write up a connection string.

 

[Roelof van Kooten]

When making a new Connection in C# Express Edition I can choose from
following data sources:
- Microsoft SQL Server Database File (SQLClient)
- Microsoft Access Database File

When looking at sample application in C# more data sources are available.
The one I think I need is "Microsoft SQL Server". Through Database Explorer
in C# Express I can not add data sources. This makes me think C# Express can
only be used with the SQL Server 2005 Express Edition and probably I have to
change to another (Standard or Professional) version of Visual Studio 2005
to make a connection with SQL Server 2005 for Workgroups.

Any comments/help are welcome.

Thanks in advance,
Roelof