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

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net




"Roelof van Kooten" wrote:

> Is it possible to connect to SQL Server 2005 Workgroup using C# Express
> edition ?
>
> Thanks for your help,
>
> Roelof
>
>
>
>

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

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


"Roelof van Kooten" <roelof@vankooten> schreef in bericht
news:45a9444c$0$738$(E-Mail Removed)...
> Is it possible to connect to SQL Server 2005 Workgroup using C# Express
> edition ?
>
> Thanks for your help,
>
> Roelof
>
>
>