c# express edition and sql server2005 workgroup

  • Thread starter Thread starter Roelof van Kooten
  • Start date Start date
R

Roelof van Kooten

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

Thanks for your help,

Roelof
 
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
 
Is it possible to connect to SQL Server 2005 Workgroup using C# Express
edition ?
Click to expand...

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.
 
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
 
Back
Top